All,
I'm new to Tessi, but not new to SSMS. I'm looking at some of the work from my predecessor and I can't seem to figure out what this is:
- select customer_no from ##boardask_16
It's the ## that has me stumped. In SSMS, that indicates a global temp table, and when I look at the results set in Tessi it comes back with data, so something is out there. I can't find an object in the DB that creates that temp table, or anything else by that name.
Any help or suggestions?
Is it part of a procedure? It might lie in another database or another server entirely if linked.
Thanks Troy, we got it figured out. My predecessor used temp tables for ad-hoc/on-the-fly/need-it-now lists. We're trying to track down if there's a record of the source SQL, but it looks like most of them can just be marked as inactive at this poiint.