First, with the sample data you've provided, your UniqueID field isn't unique. So, I'm assuming we first remove those first 8 inserts.

Then, I'd use the Row_Number() function to assign priority...

Gianluca is right -- you'll have to use a substring function to extract the data. Using the tally table is blazing fast and elegant, but it may be overkill for...

Phil Parkin (5/12/2011)

---

Damn right. I really feel like I'm doing valuable work when I'm chest deep in obtuse XML hierarchies.

Perhaps I should withdraw the post and take a few minutes...

Phil,

Yes, that would be a handy feature. But, then again, knowing how to grovel around in, and make sense of, the barely decipherable source code is why we get paid...

It could be further exaggerated I think if they were not declared as UNIQUE and there were duplicates in the data. Organizing the data on disk sequentially using an identity...

To piggy back a little on what opc.three was saying...

You have relatively wide records with clustered indexes. If the order of the data in the clustering index fields is not...

So, somebody asks us a question, we give them the right answer, then we find out we're wrong because they really meant to ask us a different question.

Sounds like what...

It sounds like what you're asking for is to return a string of a specified length given an input string of varying length.

When your input string is LONGER than...

Quite easily, actually.

Create a SSIS package. Add a data flow task.

Inside the data flow task, add a OLE DB source, utilizing a connection manager that points to the database where...

What results are you expecting to get?

It looks like your first output window is giving you what you are asking for -- did that come from your first query?...

What? You're allowing a developer to touch production data? Yikes!

zintp (11/18/2010)

---

Rob,

You may be interested in reading this article:

http://www.bidn.com/articles/integration-services/119/parallel-loads-in-ssis

which seems to be similar to Todd's idea, and additionally describes how to affinitize an SSIS process to a core, so that...

John Rowan (11/18/2010)

---

Rob,

Give me some time to get something written up. I can mock up an example on how this works including a view based interface into the...

sqlrunner (11/18/2010)

---

I have a script component that watches 1 or more directories for a file mask i.e. (log*), when it finds it, the information is passed to the rest of...

John Rowan (11/18/2010)

---

...

I'm sure there are more pros/cons that I listed here in a quick minutes, but that's the main area I can think of. Todd's method would work...