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