Hierarchical data :skipping child rows up to the parent
-
Hi ,
I have hierarchical data in a table having UserId and his ParentID
Every user has a task , if a user is absent ( a flag in another table ) a the task should show up in the higher level person's task
so if all the child records of parent are absent the task propagates to the highest level where level_Id=1 and parent user id is 0 (zero)
Could you please help writing a procedure which can get the userIds list of tasks (where 1 or all of his child-records are absent )
Thanks!
-
Please read this and re-post as suggested.
http://www.sqlservercentral.com/blogs/spaghettidba/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ - Joe Torre - Monday, May 15, 2017 5:51 PM
Ok. I'll repost with examples.
Please delete this one. Thanks! - SJanki - Monday, May 15, 2017 8:23 PM
So what happened? You didn't post anything here or on a new post.
--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)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply