> I want to create a stored procedure which will extract the "GroupName"
> from the record returned by "sp_helpuser". In order to do this I need
> to execute "sp_helpuser" which returns the entire record. I want to
> just extract the "GroupName" from the record and return it to my
> application. How do I go about this?

Erland Sommarskog <sommar@algonet.se> wrote in message news:<Xns93BF646E19EF7Yazorman@127.0.0.1>...
> Alvin Sebastian (asebastian@cmri.usyd.edu.au) writes:
> > I want to create a stored procedure which will extract the "GroupName"
> > from the record returned by "sp_helpuser". In order to do this I need
> > to execute "sp_helpuser" which returns the entire record. I want to
> > just extract the "GroupName" from the record and return it to my
> > application. How do I go about this?
>
> Either you access sysusers directly, you can use the INSERT EXEC construct:
>
> INSERT #temp (...)
> EXEC sp_helpuser
>