USE [Resources02_Def]
GO
IF NOT EXISTS( SELECT * FROM [dbo].[tblSystemCustomQueries] WHERE [nID]=66 )
	INSERT [dbo].[tblSystemCustomQueries] ([nID], [tName], [tCaption], [nParentTableID], [fFieldsChanged], [nDefaultSort], [nDefaultLayout]) 
	VALUES (66, N'Assets$In$Storage', N'Assets In Storage', 6, 5, NULL, NULL)
GO

IF NOT EXISTS( SELECT * FROM [dbo].[tblSystemCustomQueries] WHERE [nID]=67 )
	INSERT [dbo].[tblSystemCustomQueries] ([nID], [tName], [tCaption], [nParentTableID], [fFieldsChanged], [nDefaultSort], [nDefaultLayout]) 
	VALUES (67, N'Software$Allocated$to$Devices', N'Software Allocated to Devices', 6, 2, NULL, NULL)
GO

IF NOT EXISTS( SELECT * FROM [dbo].[tblSystemCustomQueries] WHERE [nID]=68 )
	INSERT [dbo].[tblSystemCustomQueries] ([nID], [tName], [tCaption], [nParentTableID], [fFieldsChanged], [nDefaultSort], [nDefaultLayout]) 
	VALUES (68, N'Available$for$Allocation', N'Available for Allocation', 6, 2, NULL, NULL)
GO


