GilaMonster (8/22/2016)
Try filtering on database_id, or is the db_id the id of the connection rather than the table?
doh simple and obvious;
the database_id =2 , regardless of what database context that was creating the temp table.
Thank you Gail!
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!