Select max(numb_field) + 1

This can be used to insert later.

-----Original Message-----
From: Hornak Wayne
[mailto:mssqldba-ezmlmshield-x84458119.[Email address protected]
Sent: Thursday, April 28, 2005 11:13 AM
To: LazyDBA Discussion
Subject: Sequential Number Creation

How do I create a unique sequential number within the result of a sql
statement?


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you.
MS Sql Server LazyDBA home page