[Tips] Create numbers 0 to 23 query November 21, 2014 Oktay Leave a comment Query below creates numbers 0 to 23. WITH Hours(h) AS ( SELECT 0 UNION ALL SELECT h+1 FROM Hours WHERE h < 23 ) SELECT h FROM Hours Email ThisBlogThis!Share to XShare to Facebook
0 comments:
Post a Comment