I don't know how to do it :(

Question

I don't know how to do it :(

Viewing 4 posts - 16 through 18 (of 18 total)

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

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 1

COldCoffee (4/5/2010)
Jeff Moden (4/5/2010)
That will work for only 1 level of approval.
Jeff i did not have the time to execute the query, my bad :doze:.. but the solution using the recursive query must work for any levels... this the OP did not try customizing the code for his needs...

Understood. When I run into problems like this, it's because the OP hasn't provided enough information in a readily useable format. You did the honorable thing by trying to guess what the OP wanted and tried to make data that may suit the OP. To fix that, here's what I tell the OP and I hope (s)he's still listening...

To get a better and coded answer more quickly, please post tables and data in a readily consumable format. Please don't assume that you know how to do that. Instead, please read and heed the article located at the first link in my signature block below. 😉

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

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 2

Exactly Jeff!!

When the OP is unclear then we are explicitly type-casted to be unclear 😀 :w00t:

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 3

COldCoffee (4/5/2010)
Exactly Jeff!!
When the OP is unclear then we are explicitly type-casted to be unclear 😀 :w00t:

Heh... what I'm suggesting is that you add the link for the article to your signature block so you can do the same as a lot of us do... Refer the OP to the link. 😉

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

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 4

I always ask people to look up to your post on forum etiquettes Jeff.. i will add that to my signature as well 🙂