cdex3 (10/8/2008)

---

I have a table in the following format.

ID RecType PKIdentifier RecordData

1 01 acc00108 Text

2...

JohnDBA (10/8/2008)

---

Jeff,

This solution is close to what I need, but I need to create groups. I cannot create groups with jbmRank. 🙁

I will read that article. Thank you...

Ok... I borrowed some data and assume that you don't actually have a primary key... this should give you and idea...

--drop table #shuffle

DECLARE @NameCountPlus1 INT

SELECT @NameCountPlus1 = COUNT(*)+1...

If you haven't read the article that Matt listed, you really need to go back and read it so you understand why the following works... and it works at a...

What is the primary key of the table?

Also, since this is your first post, you might want to take a look at the link in my signature below... folks will...

I remember... it's a pretty tough task because it's not just quotes that Sergiy has to worry about with the data he showed me. It's data from a "properly"...

Absolutely...

Thanks... I'll take a look.

Chris Morris (10/8/2008)

---

Interesting point. I'd guess that most of us use a tally table with a million numbers in it. Having found that reducing the rowcount (or maximum number, in...

ggraber (10/8/2008)

---

I guess the question is that a while loop has a dynamic number of iterations based on the length of the parameter.

You don't have that kind of flexibility with...

ggraber (10/8/2008)

---

An article on this topic would be really cool, Jeff.

I just presented this concept at work using your split csv example.

I was just trying to think what other examples...

PIVOT would likely be slower than a good ol' Cross-Tab. See the following... peformance charts are near the end of the article...

http://www.sqlservercentral.com/articles/T-SQL/63681/

If we knew more about the process that requires this action to occur, we might be able to help better. It's difficult to imagine a call recorder that would...

Actually, why does this need to be done in a trigger? This sounds like a process specific to a particular proc and should probably on be done from a...

UNION will disappoint you because it will be slow and it will blow away data, in this case, quite unexpectedly. If you want the output in sorted order, you...