hello all,
I have a table and want to add sale reference number (srn) starting at say 1000 incrementing by one each time an outcome is a sale , eg
Row customer outcome SRN
1 cust1 no answer null
2 cust2 do not call null
3 cust3 sale 1000
4 cust4 no answer null
5 cust5 sale 1001
6 cust6 sale 1002
The number will be assigned at the end of each day. Does this need a cursor, and would it be a fairly straightforward one to learn on
I have a table and want to add sale reference number (srn) starting at say 1000 incrementing by one each time an outcome is a sale , eg
Row customer outcome SRN
1 cust1 no answer null
2 cust2 do not call null
3 cust3 sale 1000
4 cust4 no answer null
5 cust5 sale 1001
6 cust6 sale 1002
The number will be assigned at the end of each day. Does this need a cursor, and would it be a fairly straightforward one to learn on