Actually I can read java without much effort.

Honestly I don't think converting this to straight t-sql is feasible in an online forum.

There are least a dozen methods that have not been posted.

Settings.instance()getExcludeRRCodeQuery(); --I am guessing this is a singleton

Settings.instance().getTDSIRRCodeQuery("list.rr_code"); --I am guessing this is a singleton

getGrossNetType()

NET_TYPE --this looks like an enum?!?!?

getSelAvailYears()

getYearType()

FISC_YEAR --this looks like an enum?!?!?

isIncNewIssues()

isExclMontlyBreakdown()

monthYearHdrs

getSelRankYears()

You have the distinct advantage that you can see the database, you can see all of the code, you can debug it, you have some sort of idea of the business rules and desired result. I have none of those things.