Monday, October 07, 2013

SQL Random Number Generator

DECLARE @Random INT;
DECLARE @RandomChar CHAR(15);
DECLARE @Upper INT;
DECLARE @Lower INT

---- This will create a random number between 1 and 999
SET @Lower = 1 ---- The lowest random number
SET @Upper = 999 ---- The highest random number
SELECT @Random = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0)
SET @RandomChar =  (SELECT CAST(@Random AS CHAR(3)))


SET @srvc_code = 'New_Code-' + @RandomChar