Mahender

Encountered " <s_identifier> "unpivot "" Encountered " <s_identifier> "for "".</s_identifier></s_identifier> The query we are using is: SELECT Xaxis, Xaxiscode, Xaxissub, Yaxis FROM ( SELECT PLN_FNDATE.MONTHNAME_ENGLISH + ' ' + convert(varchar, PLN_FNDATE.[YEAR]) as XAxis, convert(varchar, PLN_FNDATE.[MONTH]) + '/' + convert(varchar, PLN_FNDATE.[YEAR]) as XAxisCode, Convert(Numeric(5,2), SUM(CASE WHEN ORD.STATDAT5 <= ORD.DATGEWGER THEN 1 else 0 END) / Convert(Numeric(9,2),COUNT(ORD.SYSCODE))) * 100...