Log in  ::  Register  ::  Not logged in

 Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 What Do You Call This Relationship ? Rate Topic Display Mode Topic Options
Author
 Message
 Posted Wednesday, February 20, 2013 11:49 AM
 SSCrazy Group: General Forum Members Last Login: Friday, November 18, 2016 12:42 PM Points: 2,947, Visits: 9,054
 I have a situation with items that are related, but not really in a heirarchy ... more like parent to parent. As shown below, all the ODD numbers are related to each other equally so that '1' is related to '11' via the other entries. ie, 5 is related to 1, and 11 is related to 5, therefore 11 is related to 1. And all the EVEN numbers are related to each other equally, so that '12' is related to '2' because 12 is related to 10, 10 is related to 8, and 8 is related to 2.I need to consolidate related rows into 1 summary row (selecting oldest & newest dates), and looking for examples on the InterWebz, but not sure what keywords I should be looking for to describe this kind of relationship.`Item_A Item_B5 16 47 38 29 710 610 811 511 912 10`
Post #1422233
 Posted Thursday, May 16, 2013 3:37 PM
 SSC Eights! Group: General Forum Members Last Login: Yesterday @ 4:16 PM Points: 988, Visits: 1,923
 With the ODD numbers, how is 7,5,3 related. Did you miss 7 is related to five?thanks ----------------------------------------------------How to post forum questions to get the best help
Post #1453800
 Posted Friday, May 17, 2013 3:20 AM
 SSCrazy Group: General Forum Members Last Login: Monday, November 28, 2016 10:12 AM Points: 2,934, Visits: 5,475
 It's a tree or hierarchy, whatever you prefer.I guess, you will need to use some sort of recursive CTE. Hard to say anything more based on provided limited details. _____________________________________________"The only true wisdom is in knowing you know nothing""O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"(So many miracle inventions provided by MS to us...)How to post your question to get the best and quick help
Post #1453900

 Permissions