SQL Server 2000 Help

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.

## Deliverables

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).

## Platform

SQL Server 2000

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: package sql, statement problem example, simple problem statement example, program problem statement, problem statement example, components problem statement, problem statement, ted, server help, fred, simple sql program, recordset, php sql 2000, sql statement help, sql run package, sql select, sql problem, site ted, problem statement need database, looking sql server, ted site, simple sql software, php form sql, sql simple work, simple selectable form

Acerca do Empregador:
( 3 comentários ) United States

ID do Projeto: #2986221