|
| 
| Submitted on: 2/11/2001 3:17:50 PM
By: Ed McColl
Level: Advanced
User Rating:
By 5 Users
Compatibility:SQL Server 7.0, SQL Server 6.5 and earlier
Users have accessed this code 3367 times.
| |
| | | This code generates random numbers within a given range
| |
| |
|
code:
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for langauges that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description. |
--**************************************
--
-- Name: RandomBetween
-- Description:This code generates rando
-- m numbers within a given range
-- By: Ed McColl
--
-- Inputs:@lowerbound INT
@upperbound INT
--
-- Returns:An integer between @lowerboun
-- d and @upperbound
--
--This code is copyrighted and has-- limited warranties.Please see http://
-- www.Planet-Source-Code.com/xq/ASP/txtCod
-- eId.276/lngWId.5/qx/vb/scripts/ShowCode.
-- htm--for details.--**************************************
--
CREATE PROCEDURE RandomBetween
@lowerbound INT,
@upperbound INT
AS
RETURN ROUND( ((@upperbound - @lowerbound) * (RAND(convert(int, convert(varbinary, newid())))) + @lowerbound), 0)
| |
| |
| Report Bad Submission |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
8/30/2001 1:25:32 AM:george
This works in SQL2000 but I can't test
to see if this would work in SQL7.
Newid() doesn't actually produce random
results in SQL7 the last I used it!
|
1/10/2002 11:28:19 AM:James Brewster
I'a relative SQL newbie and i'm looking
to mod this code slightly so that the
range is the minimum and maximum ID in
a table, like so:
SELECT
MIN(CompanyID) AS Lowerbound,
MAX(CompanyID) AS Upperbound
FROM
dbo.CompaniesRecordset
Is this
possible, and could you gimme a
hand?!
Thanks for even reading
this...
James
|
|
| Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular code, please click here.
|
|
