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

:blush:

Adding to what Paul already said:

your nonclustered index is unlikely to be used since it has the same leading column as your clustered index.

Please explain what you think the indexes...