/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

3 votes143 views1 answer
Mysql load sql from file
SQL
1 vote140 views1 answer
Delete row mssql
SQL
1 vote157 views1 answer
Oracle sql pad left zeros
SQL
0 vote148 views1 answer
Postgres sql alter table delete row
SQL
0 vote130 views1 answer
How to find unique key in sql
SQL
13 votes141 views4 answers
Mysql get last row
SQL
0 vote136 views2 answers
Sql last updated
SQL
3 votes191 views1 answer
Oracle function
SQL
0 vote149 views1 answer
How to find lowest in sql
SQL
0 vote143 views1 answer
Mysql drop multiple tables at once
SQL