autonumber

[zturaiki]

this is my original data Original Data
Id	Date
A1	5/12/13 12:00 AM
A1	5/13/13 12:00 AM
A1	5/14/13 12:00 AM
A1	5/15/13 12:00 AM
B2	5/16/13 12:00 AM
B2	5/17/13 12:00 AM
C4	5/18/13 12:00 AM
C4	5/19/13 12:00 AM
C4	5/20/13 12:00 AM
D5	5/21/13 12:00 AM
E6	5/22/13 12:00 AM
I want That   Result From Above
Id	Date	Row No
A1	5/12/13 12:00 AM	1
A1	5/13/13 12:00 AM	2
A1	5/14/13 12:00 AM	3
A1	5/15/13 12:00 AM	4
B2	5/16/13 12:00 AM	1
B2	5/17/13 12:00 AM	2
C4	5/18/13 12:00 AM	1
C4	5/19/13 12:00 AM	2
C4	5/20/13 12:00 AM	3
D5	5/21/13 12:00 AM	1
E6	5/22/13 12:00 AM	1

[zturaiki]

it take more time

[#3]

Use Rownum ()

its very common to use auto genrate numbers.

Regards

Asim

[sunilkumarqv]

Good work done by  VISHWARANJAN  and

to Zainab make order by date in your script table things done easy.

[Anonymous]

Load

     field1,

     field2,

     Rowno() As Rowno

From yourtable;

anant

[#6]

Hi Vishwa,

Could please let know for the above mentioned data and one more request(while loading the data from excel how to do the same).

Regards,

Rajesh