Trying to understand your data I think you will find this should be a simplified version of your original post plus the extras you asked for.

I assume thou Customer ID...

Oh and btw somone made a decent point about OLTP and OLAP. DRI is very important for OLTP systems. For OLAP thou the data for most systems is generally static...

Grant Fritchey (11/30/2007)

---

It also assumes that developers are completely and utterly, without fail, perfect. They don't miss a constraint, ever. I'm not suggesting that DBA's don't miss them or screw...

Matt Miller (11/29/2007)

---

Nonsense...

Dave (11/29/2007)

---

If you didn't take into account wage differences, and you really...

About 10 years...

Robert Hermsen (11/29/2007)

---

i vote for lining the medians of all highways with wind turbines. The corridors are always gusty adn the land is useless. Get on that one...

How are the changes made? I would setup maybe a second database with the same sturcutre and require anytime someone makes a change they do to both databases (sorry thought...

EdVassie (11/29/2007)

---

alien,

The data that is being stored in SQL Server is the valid result of the UuidCreate() function. They are not junk characters.

In order to generate a globally unique...

Glad you found your answer.

Brandie Tarvin (11/29/2007)

---

I actually agree with getting everyone to sit down and contribute. The problem is that in practice it usually ends up being one person who sits down...

Look at DATEPART with the wk option.

The big thing right now isn't even cars, it is power plants, they can build better generating nuclear plants (without the glow in the dark excess) to ruduce oil and...

On the client it would not know what Jack is unless you create the alias on the client machine in some manner such as the host file, the registry or...

Jeff Moden (11/28/2007)

---

This should do it...

UPDATE Grade

SET Grade_Name = CASE

WHEN Grade_ID = '35800'

THEN 'TRANSCOPY' + CHAR(153) --™

...