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.
.png "Former Employee"){kind=icon}