SQL Querry

[PROKA]

I have a Table, named Table1 with the fields :

 

IDRes int

Active varchar(1)

 

 

 

and a second table, Table2 with the field

 

IdRes int

 

 

I want to insert into the 2nd table all the rows from table one where Active='N'

(must be the same IdRes)

[michael_hk]

Take a look at the following entry

 

SQL Server BOL -> INSERT...SELECT

[PROKA]

Ok, thanks, I got it Edited May 25, 2005 by PROKA