Microsoft SQL HELP!!!

Member

For those that know what I'm talking about:

I have a table with data in it. I want to copy all the rows of that table that match a specific value into another table. Is there an easy way to do it through SQL code?

Member

Insert with a select from

I.E.

insert into T_Portfolio_Stats
(loan_id, library_nk, loan_no_nk, Defeased)
select loan_id, library_nk, loan_no_nk, 'N'
from d_loan
where ln_active_stat_ind = 'Y'

Microsoft SQL HELP!!!

LIFEFORM SOCIAL COMMUNITY NETWORK