How to display the Record nUmber alongwith other fields.
For example if i have table with name and address, I would
like to have the o/p as

Record# Name Address
1 xx yyy
....

Thanxs for the timely help

Regards,
Prem



*** Sent via Developersdex http://www.developersdex.com ***

Prem,

There isn't anything called "record number" assignement to each row in sql. To generate
row numbers on the basis of the existing row integrity in the table you can have following
approach or refer to url that i've mentioned.

-- see following example on northwind database. if the combination of contactname and
address
-- is unique then following query may satisfy your requirement.
Ex:
use northwind
go
select
(select count(*) from customers a
where a.contactname + a.address <= customers.contactname + customers.address
)
rownum,
contactname,address
from customers
order by 1
go

-- Refer to following url
HOW TO: Dynamically Number Rows in a Select Statement
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133

--
- Vishal