Incercati instructiunea MERGE din T-SQL :
http://technet.microsoft.com/en-us/library/bb510625.aspx
http://jdixon.dotnetdevelopersjournal.com/i_want_my_sql_2005_merge_statement.htm

---

Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)