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