SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/*

EXEC mp_whsStockWatch_viewsWTableMTS2BKUP
# Updated: 22/12/2010 - Because mp_whsStockWatchMTS2BKUP has a computed coulmn added I've had to add SET ARITHABORT ON
*/

ALTER PROCEDURE [dbo].[mp_whsStockWatch_viewsWTableMTS2BKUP]

AS
--SET NOCOUNT ON
SET ARITHABORT ON	
--GO

BEGIN

INSERT INTO mp_whsStockWatchMTS2BKUP
SELECT	MAX(Category1)		AS Category1,
		Region,
		Site,
		Area,
		MAX(Category2)		AS Category2,
		MAX(COALESCE(Category3, 'NULL'))	AS Category3, 
		--MAX(Category3)	AS Category3,
		MAX(COALESCE(Category7, 'NULL'))	AS Category7, 		
		--MAX(Category7)	AS Category7,
		Resource,
		MAX(COALESCE(Description, 'NULL'))	AS Description,
		--MAX(Description)	AS Description,
		SUM(Quantity)		AS Quantity,
		MAX(UM)			AS UM,
		SUM(EURValue)		AS EURValue,
		SUM(GBPValue)		AS GBPValue,
		MAX(Price)		AS Price,
		MAX(Currency)		AS Currency,
		QAStatus,
		Days,
		CAST(CONVERT(DATETIME,GETDATE(),105) AS VARCHAR(35))	AS CurrDate,
		Age
FROM	mp_whsStockWatchVw1
GROUP BY	Region,
			Site,
			Area,
			Resource,
			UM,
			QAStatus,
			Days,
			Age
ORDER BY	Category1

END

GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO