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.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/