PJensen · October 12, 2012 18:05
diff --git a/SrcDestUpdate.sql b/SrcDestUpdate.sql
 -- Updating a table using a source and destination table.
 BEGIN TRAN
 	UPDATE [ToTable]
 		SET [ToTable].[Value] = [FromTable].[Value],
 		...
 	FROM [FromTable]
 		INNER JOIN [ToTable] ON ( /* Join Conditions */ )
 	WHERE ( /* Where Clause */ )
 ROLLBACK TRAN
	-- Updating a table using a source and destination table.
	BEGIN TRAN
	UPDATE [ToTable]
	SET [ToTable].[Value] = [FromTable].[Value],
	...
	FROM [FromTable]
	INNER JOIN [ToTable] ON ( /* Join Conditions */ )
	WHERE ( /* Where Clause */ )
	ROLLBACK TRAN
No results found