Update Query

Update TimePlanMacroPDDet Set UptoProdQty = t.UptoProdQty From

(Select LocationId,Yrmon,Matlid,PdId,ProcessId,Sum(ProdQty) UptoProdQty

From TimePlanMacroProdDet Where LocationId = @LocationId And Yrmon = @Yrmon

And MatlId = @MatlId And PdId = @PdId And ProdnDate between @FrDt And @ToDt

Group By LocationId,Yrmon,Matlid,PdId,ProcessId

) t

Where TimePlanMacroPDDet.LocationId = t.LocationId

And TimePlanMacroPDDet.Yrmon = t.Yrmon

And TimePlanMacroPDDet.MatlId = t.MatlId

And TimePlanMacroPDDet.PdId = t.PdId

And TimePlanMacroPDDet.processid = t.processid

And Type = 'Process'