If you're not clear on what we're asking, just post a screen shot of SSMS with the Execute button grayed out. Should be able to see what's going on...

I've had similar experiences with outsourcing overseas.

Even people who all nominally spoke "English" had terrible problems communicating. First time I was told a table had "many lahks of rows"...

Matt Miller (#4) (7/26/2011)

---

True. As long as the...

Don't use that UDF for this.

There are much better (faster, more reliable) string split functions available.

Also, it doesn't actually do what you asked for. It doesn't add in newline...

Ninja's_RGR'us (7/26/2011)

---

Chad Crawford (7/26/2011)

---

Ninja's_RGR'us (7/26/2011)

---

Chad Crawford (7/26/2011)

---

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when...

Chad Crawford (7/26/2011)

---

GSquared (7/26/2011)

---

Chad Crawford (7/26/2011)

---

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I...

Chad Crawford (7/26/2011)

---

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I stumbled across a really...

The bigger problem here is that unplugging a USB drive while it's still writing data can result in the drive being corrupted, losing all data on it.

Other than that, it's...

I've seen lots of databases that use this as a solution to simplify things. It works great for a while, then as more and more categories get added, it...

Something like this:

;

WITH CTE

AS (SELECT YYYYMM,

...

There's a StatusDate column that gives the sequence, Matt. That should be adequate for that need, without an identity column.

Does this help? http://msdn.microsoft.com/en-us/library/ms177563.aspx

SSIS can't access the data inside the trigger. Nothing except the trigger can do that. That's why you'll need to stage the data into a table that SSIS...

Okay. Glad we could help at least that much.

Okay. But...