The easiest way would be to change your columns from varchar into datetime format. You could add another column each with datetime format and copy the varchar values into the...

Paul White (3/16/2010)

---

...

Yikes. XML is not the right tool for the job when it comes to string splitting.

The tally-table method presented by Lutz, Bob, and Jeff is far,...

Something like this?

DECLARE @OutlineNumber VARCHAR(1000)

SET @OutlineNumber= '.I.A.1.b.'

SELECT STUFF(SUBSTRING(@OutlineNumber,1,CHARINDEX('.',@OutlineNumber,N+1)),1,1,'')

FROM dbo.Tally

WHERE N < LEN(@OutlineNumber)

AND SUBSTRING(@OutlineNumber,N,1) = '.'

The variable needs to have a dot...

No need for further discussion.

Seems like the question has already been answered here .

Side note: since the solution in the other thread is based on ROW_NUMBER I guess the...

redrabbit9999 (3/15/2010)

---

This works!!! Thanks. I have another question:

Do you know how to pivot transform the data so that it looks like this:

Unpivoted Data:

Column1 Column2 Column3

A ...

Glad I could help 😀

And sorry for underestimating the performance improvement 😉

Duplicate post.

Please...

muratistanbul (3/14/2010)

---

Hi, When I use PIVOT function , ALL THE TIMES I GET

Msg 170, Level 15, State 1, Line 7

Line 7: Incorrect syntax near 'PIVOT'.

Message is anybody have suggestion for...

RBarryYoung (3/14/2010)

---

Well, my back surgery is tomorrow (it got moved up). They've been putting me through medication withdrawal the last two weeks in preparation, so apologies if I've been...

I'd expect the problem is within the setting of your DATEFORMAT parameter.

But the major problem is: you're trying to treat a date value as a string.

If it's a date, use...

Ok, here's what I came up with. I'm not sure if it'll help but it might be at least something to start with.

CREATE TABLE #temp

(id INT IDENTITY(1,1),

col VARCHAR(60) ...

To any of you folks from "down under":

Congrats for winning the Hockey World Championship in India!

We didn't have that much of a chance in the final though...

@paul-2: CONGRATULATION to be one of the top 25!

The reason for the bad performance is you're 'climbing up' one level each time you select one of the values from the Circuit node. Try to use CROSS APPLY instead.

I'd...

scott.atkins (3/13/2010)

---

Hi Sorry for the late reply, thanks for the information much apreciated,

Im just curious how would you write a CURSOR script though? Would some one be able to...