USE [censusweb_mdb]
GO


IF NOT EXISTS( SELECT * FROM [dbo].[tblWebViews] WHERE [nViewID]=87 )
	INSERT [dbo].[tblWebViews] ([nViewID], [tViewName], [nProjectID], [tFileLocation], [tAlias], [nTimeOut], [bLocked], 
	[tLastFileLocation], [bGenerated], [nWebSite], [nMaxLinesPerPage], [tWebServer], [tVdPath], [nFeatureId], [bIntegrateSCC], 
	[bReadOnly], [tURL], [tAnonUser], [tAnonPwd], [nVDInfoDirty], [dLastGen], [dNextGen]) 
	VALUES (87, N'Configuration', 28, (SELECT [tFileLocation] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), 
	N'connect', NULL, 0, (SELECT [tLastFileLocation] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), 0, 
	(SELECT [nWebSite] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), NULL, 
	(SELECT [tWebServer] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), 
	(SELECT [tVdPath] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), 8191, 0, 0, 
	(SELECT [tURL] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), 
	(SELECT [tAnonUser] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), 
	(SELECT [tAnonPwd] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), -1, NULL, NULL)
GO

