Double post folks... no answers here, please. Goto the following URL instead...

http://www.sqlservercentral.com/Forums/Topic666037-149-1.aspx

See the splitter example in the following article...

http://www.sqlservercentral.com/articles/TSQL/62867/

Also... if guaranteed to only have 3 parts, lookup PARSENAME in Books Online.

And, yes... I wish there was a Phd for those who pretty much specialize in the code.

That works just fine, but there's only 100,000 numbers available that way. This type of serialization is really bad just because of that... even if the numeric sequence is...

Heh... Proctologist... reminds me of a...

Lookup GRANT and ROLES in Books Online... it comes free with SQL Server.

Because the query produces a downline and you're trying to calculate the upline targets, you will need a separate correlated subquery UPDATE (maybe a CROSS-APPLY but haven't tried it) to...

Bob Hovious (2/27/2009)

---

I was referring to inadequacies of alleged IT professionals 😉

My war story is that our development group used to have a guy whose...

Bob Hovious (2/26/2009)

---

I just have to ask, how much of your coding efforts are spent...

Bruce W Cassidy (2/26/2009)

---

[font="Verdana"]Any chance of you sharing some of the techniques you're using for that? I've been doing similar things, building an ODS for a client company. ...

You're welcome, Tim... thanks for taking the time to post the feedback.

Mike, there's a whole lot of things that can make such a large insert slow. For example, a clustered index that's not quite on the right columns for the...

Grant Fritchey (2/27/2009)

---

I see a loop and I want to eliminate it, if possible. But you're right, of course.

I still think partitioning the data would be a better approach rather...

I'd still like to know why we're spelling out dates. What are the business rules that would require such a thing?

Also, just a friendly tip... you don't need a...

Can you post the actual code you tried? The code you posted has no percentage calculations in it.