ralphp1355
asked on
VISUAL STUDIO VB - Opinion on running large queries setting temp tables - what do you use
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.