hi,,
now check
SELECT PDS.PROJ_CODE,DED.DED_Description,DED.DED_Short_Desc,right('00' + Cast(DATEPART(M, RELEASE_DATE) as varchar(2)),2) + '-' + cast(DATEPART(yyyy, RELEASE_DATE) as varchar(4)),DTQ.MATERIAL_TYPE,sum(DTQ.MATERIAL_QUANTITY)
FROM
pts_h_drawing_schedule PDS,
PTS_T_Drawing_Transmittals_Quantity DTQ
LEFT JOIN DMS_D_Drawing_Element_Details DED ON DTQ.Material_Type=DED.DED_Id
WHERE DTQ.DOC_ID=PDS.DOC_ID
AND PDS.PROJ_CODE=@Proj_Code
group by PDS.PROJ_CODE,DED.DED_Description,DED.DED_Short_Desc,DTQ.MATERIAL_TYPE,
right('00' + Cast(DATEPART(M, dt) as varchar(2)),2) + '-' + cast(DATEPART(yyyy, dt) as varchar(4))
regards,
Prakash.T