ASE Database forum - sql format problem

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

sql format problem

Tom

2005-12-21, 11:24 am

How do I do the following in sybase sql
I want to select the data from sysloginroles but only
display the roles on one line e.g.

suid srid
----- ----
1 sa_role,sso_role,rep
lication_role
8 sa_role

A simple select would look like this :-

select suser_name(suid),rol
e_name(srid) from sysloginroles
go

This gives

sa sa_role
sa sso_role
sa oper_role
priv sa_role
priv replication_role

Which is not what I want

Any help appreciated

Sponsored Links