Updating several fields in a table with a select statement

From: Chip (Chip_at_discussions.microsoft.com)
Date: 11/29/04

  • Next message: Anith Sen: "Re: Can you select from a Derived table calling a stored proc?" 
    Date: Mon, 29 Nov 2004 10:09:18 -0800

    Hi,

    Is there a way in T-SQL to update several fields of a table with fields from
    another table using a select statement based on a key? I remember doing that
    in Oracle. If so, can you please give me the syntax. Thanks.

  • Next message: Anith Sen: "Re: Can you select from a Derived table calling a stored proc?"