Marios, you know how hard this is without sample data and schema to work from.

Are there identifiers that can be used to group these rows?

Basically, what you're looking to do...

Yep, but you'll want to make it consumable so we can provide you back tested code....

D'oh, *facepalm*. Sorry.

I'm wondering if this is a case of SSIS complaining about the incorrect...

rwsmith 38519 (12/9/2011)

---

Craig,

Thanks! I really appreciate the help.

That works for the most part. It does number the units, except it skips the first one. Basically starting at 1 with second...

call.copse (12/9/2011)

---

Evil Kraig F

---

(...)

As to a right to complain, I would disagree with that. Heck, I disagree with the removal of capital punishment, instead of a $0.15 bullet...

Koen Verbeeck (12/9/2011)

---

Cadavre (12/9/2011)

---

Koen Verbeeck (12/9/2011)

---

It's get even worse. There's a channel with relative new movies (Green Lantern and Hangover II for example). Then there's another channel that plays the...

andagr (12/9/2011)

---

I would not like to have my duties spelled out exactly because I like different challenges as long as it's within my area of expertise, if I were asked...

Because Basement-Cat made IE.

I apparently need to post more or...

I personally do not want my job duties to be spelled out that completely. Most of the more interesting work I've done has been because someone dropped by my...

matt.newman (12/8/2011)

---

It's on a Raid 1 because it was developed recently (before I got here) and pushed onto a fast and separate array than the other data is, but all...

It's a big topic and will require some research, but look into 'fuzzy lookup' in SSIS.

AndrewSQLDBA (12/8/2011)

---

Craig

After going over the results very closely, you are correct, and your initial code was perfect.

Not sure what I had seen that I thought was not correct.

I apologize to...

Tony Palmeri (12/8/2011)

---

Steve Jones - SSC Editor (12/7/2011)

---

Tony Palmeri (12/6/2011)

---

I dispute the notion that *all* laws (and all decisions) are arbitrary. Many perfectly good and just laws are made...

Like living dangerously, I see? Might I recommend at least RAID5 so you can survive a single drive outage?

I intend to re-architect...

DoubleEx (12/4/2011)

---

Hi,

I find no local jobs running on this server to account for interference and trace is only showing me when the performance problem occurs.

Normally I would assume...