>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>