Answers for "SQLSTATE[IMSSP]: The active result for the query contains no fields"

SQL
1

sqlstate[imssp]: the active result for the query contains no fields.

with (SELECT afield INTO #temptable FROM atable 
WHERE anotherfield = 'somevalue') AS temptable;

SELECT afield,anotherfield,onemorefield FROM atable 
where afield NOT IN (SELECT * FROM temptable);
Posted by: Guest on June-02-2021

Code answers related to "SQLSTATE[IMSSP]: The active result for the query contains no fields"

Code answers related to "SQL"

Browse Popular Code Answers by Language