chinn_chris (9/24/2012)

---

Okay, here's the deal. I have the below select statement I'm trying to analyze but I've never seen this particular use of NULL in a select statement of...

As previously stated this is high potential of the issue.

WHERE SD.Code IS NOT NULL AND RTRIM(LTRIM(SD.Code ))<>''

That renders your query nonSARGable. You could change that be simply:

WHERE SD.Code > ''

This...

mick burden (9/24/2012)

---

if I have a table with fields which contain common delimited data in them, is there a way I can read them into some kind of temporary table,...

martin 81121 (9/24/2012)

---

Hi

We are looking to upgrade our current SQL and Server, at the minute a lot of our larger tables (2-3 million rows) are timing out when I...

+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...