DECLARE @sql NVARCHAR(MAX) DECLARE @COUNT INT, @status INT DECLARE @cursor CURSOR SET @cursor = CURSOR FOR SELECT dbo.CRF_Project.DocStatus FROM vsCustomizationRequest.dbo.CRF_Project WHERE CustomerID = '1' OPEN @cursor FETCH NEXT FROM @cursor into @status WHILE @@FETCH_STATUS = 0 BEGIN --HERE --IF(@status = 0) --SET @COUNT = @COUNT + 1 --PRINT @COUNT --I CANT DISPLAY IT OUT FETCH NEXT FROM @cursor into @status END CLOSE @cursor DEALLOCATE @cursor
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)