P
Peter Judge
Guest
I found an internal email thread on this from a few years back where the consensus seemed to be that it was especially useful for DB/TT-related stuff and less so for local assignments. So to more directly answer, you SHOULD use grouped statements for temp-tables and it doesn't really matter for local variables. The differences between the two approaches (DB/TT vs local) from a runtime performance perspective have also reduced over time too. FWIW, my preference is to group, largely for historical reasons. There is also the aspect of OO property assignments (or even method calls) where you don't know what that object is doing (it may be updating TT's for all you know) where there may be a real impact but as always, YMMV.
Continue reading...
Continue reading...