Copy rows of one table to another table

I have four tables Candidate,Resume,Owner and Temp.

I want to search the freetext in Resume table and find the candidateid of the

respective candidates (satisfying search)and store those candidateid's into Table "Temp".

So that when doing an iterative search i may not seach through the entire resume table again.

Right now i am using "contain" function for doing iterative search by using "x and y".

this searches all the resumes of the candidate again.

By storing them inthe Temp table i want to restrict the new search only to the

resume selected in the search before.

For that i want to store the person who searched along with the candidateid

satisfying the search requirement.

Please help.

Thanks for the reply.

With regards

Girish R.

Is this something you planned to do with SSIS? If not, we could redirect this question to some other forum.

Thanks.

|||

I want to use stored procedure for this...

SSIS i am not aware.

But any suggestion are welcomed.

|||Moving to the more appropriate forum...