SELECT dbo.MainLedger.AcCode, SUM(dbo.MainLedger.Debit) AS DurDr, SUM(dbo.MainLedger.Credit) AS DurCr
FROM dbo.InputVal CROSS JOIN
dbo.MainLedger
where
Case when Convert(datetime,DateFrm)>convert(datetime,[dateto]) then MainLedger.Transdate between convert(datetime,datefrm) and convert(datetime,[dateto])
else
Transdate Between convert(datetime,[YearFrom]) and convert(datetime,[datefrm])
end
GROUP BY dbo.MainLedger.AcCode

