Declare @MinValueWanted int = 500, @MaxValueWanted int = 3000; Select abs(cast(newid() as binary(6)) % (1 + 9006 - 9001)) + 9001; USE OLIS_DATA_DEMO; /************/ --24_StaffNumberOfPersonInjured UPDATE [dbo].[AIRSData] SET [24_StaffNumberOfPersonInjured] = abs(cast(newid() as binary(6)) % (1 + 9006 - 9001)) + 9001 WHERE [24_StaffNumberOfPersonInjured] =9004 AND [AIRSID] > 54812
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter