TSQL Insert Update

USE [Reports]
GO
/****** Object:  StoredProcedure SET ANSI_NULLS ON
 
GO
SET QUOTED_IDENTIFIER ON
GO
 
--Unit Type fields added to both parts of the Union query
 
ALTER PROCEDURE [dbo].[sp_rptSalesSchedule]
	
	@FromDate DATETIME,
	@ToDate DATETIME
 
AS
 
BEGIN
 
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[rptSalesSchedule]') 
		AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [rptSalesSchedule]
 
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[rptSalesSchedule]') 
		AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
 
CREATE TABLE [rptSalesSchedule] (
	[01_PCode3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[02_PCode2] [varchar] (50),
	[03_PCode] [varchar] (50),
	[04_Engineers] [varchar] (50),
	[05_Appt Date] [varchar] (50),
	[06_Appt Time] [varchar] (50),
	[07_SSPX] [varchar] (50),
	[08_GCN] [varchar] (50),
	[09_WT] [varchar] (50),
	[10_Report Cat] [varchar] (50),
	[11_Unit Type] [varchar] (50),
	[12_Supplier] [varchar] (50),
	[12_Month] [varchar] (50),
	[12_Report] [varchar] (50)
) ON [PRIMARY]
 
 
--INSERT INTO [rptSalesSchedule] GCN SELECT GroupCustName AS GCN FROM rptSalesSchedule
 
---- [01_PCode3]
--UPDATE tblSalesSchedule
--SET [01_PCode3]=
 
 
---- [02_PCode2]
--UPDATE tblSalesSchedule
--SET [02_PCode2]=
 
 
---- [03_PCode]
--UPDATE tblSalesSchedule
--SET [03_PCode]=
 
 
SELECT DISTINCT
	TblApptDetails.ApptDetailsID,
	TblJobDetails.Jobcode,
	Null AS [Commscode],
	TblSSPX.SSPX AS SSPX, 
	TblGroupCustNameLog.GroupCustName AS GCN,
	TblSiteDetails.SitePostcode AS SitePostcode,
	TblJobType.JobType AS JobType,
	TblResource.Fullname AS [Sales Name],
 
 		dbo.FormatDateTime(TblApptDetails.ApptConfirmedDate, 'DD/MM/YYYY') 
			AS [Confirmed Date], 
 
		CASE 
				WHEN dbo.FormatDateTime(TblApptDetails.ApptConfirmedTime,'hh:mm 24') <> '00:00' 
				THEN dbo.FormatDateTime(TblApptDetails.ApptConfirmedTime,'hh:mm 24')
			ELSE  dbo.FormatDateTime(TblApptDetails.TimeSlotFrom,'hh:mm 24') + ' - ' 
							+ dbo.FormatDateTime(TblApptDetails.TimeSlotTo,'hh:mm 24')
		END AS 'Latest Confirmed Time'
 
FROM TblProgressStatus
		INNER JOIN
			TblJobStatusLog ON TblProgressStatus.ProgressStatusID = TblJobStatusLog.ProgressStatusFK 
		INNER JOIN
			TblResourcesRequired 
		INNER JOIN
			TblSSPX 
		INNER JOIN
			TblGroupCustNameLog ON TblSSPX.SSPXID = TblGroupCustNameLog.SSPXFK 
		INNER JOIN
			TblCustomerLog ON TblSSPX.SSPXID = TblCustomerLog.SSPXFK 
		INNER JOIN
			TblCustomer ON TblCustomerLog.CustomerFK = TblCustomer.CustomerID 
		INNER JOIN
			TblJobDetails ON TblSSPX.SSPXID = TblJobDetails.SSPXFK 
		INNER JOIN
			TblApptDetails ON TblJobDetails.JobDetailsID = TblApptDetails.JobDetailsFK 
						   ON TblResourcesRequired.APPTDetailsFK = TblApptDetails.ApptDetailsID 
		INNER JOIN
			TblResource ON TblResourcesRequired.ResourcesFK = TblResource.ResourceID 
		INNER JOIN
			TblSiteDetails ON TblSSPX.SSPXID = TblSiteDetails.SSPXFK 
 
		LEFT JOIN TblSSPXTariff ON TblSSPX.SSPXID = TblSSPXTariff.SSPXFK 
 
		INNER JOIN
			TblSupplierLog ON TblSSPX.SSPXID = TblSupplierLog.SSPXFK 
		INNER JOIN
			TblSupplier ON TblSupplierLog.SupplierFK = TblSupplier.SupplierID 
						ON TblJobStatusLog.JobDetailsFK = TblJobDetails.JobDetailsID
 
		LEFT JOIN TblUnitDetails 
						ON TblJobDetails.JobDetailsID = TblUnitDetails.JobDetailsFK 
		LEFT JOIN TblUnit 
						ON TblUnitDetails.UnitFK = TblUnit.UnitID 
		LEFT JOIN TblDropDownMaster ON TblUnit.ConnectionMethod = TblDropDownMaster.DropDownMasterID 
		LEFT OUTER JOIN TblJobType  ON TblJobDetails.JobTypeFK = TblJobType.JobTypeID
 
WHERE     
		(TblApptDetails.ApptConfirmedDate 
			BETWEEN @FromDate 
			AND @ToDate) 
			AND (TblCustomerLog.CurrentCustomer = 1) 
			AND (TblSupplierLog.CurrentSupplier = 1) 
			AND (TblApptDetails.CurrentAPPT = 1)
			AND ((TblSSPXTariff.currentTariff IS NULL 
				OR TblSSPXTariff.currentTariff = 1) 
				OR TblJobDetails.MTDsReq = 0)
			AND (TblProgressStatus.ProgressStatusType = 'Appt Confirmed') 
			AND  (TblJobStatusLog.CurrentStatus = 1) 
				--AND ((TblResource.Fullname LIKE '%' + @Engineers +'%') OR (@Engineers Is Null))
				--AND ((TblJobType.JobType LIKE '%' + @JobType +'%') OR (@JobType Is Null))
				--AND ((TblResource.EmployedBy LIKE '%'  + @EmployedBy + '%') OR (@EmployedBy Is Null))
			AND TblGroupCustNameLog.CurrentGroupCustName = 1
 
 
 
 
END