I am looking for a solution to what would appear to be a simple SQL Server problem.
Essentially, I have a SELECT statement that works fine. What I need added to this select statement is the current record number.
For example, (SELECT [url removed, login to view], [url removed, login to view] FROM Member M WHERE [url removed, login to view] = 'Williams') returns 5 records. I also need to add the record number to each record. So, I need the recordset to have the first name, the last name, AND the record number. Record number is not a selectable field in the database. Something like this:
RecNum LastName FirstName
1 Williams Bob
2 Williams Chris
3 Williams Fred
4 Williams George
5 Williams Ted
This looks so simple, but has caused me many headaches.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
SQL Server 2000