saving query result as a distinct table in a database 1

[lagazetta]

hi there,

i have a script that looks like the following:

select m.date_value, m.he, m.poolp, m.bpat, r.kinbasket
from merged4 as m join reservoir as r
on m.date_value = r.date_value

the query gives a result table on the lower pane.
how do I save that results table as a table within the databse?

thanks,

 

[SQLDenis]

change TableNameHere to the desired table name

select m.date_value, m.he, m.poolp, m.bpat, r.kinbasket
INTO TableNameHere
from merged4 as m join reservoir as r
on m.date_value = r.date_value

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[onpnt]

SELECT INTO

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}