USE [censusweb_mdb]
GO
IF NOT EXISTS(SELECT * FROM [tblViewGroupAccess] WHERE nViewID=86 AND tGroup='Admins')
	INSERT [dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) 
	VALUES (N'Admins', 86, NULL);
GO

IF NOT EXISTS(SELECT * FROM [tblViewGroupAccess] WHERE nViewID=86 AND tGroup='Chromebook Managers')
	INSERT [dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) 
	VALUES (N'Chromebook Managers', 86, NULL);
GO
	
IF NOT EXISTS(SELECT * FROM [tblViewGroupAccess] WHERE nViewID=86 AND tGroup='IT Asset Managers')
	INSERT [dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) 
	VALUES (N'IT Asset Managers', 86, NULL);
GO


IF NOT EXISTS(SELECT * FROM [tblViewGroupAccess] WHERE nViewID=72 AND tGroup='Admins')
	INSERT [dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) 
	VALUES (N'Admins', 72, NULL);
GO

IF NOT EXISTS(SELECT * FROM [tblViewGroupAccess] WHERE nViewID=72 AND tGroup='Asset Type Admins')
	INSERT [dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) 
	VALUES (N'Asset Type Admins', 72, NULL);
GO

IF NOT EXISTS(SELECT * FROM [tblViewGroupAccess] WHERE nViewID=72 AND tGroup='Chromebook Managers')
	INSERT [dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) 
	VALUES (N'Chromebook Managers', 72, NULL);

GO
