question

I am writing a procedure that creates a temp table, calculates the batch total by date, and then inserts total and date into another table and then drops the temp table. The query runs, creates temp table, but does not insert the data; I think the problem is with the date field but I’m not sure. I could use a fresh set of eyes…. Thanks in advance Jp ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ USE [LineProcess] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[MachineBatchTotals] AS BEGIN TRY SET NOCOUNT ON; create table Machine2TotalTemp (BatchTime datetime ,BatchLine02Total float); SELECT SUM(MTotal) AS Machine2Total FROM (SELECT Line02_JobID, MAX(Machine2_BatchCount) AS MTotal FROM MarkemLine02 WHERE (DateAndTime BETWEEN (SELECT CASE WHEN DateAndTime > '06:00:00' THEN (SELECT CONVERT(VARCHAR, getdate(), 110) + ' ' + '06:15:00') ELSE (SELECT CONVERT(VARCHAR, getdate() - 1, 110) + ' ' + '06:15:00') END AS result) AND GETDATE()) AND (Machine2_JobID <> '') GROUP BY Machine2_JobID) AS Machine2Total; merge into Machine2BatchTotal a using ( select * from Machine2TotalTemp) s on (a.DateAndTime = s.BatchTime) when matched then update set a.Machine2Total = s.BatchLine02Total when not matched then insert (DateAndTime,Machine2Total) values (s.BatchTime,s.BatchLine02Total); drop table Machine2TotalTemp; END TRY BEGIN CATCH SELECT ERROR_NUMBER() AS ErrorNumber ,ERROR_SEVERITY() AS ErrorSeverity ,ERROR_STATE() AS ErrorState ,ERROR_PROCEDURE() AS ErrorProcedure ,ERROR_LINE() AS ErrorLine ,ERROR_MESSAGE() AS ErrorMessage; END CATCH