DECLARE @NumberOfScenario INT
DECLARE @IsTrue BIT=1
DECLARE CustList CURSOR FOR
      SELECT COUNT(ProjectID) FROM dbo.Scenario 
        WHERE ProjectID IN (SELECT ID FROM Project WHERE Expired=0) And  Expired=0 
          GROUP BY ProjectID
OPEN CustList
FETCH NEXT FROM CustList INTO @NumberOfScenario

  WHILE @@FETCH_STATUS = 0
    BEGIN
    PRINT  @NumberOfScenario
      IF @NumberOfScenario <>1 
        BEGIN
          SET @IsTrue=0
          BREAK
        END

      FETCH NEXT FROM CustList INTO @NumberOfScenario
    END
    PRINT 'Closed'
CLOSE CustList
DEALLOCATE CustList

SELECT @IsTrue AS IsTrue