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

    https://dbfriend.blogspot.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

    https://dbfriend.blogspot.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 4 (of 4 total)

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