Sybase -- Doubt on Cursor logic -- Please help

May 21, 2017 at 21:54:57
Specs: Windows 7
Hi Team,

Can anyone please help me to resolve the below logic.

I want to insert a new record as combined (StampId) if the invoice type and Debit Date are same for set of records like below. I know we can do in Cursor but not sure how could i identify the records which has same invoice type and Debit date then insert new record as Combined. Please help to resolve this.

Stamp Id Invoice Type Debit Date   
Combined Savings 17-02-2017 -------> New Record to be inserted as Combined
23136 Savings 17-02-2017
23136 Savings 17-02-2017
Combined Xyz 25-04-2017 -------> New Record to be inserted as Combined
23297 Xyz 25-04-2017
23290 Xyz 25-04-2017


See More: Sybase -- Doubt on Cursor logic -- Please help

Report •
Related Solutions


Ask Question