Post reply

Want to append two different text values with a result set!

  • November 20, 2010 at 2:58 am

    #231426

    HI,

    I am using a store procedure to return value.

    ID Name Role Date

    8palaneeswar_c All Approvers2010-11-18 23:02:43.990

    13Deepak_Agarwal109 All Approvers2010-11-18 23:02:38.447

    Finally i want to create a result set as this based upon the roles.

    TL1 palaneeswar_c Date2010-11-18 23:02:43.990

    TL2Deepak_Agarwal109 Date2010-11-18 23:02:38.447

    TL1 in case of All Approvers or HR TL

    TL2 in case of All Approvers or Management TL.

    Please guide me as how cna i achieve this..

    As I am new so let me know if furthur information is required.

  • November 20, 2010 at 4:31 am

    #1253388

    DON'T cross post.

    http://www.sqlservercentral.com/Forums/Topic1023904-391-1.aspx

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server

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

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