Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the below
distinct %B
usinessDate,
RecNo() as Rowid
//Group by %BusinessDate
Resident SMI_Collateral;
What I need to do is get unique days from the table and then assign an id so
1 01 jab 2015
2 02 jan 2015
Unfortunately, it duplicates the data, I need something a group by. I know I can do it i first get the unique date and then second step do the insertion into second temp table but should be way just to get the unique values with an incremental id next?
Thank you.
Maybe you need rowno - RecNo or RowNo?
- Marcus
Try RowNo. Or, depending on where your data is coming from in the first place you could use IDENTITY(1,1) in a SQL SELECT to get similar functionality.
It sounds like you should use Autonumber()... See Counters in the Load
HIC