Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: TSQL
Expertise: Advanced
Aug 4, 2003

Sequence a Number Field Without an Identity Column

To begin, create a table with dummy records:

Create table Table1 (
    [Record Value] varchar(20),    [Record Date] smalldatetime
)
go
insert into table1 values ('Record 1','07/21/2003')
insert into table1 values ('Record 2','07/22/2003')
insert into table1 values ('Record 3','07/23/2003')
insert into table1 values ('Record 4','07/24/2003')
insert into table1 values ('Record 5','07/25/2003')
insert into table1 values ('Record 6','07/26/2003')
Next, use this TSQL statement to sequence the number field:
 
select [Record Value],[Record Date],SeqNumber=
(select count(*) from Table1 
//as MyTable where MyTable.[Record Date]<table1.[Record date])
+1 from table1
K.Nageswara Rao
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date