Post reply

Returning Multiple Values

  • August 5, 2003 at 12:57 am

    #83953

    Hi

    I need to return a collection from the SP

    Say If I sent the GroupId I want to get the all the users in that group

    How can I do this




    My Blog: http://dineshasanka.spaces.live.com/

  • August 5, 2003 at 1:39 am

    #468580

    Are you returning the collection to another SP, to Query Analyzer, or to your front end code?

    Do you want a table returned, or a comma-delimited string of user names?

    Cheers,

    - Mark


    Cheers,
    - Mark

  • August 5, 2003 at 2:37 am

    #468587

    table would do




    My Blog: http://dineshasanka.spaces.live.com/

  • August 5, 2003 at 7:27 am

    #468646

    Not sure if this what you looking for but look up sp_helpgroup on BOL:

    exec sp_helpgroup 'role'

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

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