HI All
When i run a view from sqlserver i would like for it to return a autonumber against each item selected
How would i go about this
Simple Example
Table setup
Name Age
M 18
C 19
D 18
F 21
G 18
Code:
Select * from table where age ='18'
Result i would like to see would be as follows
AutoNum Name Age
1 M 18
2 D 18
3 G 18
Any help grately appreciated
When i run a view from sqlserver i would like for it to return a autonumber against each item selected
How would i go about this
Simple Example
Table setup
Name Age
M 18
C 19
D 18
F 21
G 18
Code:
Select * from table where age ='18'
Result i would like to see would be as follows
AutoNum Name Age
1 M 18
2 D 18
3 G 18
Any help grately appreciated