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