SQL Update Query

[meetbinu2003]

Dear All, How I can update multiple rows (with multiple column) , Values are from another Table. Pls reply URgent

[Paddy Boyd]

INSERT INTO TableA (AColumn) SELECT AColumn FROM TableB

[kmuthuk]

I think its better to use a cursor, it is faster too.

[BoneSoft]

Umm, maybe better by some standards, but definately not faster. If you'll check your SQL to English dictionary, you'll see that "cursor" means "slow as hell." Visit BoneSoft.com