How to combine SQL Cursor with CASE WHEN ?
I have a curosr as below: DECLARE Cur CURSOR FOR SELECT DISTINCT BranchCode FROM #ABC OPEN Cur FETCH NEXT FROM Cur INTO @BBB WHILE @@FETCH_STATUS = 0 BEGIN SET @I = 1 WHILE @I <= 2 BEGIN SET @CT='0001' SET @NUM1 = ISNULL((SELECT COUNT(Amount) FROM #ABC WHERE BCODE=@BCode AND CaseType=@CT), 0) SET @AM1 = ISNULL((SELECT SUM(Amount) FROM #ABC WHERE BCODE=@BCode AND CaseType=@CT), 0) INSERT TO TABLENAME VALUES(@NUM1,@AM1 ) END FETCH NEXT FROM Cur INTO @BBB END CLOSE Cur DEALLOCATE Cur When i add one more condition it has error as below : SET @AM1 = ISNULL((SELECT SUM((CASE WHEN @C=1 THEN Amount/1 WHEN @C2= THEN AMOUNT/2)) FROM #ABC WHERE BCODE=@BCode AND CaseType=@CType), 0) Please help
December 12th, 2010 10:24pm

Post this question in Transact-SQL discussion group: http://social.msdn.microsoft.com/Forums/en-US/transactsql/threadsChaitanya
Free Windows Admin Tool Kit Click here and download it now
December 13th, 2010 1:41am

Post this question in Transact-SQL discussion group: http://social.msdn.microsoft.com/Forums/en-US/transactsql/threadsChaitanya
December 13th, 2010 1:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics