SQL Server 2005 T-SQL: Mimic MERGE with OUTPUT

Following up on my previous post a couple of people have asked me how they could accomplish this same thing because MERGE is not available in SQL Server 2005. So let’s take a look at how you can use the OUTPUT statement which is available to produce

www.programmersedge.com