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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-29 : 23:53:37
|
Peter writes "I need to produce a query from a set of data that has an index on each row in the range 0..n. This recordset will be saved into a Stream to be persisted as XML so that a XSL style sheet can be applied to it. An example would be a table with columns A and B containing data. I want to make up a column C which holds a unique index starting at zero identifying each row.
A B "C"
aa bb 0
ab bc 1
ac bd 2
. . .
ay bz n
can it be done on the fly without hardcoding an index into the table or creating dummy tables or views?" |
|
|
|
|
|
creating a rowindex field in a query or stored procedure