Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 591 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

Determining a Sequence Number by using Max() Function


 Article Abstract:

(Yuli Vasiliev) In some applications, you may need to determine a sequence number that is to be, for example, the document number. There are a few different techniques that you may use to determine a sequence number when inserting a new row into a table. In this article we discuss how you can do this by using the max() function.

 Read this article...
 Related Articles - For Members.
All Articles By Author

Sequence Objects and Identity Columns
Split Comma Separated Data Into A Table
Use a Sequence Table To Perform String Magic
Rolling Window, Grouping Tables and More
How to find whether a decimal number is divisible by another decimal number?
Querying 'top sequences'
Finding the Nth Max / Min Value from a Value Set
Error Handling in SQL Server 2005



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

Reader Comments: Post Your Comments/Feedback

RE: Determining a Sequence Number by using Max() Function
(posted: 4/8/2004 6:35:22 AM)
I don't think this is for SQL Server, yet it was sent out on the SQL Field Notes which I though was SQL Server specific


Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2009, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004