/SQL/Sqlstate[imssp]: the active result for the query contains no fields.

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);

Similar codes

0 vote243 views1 answer
Oracle table free space
SQL
0 vote250 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote239 views4 answers
Change schema in sql server
SQL
0 vote266 views1 answer
Sql cursor example multiple columns
SQL
0 vote238 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote228 views1 answer
Mysql into outfile with headers
SQL
0 vote247 views1 answer
Sql tablo hangi sp de
SQL
0 vote178 views1 answer
Oracle sql replace string in clob
SQL
4 votes258 views6 answers
List all tables in postgres
SQL
0 vote223 views1 answer
Mysql select where text contains
SQL