· 6 years ago · Apr 19, 2019, 07:52 AM
1exec sp_set_session_context N'AdminUser',1
2
3IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'OnPrems')
4 DROP TABLE [adm].[OnPrems]
5
6CREATE TABLE [adm].[OnPrems](
7 [Key] [bigint] NOT NULL
8 CONSTRAINT [PK_OnPrems] PRIMARY KEY CLUSTERED
9(
10 [Key] ASC
11)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
12) ON [PRIMARY]
13GO
14
15ALTER TABLE [adm].[OnPrems] WITH CHECK ADD CONSTRAINT [FKOnPrems_Groups_Key] FOREIGN KEY([Key])
16REFERENCES [adm].[Groups] ([Key])
17GO
18
19
20INSERT INTO [adm].[OnPrems] ([Key]) (SELECT ce.[Key] FROM adm.CrosscutEntities ce join adm.Groups g on g.[Key] = ce.[Key] WHERE Id != '9A391EB4-8C13-4ACD-AA8C-9182083F4A03')