Hi

Here's a couple of articles by Jeff Moden on the subject

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/Crosstab/65048/

They should help

You're welcome

Steven Willis (3/14/2013)

---

Mickey...that sure beats my solution by a mile. I don't know why I didn't split the data into columns right from the beginning instead of trying to parse...

Hi

This seems to work, but would need some serious testing I think.

;WITH data as (

SELECT * FROM (VALUES

(null,null ,null , 'Egypt' )

,(null,null , 'Alexandria', 'Egypt')

,(null, 'East', 'Alexandria', 'Egypt')

,(null,...

Your welcome

kwalter 22547 (3/10/2013)

---

mickyT, Thanks for your post. I see that your solution gives me what i need (not what i asked for, but perhaps better). How do...

Hi

Jeff Moden has this excellent article on hierarchies

http://www.sqlservercentral.com/articles/Hierarchy/94040/

I suspect the creating a hybrid sort path will help you with the ordering.

;with Menu as (

SELECT * FROM (

VALUES

('100','Main Menu','',1)

,('200','Sales Management','100',1)

,('300','Customer...

ChrisM@Work (3/7/2013)

---

This is called "Islands and Gaps". An island is a set of rows where the dates are consecutive, bounded by rows with non-consecutive dates. Jeff Moden has a great...

sqlislife (3/7/2013)

---

Thanks for the prompt response. Yes your assumptions are correct.

Can you clarify this statement. I think it contains some special characters

SELECT COUNT(*) + 1 FROM #temp1 WHERE DataDifference...

Hi

The third example you gave doesn't appear to conform with the rules use on the other examples. I would have expect 4 based on the previous examples

Example 1

N,1,1,3,1,1,4,1

1---->2---->3->

Example 2

N,1,1,3,1,1,1,1

1---->2------->

Example

N,3,3,1,1,1,6,1

1>2>3------>4->

If...

Hi Craig

I've had a go with your example data using the following and it appears to do what you require ... well the removing of empty tiers

I hope it works...

Can you post the function you created?

Why? Please don't say "for performance reasons" until you've actually tested it. I tested all of the solutions offered so far and there's virtually no difference. Try...

Try

UPDATE table.Statements

SET field03 = REPLACE(LTRIM(REPLACE(field03, '0', ' ')), ' ', '0')

WHERE field03 like '0%'

This will only try to update where field03 starts with a 0. An index on...

Essentially what it is doing is, using the long string as an example.

Take the length of the text and divide it by 15 and add one. This gives us...