Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jotmenow
Starting Member
12 Posts |
 Posted - 2007-03-27 : 06:07:36
|
| I have a table with similar dataset as below.Iam trying to create a sequence for col1 in col2.col1 col2Ajay 1Ajay 2Ajay 3Ajay 3Ajay 3Ajay 3Anil 1Anil 1So output should be some thing like thisAjay 1Ajay 2Ajay 3Ajay 4Ajay 5Ajay 6Anil 1Anil 2IS there any way i can do this with out a procedure???THnz a lot in AdvanceAjay. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-27 : 06:42:24
|
"IS there any way i can do this with out a procedure???"Yes. Do it in your front end 
KH |
 |
|
|
|
|
|
Sql sequence