Tricky hierarchy question

Question

Tricky hierarchy question

lewisdow123

Mr or Mrs. 500

Points: 562
More actions
June 18, 2015 at 10:45 am

#305310

ORGINAL QUESTION MOVED TO: http://www.sqlservercentral.com/Forums/Topic1695984-3077-1.aspx

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

You have obfuscated the real problem so much that it is really hard to figure out what you are trying to do. Can you post some ddl, sample data and expected results? It doesn't have to be real data but enough that it covers the problem. Please take a few minutes and read the first link in my signature for best practices when posting questions.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 2

Does the real "original" table actually have 5 columns in a manner similar to what your first table is or does it "just" have a "Parent" and "Child" column?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

lewisdow123 Mr or Mrs. 500 Points: 562 More actions · Answer 3

Hi,

I have reposted in here... http://www.sqlservercentral.com/Forums/Topic1695984-3077-1.aspx

Thanks

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 4

lewisdow123 (6/19/2015)
Hi,
I have reposted in here... http://www.sqlservercentral.com/Forums/Topic1695984-3077-1.aspx
Thanks

You really need to stop multi-threading. You should have posted your corrected data on this thread so that others can see the "development" of both the problem posed and the solution without have to jump to another thread. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)