----delete ZVN_ReportList_mst---------------
IF   EXISTS(SELECT 1 FROM ZVN_ReportList_mst WHERE ReportId = 'KT18' AND SiteRef = 'PVD')
	 DELETE  FROM dbo.ZVN_ReportList_mst WHERE ReportId = 'KT18' AND SiteRef='PVD'
GO
----insert ZVN_ReportList_mst---------------
IF NOT  EXISTS(SELECT 1 FROM ZVN_ReportList_mst WHERE ReportId = 'KT18' AND SiteRef = 'PVD')
BEGIN

	INSERT dbo.ZVN_ReportList_mst
	(
		CreatedBy,
		UpdatedBy,
		CreateDate,
		RecordDate,
		RowPointer,
		NoteExistsFlag,
		InWorkflow,
		SiteRef,
		ReportId,
		ReportName,
		ReportGroup,
		ReportParams,
		BGTaskName,
		RequiredParams,
		ReportProfile,
		ReportOptions
	)
	VALUES
	(   'sa', -- CreatedBy - UsernameType
		'sa', -- UpdatedBy - UsernameType
		GETDATE(), -- CreateDate - CurrentDateType
		GETDATE(), -- RecordDate - CurrentDateType
		NEWID(), -- RowPointer - RowPointerType
		0, -- NoteExistsFlag - FlagNyType
		0, -- InWorkflow - FlagNyType
		'PVD', -- SiteRef - SiteType
		N'KT18',  -- ReportId - nvarchar(50)
		N'KT18 - Báo cáo xuất nhập tồn theo dự án',  -- ReportName - nvarchar(250)
		N'SX',  -- ReportGroup - nvarchar(10)
		--N'V(vDate1),V(vDate2),V(vWarehouse),V(vLoc),V(vProducCode),V(vAcct),V(vSite), V(vProj),V(vItem)' ,-- ReportParams - nvarchar(250)
		N'V(vDate1),V(vDate2),V(vWarehouse),V(vAcct),V(vProductCode),V(vloc)' ,-- ReportParams - nvarchar(250)
		N'PVG_Rpt_GetQtyNXT',  -- BGTaskName - nvarchar(100)
		N'V(vDate1),V(vDate2)',  -- RequiredParams - nvarchar(250)
		N'',  -- ReportProfile - nvarchar(250)
		N''   -- ReportOptions - nvarchar(500)
		)

END
GO

	----insert BGTaskDefinitions---------------
	IF NOT EXISTS(SELECT 1 FROM BGTaskDefinitions WHERE TaskName = 'PVG_Rpt_GetQtyNXT')
	BEGIN

		INSERT dbo.BGTaskDefinitions
		(
			TaskName,								TaskTypeCode,							TaskExecutable,
			ExclusiveFlag,							TaskDescription,						MaxConcurrent,
			NoteExistsFlag,							CreatedBy,								UpdatedBy,
			CreateDate,								RecordDate,								RowPointer,
			InWorkflow,								IsolationLevel,							ReportType
		)
		SELECT
			'PVG_Rpt_GetQtyNXT',			'RPT',									'PVG_Rpt_GetQtyNXT',
			0,										'PVG_Rpt_GetQtyNXT'	, 20,
			0,										'sa',									'sa',
			GETDATE(),								GETDATE(),								NEWID(),
			0,										NULL,									'SSRS'

	 END

				  --SELECT * FROM ZVN_ReportList_mst WHERE ReportId ='KT18'