CREATE TABLE Membership (
membershipId INT
);
WITH gen AS (
SELECT 1 AS num
UNION ALL
SELECT num+1 FROM gen WHERE num+1<=50
)
INSERT INTO Membership SELECT * FROM gen;
SELECT TOP (10) m.membershipId FROM Membership AS m;
CREATE TABLE [Service Membership] (
[Member ID] INT
);
WITH gen AS (
SELECT 1 AS num
UNION ALL
SELECT num+1 FROM gen WHERE num+1<=50
)
INSERT INTO [Service Membership] SELECT * FROM gen;
SELECT TOP (10) m.[Member ID] FROM [Service Membership] AS m;