How to apply media query in table?

How can i insert a query result in a temp table in sql server?

• am able to insert a table into a tempt table. But the problem that I am facing is while inserting the query result. select * into #temp1 from abc where ( select x,y,z, sum(case when a1 = z1 then cast(a1 as float)* (-1) else(cast a1 as float)) as Units from xyz group by x,y,z sum(case when a1 = z1 then cast(a1 as float)* (-1) else(cast a1 as float))>0 order by x,y ) The above query is a kind of sample query. I want to put down the query result from the bottom part into the temptable.

• Answer:

  Try this... INSERT INTO #temp1 select * from abc where ( select x,y,z, sum(case when a1 = z1 then cast(a1 as float)* (-1) else(cast a1 as float)) as Units from xyz group by x,y,z sum(case when a1 = z1 then cast(a1 as float)* (-1) else(cast a1 as float))>0 order by x,y )