USE [HelpDesk02_Def]
GO


/***  COMMUNICATION RECEIVED  ***/
IF NOT EXISTS( SELECT * FROM [dbo].[tblSystemQueries] WHERE nID=23 )
		INSERT [dbo].[tblSystemQueries] ([nID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [nDtsFieldID], [nValueType]) 
		VALUES (23, N'Communication Received', N'=', N'Yes', NULL, NULL, NULL, NULL, NULL, 1, 100, NULL);
GO

/***  REPAIRS  ***/
IF NOT EXISTS( SELECT * FROM [dbo].[tblSystemQueries] WHERE nID=24 )
		INSERT [dbo].[tblSystemQueries] ([nID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [nDtsFieldID], [nValueType]) 
		VALUES (24, N'Ticket Type', N'=', N'Repair', NULL, NULL, NULL, NULL, NULL, 1,364, NULL);
GO

