Perhaps these will help:

http://www.kimballgroup.com/html/08dt/KU107_UsingSQL_MERGESlowlyChangingDimension.pdf

http://dimensionmergescd.codeplex.com/

Very funny, Jason.

Working on a SQL injection attack to change...

Asking...

Presumed table structure:

-- This table has no primary key!

DECLARE @Example TABLE

(

UserID integer NOT NULL,

ObjectID ...

Stephanie Giovannini (1/9/2012)

---

Yep, compatibility level was the problem. All the databases in SS 2008 had been originally restored from SS 2005. My local sandbox was created new in SS 2008...

GilaMonster (1/9/2012)

---

Exactly what it says...

Satya_0000 (1/9/2012)

---

During undoing of a logged operation in database Dbname, an error occurred at log record ID (605859:16:154). Typically, the specific failure is logged previously as...

Make sure you're running SQL Server 2008 and that the database you are connected to is set to compatibility level 100 (SQL Server 2008). Anything...

sqlfriends (1/9/2012)

---

It seems Merge statement is a very helpful tool for data update/delete/insert load.

But at the same time, I understand it is not so flexible to add other codes into...

Stephanie Giovannini (1/9/2012)

---

I've discovered that the composable DML approach only works on SQL Server 2008 R2, not SQL Server 2008. My production target is 2008, but I have R2 available...

There's no direct way (that I know of), but:

DECLARE @s-2 TABLE (id integer PRIMARY KEY, val integer)

DECLARE @T TABLE (id integer PRIMARY KEY, val integer)

INSERT @s-2 VALUES (1, 5), (2,...

SQLRNNR (1/9/2012)

---

SQL Kiwi (1/9/2012)

---

You don't think 'Aaron Aardvark'...

The ON clause is used to specify conditions to determine if source and target rows join or not. In your case, it seems the ON clause should contain only...

You don't think 'Aaron Aardvark' has a nice...

Sorry, I don't understand the question...