insert multiple rows..

test 09

I am having the same db with 2 back ups both have different information(table rows) i need to append both..

test09

Blue_Boy

Did you try that query? I think you are trying to merge two databases into one, right?

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

test 09

yes but i need to merge only one table..

test09

Blue_Boy

Then use my query and all will be done.

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

test 09

using that query can insert single row how do i select all 400 rows.. or else i need to execute that query for each and every row..

test09

Blue_Boy

That query will insert all rows from table, not only one! Better check this http://en.wikipedia.org/wiki/Insert\_(SQL)

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

Mycroft Holmes

He's in trouble if he is trying to merge 2 tables, there will be duplicates unless he filters them out.

Never underestimate the power of human stupidity RAH

Mycroft Holmes

Take the boys query and add a where clause that filters out existing records so you do not get duplicates. You need to identify the primary key (unique data) in both fields that can be used to apply the filter.

Never underestimate the power of human stupidity RAH

Blue_Boy

I warned him/her too in previos post, thanks for claryfing me :)

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

Mycroft Holmes

Actually I think I could have left it a he's in trouble His level of understanding about database needs upgrading

Never underestimate the power of human stupidity RAH