Advertisement
kromm77

SQL SERVER - row from values

Nov 25th, 2015
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.37 KB | None | 0 0
  1. SELECT ones.n + 10*tens.n + 100*hundreds.n + 1000*thousands.n
  2. FROM
  3.            (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) ones(n)
  4. INNER JOIN (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) tens(n) ON 1=1
  5. INNER JOIN (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) hundreds(n) ON 1=1
  6. INNER JOIN (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) thousands(n) ON 1=1
  7. ORDER BY 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement