Forget SSIS. Tell your boss that the easiest way to set up an automatic failover is to have a witness server. It can even be the FREE edition of SQL...

Did anyone hear about Microsoft's Hotmail SQL Server cloud issue?

Well, you have to get rid of the duplicates before doing the unique index. Here's how I'd do it:

WITH CTE AS(

SELECT [GuestID], [FirstName], [LastName], [BookDate],

...

Steve Jones - SSC Editor (1/6/2011)

---

WayneS (1/6/2011)

---

I guess I hit enter... I've PM'd Steve to see if he can take it out, all...

You're welcome. Do you understand it? (See the note in my signature...)

I'm glad I didn't stir up the mud in the water!

Now... do you need help in getting rid of that c.u.r.s.o.r.?

The attached below code produces your desired results. (having trouble posting code directly from work - I'll move it into the post tonight!)

-- See how this starts off with a...

The DelimitedSplit8K function (Click here for the latest Delimited Split Function) will do this for you. It is probably the absolute fastest method that you'll find for splitting strings.

I have...

Just to make sure I understand, since ID 1 has "data2" in both rows, you want it returned only for the first row, and you want all the data ordered...

jcrawf02 (1/6/2011)

---

WayneS (1/6/2011)

---

Edit3: I'd like to go, if for no other reason than to hang out with Brent and Tim for a week and to be able to absorb anything...

Brandie Tarvin (1/6/2011)

---

WayneS (1/6/2011)

---

Brandie Tarvin (1/5/2011)

---

EDIT: Of course, the only reason I want to go on this cruise is for the Cruisiness of it (Caymans, Mexico). The SQL Classes themselves...

Chad Carter (1/6/2011)

---

The most I have seen at one time is a couple of hundred records so we should be OK. I will begin testing with it and getting...

SQL_Dba_WannaBe (1/6/2011)

---

Hey group,

I was reviewing a CURSOR created and ran across a line of code that makes no sense to me. I was hoping someone out there could...

Yep, each FK would have to be validated to...

I guess I hit enter... I've PM'd Steve to see if he can take it out, all I can do is edit the...