>>Dcode – Pcode – Payment – Discount >>1 - 1 - 10000 - 0 >>1 - 1 - 40000 - 0 >>1 - 1 - 20000 - 1000 >>1 - 2 - 30000 - 0 >>>>I want to write a SQL that make a cursor as below
>>Dcode – pcode – payment – DisNum – UnDisNum >>1 - 1 - 70000 - 1 – 2 >>1 - 2 - 30000 - 0 - 1 >>>>Here is my SQL
>>Select Main.DCode, Main.PCode, SUM(Payment), sum(IIF(Disount>0,1,0000000000)) as DisNum, > sum(IIF(Disount>0,0000000000,1)) as UnDisNum ; >>From Main ; >>Group by Main.DCode,Main.PCode ; >>Into cursor TempCrs Readwrite>>