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.
Oh that's clever! Create a global temp table in SSMS and then select from it in manual list criteria. I do this kind of thing with a custom procedure (LP_LIST_FROM_QUERY, which I've shared on Bitbucket) so it all happens from within SSMS and creates a static list as a result. If my usage is anything like your predecessor's, that query was completely ad-hoc and is now lost to history. But it was probably also only ever supposed to be a one-time thing, so you probably don't need to worry about it.