CREATE TABLE	#TempTable
		(
			job_date datetime,
			job_number char(15),
			cost_code char(15),
			qty_received decimal(8,2),
			qty_used decimal(8,2),
			qty_wasted decimal(8,2),
			productId char(25),
			plant_id char(10)
			                                     		)

INSERT INTO     #TempTable (job_date, job_number, cost_code, qty_received, qty_used, qty_wasted, productId, plant_id)
		SELECT              dbo.Batch.ReportDate AS job_date, dbo.Job.CompanyJobId AS job_number, dbo.Item.CompanyItemId AS cost_code, dbo.Product.CompanyProductId as productId, SUBSTRING(dbo.Job.CompanyJobId, 1,3)  as plant_id,
				qty_received = CASE dbo.SourceType.CompanySourceTypeId WHEN 'MA' then SUM(dbo.ProductionEvent.Quantity) ELSE 0 END,
				qty_used = CASE dbo.SourceType.CompanySourceTypeId WHEN 'PR' THEN SUM(dbo.ProductionEvent.AlternateQuantity) ELSE 0 END
		FROM                 dbo.Batch INNER JOIN
                     			dbo.Event ON dbo.Batch.BatchGuid = dbo.Event.BatchGuid INNER JOIN.....

INSERT INTO #TempTable 
	(job_date, 
	job_number, 
	cost_code, 
	qty_received, 
	qty_used, 
	qty_wasted, 
	productId, 
	plant_id)
SELECT	dbo.Batch.ReportDate AS job_date, 
	dbo.Job.CompanyJobId AS job_number, 
	dbo.Item.CompanyItemId AS cost_code, 

	qty_received = CASE dbo.SourceType.CompanySourceTypeId 
			WHEN 'MA' then SUM(dbo.ProductionEvent.Quantity) 
			ELSE 0 
			END,
	qty_used = CASE dbo.SourceType.CompanySourceTypeId 
		WHEN 'PR' THEN SUM(dbo.ProductionEvent.AlternateQuantity) 
		ELSE 0 
		END,

	qty_wasted = 	CASE dbo.SourceType.CompanySourceTypeId 
			WHEN 'MA' then SUM(dbo.ProductionEvent.Quantity) 
			ELSE 0 
			END
			-
			CASE dbo.SourceType.CompanySourceTypeId 
			WHEN 'PR' THEN SUM(dbo.ProductionEvent.AlternateQuantity) 
			ELSE 0 
			END,

	dbo.Product.CompanyProductId as productId, 
	SUBSTRING(dbo.Job.CompanyJobId, 1,3)  as plant_id

FROM	dbo.Batch 
INNER JOIN dbo.Event 
	ON dbo.Batch.BatchGuid = dbo.Event.BatchGuid 
INNER JOIN.....