/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 5 [OVP_ID]
,[Plu_ID]
,[Actual_Date_ID]
,[Quid]
,[Order_Qty]
,[Order_Mass]
,[Transfer_Mass]
,[Transfer_Qty]
,[Movement_Mass]
,[Movement_Qty]
,[Produced_Mass]
,[Produced_Qty]
,[Qwix_Produced_Qty]
,[Qwix_Produced_Mass]
,[Weekly_Forecast_Qty]
,[Weekly_Forecast_Mass]
,[Quid_Ordered_Mass]
,[Quid_Transfer_Mass]
,[Quid_Movement_Mass]
,[Quid_Produced_Mass]
,[Quid_Qwix_Prod_Mass]
,[Trim_Produced_Mass]
,[Trim_Qwix_Prod_Mass]
-- select sum(Produced_Mass), sum(produced_qty)
FROM [dw_Datawarehouse].[dbo].[FACT_Orders_Vs_Produced]
where [Actual_Date_ID] = 11159
and Plu_ID = 1481
UPDATE [dw_Datawarehouse].[dbo].[FACT_Orders_Vs_Produced]
SET [Produced_Mass] = 21479.00
,[Transfer_Mass] = 21479.00
, [Transfer_Qty] = 613.00
, [Produced_Qty] = 613.00
, [Quid_Transfer_Mass] = 18100.000
, [Quid_Produced_Mass] = 18100.000
--select *
FROM [dw_Datawarehouse].[dbo].[FACT_Orders_Vs_Produced] a
where [Actual_Date_ID] = 11159
and Plu_ID = 1481