Thank this author by sharing:
By Andy Warren,
Recently I was working on a small utility and ran into a problem you may find interesting. I had a
fairly intense query that was going to be the basis for several other queries, so I decided to
put the results of that query into a temp table. The next step would be to join to that table and
perform some additional operations.
Good plan, right? As I started to test, it seemed that the part that built the temp table worked
fine, but follow up operations that used it failed. Why? Well, that's what I want you to tell me!
I'm going to steal an idea from Sean Burke and put up five bucks of my own cash as the prize for
figuring this out. Here are the rules:
See the answer to this puzzle at http://www.sqlservercentral.com/columnists/awarren/missingtemptablesfollowup.asp
view and query
This week Steve Jones looks at some data professional jobs that pay over six figures.
Figuring out Principal payments
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.