UPDATE TR_REC SET LMTD_TRCDMA = (SELECT C.CRT_Cod,

sum (case when R.Prod_Typ in ('Mobile','Hello','Rdel','Data','HSD') then MRP Else 0 End)/100000

from TR_REC C inner Join ER_Main E on C.CRT_Cod=E.CRT_Cod inner Join Rch_Vouchsep11 R on...

Thank u SSCrazy

Where need to give

SELECT C.Clstr_Nm,C.CH_typ,

Sum(C.MTD_TRCDMA) 'MTD_TRCDMA',

SUM(C.LMTD_TRCDMA)'LMTD_TRCDMA',

'%Growth' = (Round((CAST(sum(MTD_TRCDMA)AS FLOAT))-(CAST(sum([LMTD_TRCDMA])AS FLOAT)) /(CAST(sum([LMTD_TRCDMA])AS FLOAT,2))))

from TR_RECHARG C

Left outer Join ER_Main E on C.CRT_Cod=E.CRT_Cod

Left outer Join Rch_Vouchsep11 R on E.ER_MDN=R.Donor_MDN

where...