Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Record number 1

Status
Not open for further replies.
Mandica

Mandica

Programmer
Jan 23, 2001
1
RO
Hi everybody
I'm new on this site.
I have a question. I did some views from my Sql Server 7 database for a Crystal Report. In one of this views I need to create a column wich contains record number. I don't know how.Can anyone help me?
Thank you,
Madalina
 
Sort by date Sort by votes
A very easy way to do this would be to create an identity column that increments by 1, and then you can use this column as your record number.

Another way would be to maintain a counter in cursor.

Tom Davis
tdavis@sark.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
623
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
How to give same number if it exist on table or new number if it not exist based on part value? 1
Replies
8
Views
519
Andrzejek
Andrzejek
ahmedsa2018
  • Locked
  • Question
How to display part number based on search string by chemical id ?
Replies
3
Views
342
gmmastros
gmmastros
scubafrog79
  • Locked
  • Question
Flag record if there two different locations for that record in another table 1
Replies
3
Views
300
Andrzejek
Andrzejek
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
647
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top