Sets up the tables to show the SQL Prompt error

SQLPromptError_SetUp.sql

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;