Skip to content

Instantly share code, notes, and snippets.

@shaneis
Created April 19, 2018 10:22
Show Gist options
  • Save shaneis/551a842f1dfb90853866d5a0ffbf2d20 to your computer and use it in GitHub Desktop.
Save shaneis/551a842f1dfb90853866d5a0ffbf2d20 to your computer and use it in GitHub Desktop.
Sets up the tables to show the SQL Prompt error
USE tempdb;
IF OBJECT_ID(N'dbo.DummyTable', N'U') IS NOT NULL
DROP TABLE dbo.DummyTable;
GO
CREATE TABLE dbo.DummyTable (
DummyId int IDENTITY(1, 1)
CONSTRAINT PK_DummyTable PRIMARY KEY,
PartitionId tinyint NOT NULL
);
GO
INSERT INTO dbo.DummyTable (
PartitionId
)
SELECT TOP (1000)
number % 5
FROM [master].dbo.spt_values
WHERE [type] = N'P';
GO
SELECT DummyId,
PartitionId,
ROW_NUMBER() OVER (PARTITION BY PartitionId ORDER BY DummyId DESC) AS LastN
FROM dbo.DummyTable;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment