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?
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.