SQL 123

[rezania]

Hi
I get many rows of info from a table using a SQL Select statement,I just want to put a row number by the side of each resulting row, like:
1 jim
2 john
3 joe
4 james
5 ...
sounds simple, but... How?
Also any comments on how to print row numbers in DataReport would be nice.
Thanks

[JHausmann]

Why would you want to?

[rezania]

Hi again
The user wants me to print it!

[JHausmann]

The problem is, it's meaningless unless the data (row number) is stored.

[AKA]

If your record set is ordered by something for example name. Then it could look like this

SELECT
Name,
( SELECT
COUNT( * )
FROM
tblName N2
WHERE
N2.Name <= N1.Name
)
FROM
tblName N1
ORDER BY
Name
GROUP BY
Name


Might not be the best but it at least pops your thread to the top.

[rezania]

Hi
After Hitting my head on the wall for so many times, I have found that I could add a column to my recordset using Shape ... Append command with the NEW option, and then fill it with row numbers in a loop.
Thanks