Post reply

How to show the last approver in a path? need help please

  • July 27, 2013 at 11:24 am

    #296013

    Dear friends ,

    Being new to sql, needed help on a urgent stuff-

    The requirement is for field called "Final Approver"-

    I nee to Show name of last approver in req approval path.

    E.g., say the following are listed as approvers in this order: Caldwell, Walter; Rondini, Joe; Zuccaro, Leo. Then This field should show Zuccaro, Leo.

    thanks

    DJ

  • July 27, 2013 at 12:32 pm

    #1636418

    Please provide a DDL script for your tables as well as some sample data and the expected result.

    Please have a look here: http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • July 28, 2013 at 1:46 pm

    #1636491

    dhananjay.nagarkar (7/27/2013)

    Dear friends ,

    Being new to sql, needed help on a urgent stuff-

    The requirement is for field called "Final Approver"-

    I nee to Show name of last approver in req approval path.

    E.g., say the following are listed as approvers in this order: Caldwell, Walter; Rondini, Joe; Zuccaro, Leo. Then This field should show Zuccaro, Leo.

    thanks

    DJ

    You will also get better response if you keep all your related questions in a single thread. I answered this question for you in one of those other posts you made.

     

Viewing 3 posts - 1 through 2 (of 2 total)

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