Glad I could help 😀

That sounds like a job forCrossTab together with Row_Number to get it sorted as requested.

If you can't predict the max. number of column groups (e.g. the 5 you posted) you...

Craig, Lynn:

Even though it might be fun arguing with a person in such a mood from time to time, there usually is a point where the discussion starts running in...

Based on what you described so far I'd use something along the following concept:

DECLARE @tbl TABLE

(

id INT IDENTITY(1,1),

col1 VARCHAR(20),

col2 VARCHAR(20)

)

INSERT INTO @tbl

SELECT 'Test1~Test2' , '10~20' UNION ALL

SELECT...

I'd move the section in question into a subquery:

SELECT

...

CASE WHEN MGP.COMPANY_ROLE_CD = 'BK' THEN MGP.COMPANY_ROLE_CD END AS [BK_PARTY],

...

My pleasure, Greg 😀

The last link in my signature will point you at a split function to be known as one of the best performing solutions using T-SQL.

Would SQL Server 2008 R2 Express be an option?

Craig Farrell (2/10/2011)

---

...

Hm, YYYYMMDD format? Right right... ISO conversion. Good call. I like the bit with the 100+ instead of replication routines. Nice touch. Kinda...

george sibbald (2/10/2011)

---

LutzM (2/10/2011)

---

We decided to replace our SQL versions with an alternating process:

We had some SS2K and SS2K5 versions when we decided to replace the SS2K with SS2K8 and...

ramksharma91 (2/10/2011)

---

ok i will not yell but i think before you or any buddy write at some blog you should know the problem where it all started.

now i know...

Craig Farrell (2/10/2011)

---

Yeah, I was afraid of that. You'll have to do something like this short term:

;with cte AS

( SELECT *, CONVERT( DATETIMe, CONVERT( VARCHAR(20), salesmonth) + '/'...

ramksharma91 (2/10/2011)

---

first of all sorry about ur name Sturner.

next guys Hold on I am A STUDENT not a business man not IT pro NOt any Share Holder.

NOW I...

Sean Lange (2/10/2011)

---

Your project(s), clients, requirements and your desire to learn sql are the answers to that question. If you are looking for a reason not to learn sql then...

I think a life cycle of three years is too short to be manageable.

It takes about a year before we even get the new version approved internally or before our...