I Need to generate a random number between two numbers for each row.
For Eg:
select ColName,(Random nos between 1500 to 2000) from TableName
Thanks in advance
DECLARE @start INT
DECLARE @end INT
SET @start = 1500
SET @end = 2000
SELECT Round(( ( @end - @start - 1 ) * Rand() + @start ), 0)
Update : To get random number for each row.
select ABS(Checksum(NewID()) % (@end-@start)) + @start