+1

A calculated column is far better here than a trigger for a number of...

karthikeyan-444867 (9/24/2012)

---

All,

I have recently read Jeff Moden's Multiple space into one space article and i saw M's reply on this topic.

He gave the below solution to resolve the same issue.

set...

I like the approach that G2 took using apply. Didn't think about repeating strings get removed.

This exercise is a good example of why data should be stored differently. If...

Hi and welcome to SSC. It is difficult to answer your question because there is not a lot of detail in the question. From your description I am pretty sure...

F8R (9/22/2012)

---

Ok, I'm hijacking my own thread, 😀

Create Table Orders

(

OrderID BigInt Identity(1,1) Not Null,

CustomerID BigInt Not Null,

Constraint [PK_Orders] Primary Key(OrderID)

)

go

Create Table Customers

(

CustomerID BigInt Not Null Identity(1,1),

...

Luis is absolutely correct. Use the delimited splitter he linked and then a cross tab.

BTW, nice job posting ddl and sample data. You are new around here but obviously understand...

Really what you are talking about is formatting. This can be subject to personal preference. There is a free site http://poorsql.com/%5B/url%5D that goes a pretty decent job.

Here are the results...

Lynn Pettis (9/21/2012)

---

Sean Lange (9/21/2012)

---

/vent begin

You have been trying to work on this for over a month with various half-hearted attempts strewn all over this site. You need to realize...

/vent begin

You have been trying to work on this for over a month with various half-hearted attempts strewn all over this site. You need to realize that we are volunteers...

Joe's reply is somewhat echoing what I have stated but he knows the actual terms for these things. 🙂

I would not however recommend that you use his primary key idea...

Eugene Elutin (9/21/2012)

---

Sean Lange (9/21/2012)

---

This is one of the reasons it is generally considered best practice to always include schema when referring to any object. And if the schema is...

It may have let your query run but I don't think it solved your issue. The problem is that the order by specifies a case sensitive sort order but the...

This is one of the reasons it is generally considered best practice to always include schema when referring to any object. And if the schema is not in dbo it...

I am not exactly sure I understand your question but the SUM function takes only 1 parameter and you are passing it two. If you can post some ddl(create table...

I still say you are asking for nothing but trouble trying to keep this stuff stored like this but if you are insistent on doing it then I would make...