Skip to content

Instantly share code, notes, and snippets.

@DoubleBrotherProgrammer

DoubleBrotherProgrammer/tSQL : Select random value using CTE

Created November 20, 2009 20:10
Show Gist options
  • Save DoubleBrotherProgrammer/239738 to your computer and use it in GitHub Desktop.
Save DoubleBrotherProgrammer/239738 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tSQL : Select random value using CTE
-- define our data table
WITH data( num )
AS
(
-- our value range in a single query
SELECT 0 AS 'num'
UNION
SELECT 512 AS 'num'
UNION
SELECT 1024 AS 'num'
UNION
SELECT 1536 AS 'num'
UNION
SELECT 2048 AS 'num'
)
SELECT TOP 1 num FROM data
ORDER BY NEWID()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment