This article from Divya Agrawal might help you to overcome the problem when multiple objects or statements are scripted together. This is technique that can eliminate errors from scripts built dynamically.
2009-10-30
1,957 reads
Here's one without a temp table, but it does use multiple outer theta (inequality) joins...I'm sure SQL server will find some way of making the 4 joins to [child] a bit more efficient - at least it will probably sort the data from [main] and use merge joins rather than loops. THe query brings back […]
2003-06-26
1 reads
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers