Posted by --CELKO-- on 06/10/07 15:39

>> I just want to make a random id number based on 4 digits <<

Since it for an identifier this implies that there are no duplicates
("sampling without replacement" if you want to look it up). And there
are only values 0000 thru 9999 available to you. Just generate a
table of 10,000 rows and pull one out as you need it. m

• Next in forum: Re: How to Gnerate a Random ID Number
• Prev in forum: TSQL coding style - an example
• Thread view: Re: How to Gnerate a Random ID Number

[Reply to this message]