Skip to content

Instantly share code, notes, and snippets.

@juan-fdz-hawa

juan-fdz-hawa/gist:6ad3fb72b3d71f28617ed2f3721790fa

Created May 31, 2016 19:18
Show Gist options
  • Save juan-fdz-hawa/6ad3fb72b3d71f28617ed2f3721790fa to your computer and use it in GitHub Desktop.
Save juan-fdz-hawa/6ad3fb72b3d71f28617ed2f3721790fa to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT
ROW_NUMBER() OVER (Order by (select 0)) AS RowNumber,
(CASE WHEN CONVERT(INT, (ROW_NUMBER() OVER (ORDER BY (SELECT 0)) % 16)) = 0 THEN 0 ELSE 1 END) + CONVERT(INT, (ROW_NUMBER() OVER (ORDER BY (SELECT 0)) / 16)) as PageGroup,
(CASE WHEN CONVERT(INT, (ROW_NUMBER() OVER (ORDER BY (SELECT 0)) % 8)) = 0 THEN 0 ELSE 1 END) + CONVERT(INT, (ROW_NUMBER() OVER (ORDER BY (SELECT 0)) / 8)) as RowGroup,
*
FROM <<TABLE>>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment