sorry, one again join table on leave like this
INNER JOIN Tbl_Loan C with(nolock) on
CONVERT(varchar(8), DATEADD(MONTH, 12, CAST(CAST(A.validon AS varchar(6)) + '01' AS datetime)), 113) =
(CAST( C.validon AS varchar(6)) + '01')
i...
Attachments:
You must be
logged in to view attached files.