Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO thisTable
- SELECT TOP 100 * FROM anotherTable;
- INSERT INTO TableInserted
- SELECT *
- FROM (
- SELECT *,
- ROW_NUMBER() OVER (ORDER BY ID) AS RowNumber
- FROM TableSelected
- ) X
- WHERE RowNumber BETWEEN 101 AND 200
Add Comment
Please, Sign In to add comment