USE [censusweb_mdb]
GO
IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=2)
	INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 2, N'100');
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=6)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 6, N'<None>')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=7)

INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 7, N'Charge Backs & Fines')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=8)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 8, N'Charge Backs & Fines')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=13)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 13, N'2')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=22)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 22, N'798;800;799')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=23)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 23, N'action')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=24)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 24, N'actions')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=28)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 28, N'an')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=14)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 14, N'6')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=15)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 15, N'6')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=21)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 21, N'26')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=38)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 38, N'2')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=37)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 37, N'QLActions.png')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=86 AND nViewAttributeID=27)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (86, 27, N'Fines and charges made to students, teachers or staff')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=38)
	INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 38, N'105')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=27)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 27, N'Check out and assign assets to people. Check them in when returned. Use barcode readers for faster processing.')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=6)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 6, N'<None>')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=7)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 7, N'Asset Check In / Check Out')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=8)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 8, N'Asset Check In / Check Out')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=13)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 13, N'62')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=15)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 15, N'14')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=16)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 16, N'0')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=21)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 21, N'50')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=22)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 22, N'798')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=24)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 24, N'assets')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=23)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 23, N'asset')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=28)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 28, N'an')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=2)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 2, N'100')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=37)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 37, N'scannericon_small.png')
GO

IF NOT EXISTS(SELECT * FROM [tblWebViewAttribute] WHERE nViewID=72 AND nViewAttributeID=14)
INSERT [dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (72, 14, N'26')

GO
