More of an opinion or guidance because I want to do this the correct and acceptable way.
I have large queries that take bits of tables, create temp tables and queries the temp tables and finally get a dataset.
Should I use a stringbuilder or type the whole query into a string?
Should I use temptables or table variables?
Should I create a procedure - subroutine?