USE [Resources02_Def]
GO

IF NOT EXISTS (SELECT * FROM [dbo].[tblSystemReportListings]  WHERE nID=50)
BEGIN
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Allocated to Device / Computer', 10, 1, 1099)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Asset Class', 10, 2, 1092)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Asset Type', 10, 3, 1093)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Assigned to Person', 10, 4, 11)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Assigned Date', 10, 5, 7)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Name', 10, 6, 30)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Allocated to Department', 10, 7, 1019)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Serial Number', 10, 8, 919)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Asset Tag', 10, 9, 921)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Model', 10, 10, 918)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Manufacturer', 10, 11, 894)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Container', 10, 12, 1095)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Track As', 10, 14, 993)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Status', 10, 15, 865)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Location', 10, 16, 882)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Company Name', 10, 17, 600)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Usage Type', 10, 18, 806)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) VALUES (50, N'Left', N'Left', N'Responsible of Container', 10, 13, 76)
END
	

IF NOT EXISTS (SELECT * FROM [dbo].[tblSystemReportListings]  WHERE nID=48 AND nDtsFieldID=919)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) 
		VALUES (48, N'Left', N'Left', N'Serial Number', 10, 8, 919)

IF NOT EXISTS (SELECT * FROM [dbo].[tblSystemReportListings]  WHERE nID=48 AND nDtsFieldID=921)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) 
		VALUES (48, N'Left', N'Left', N'Asset Tag', 10, 9, 921)

IF NOT EXISTS (SELECT * FROM [dbo].[tblSystemReportListings]  WHERE nID=48 AND nDtsFieldID=894)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) 
		VALUES (48, N'Left', N'Left', N'Manufacturer', 10, 10, 894)

IF NOT EXISTS (SELECT * FROM [dbo].[tblSystemReportListings]  WHERE nID=48 AND nDtsFieldID=918)
	INSERT [dbo].[tblSystemReportListings] ([nID], [tFieldAlignment], [tValueAlignment], [tTitle], [nValueWidth], [nRow], [nDtsFieldID]) 
		VALUES (48, N'Left', N'Left', N'Model', 10, 11, 918)

GO
	
	