Home Convert : to comma separated value
Reply: 0

Convert : to comma separated value

user520
1#
user520 Published in June 23, 2018, 9:19 pm

I came across a row which has multiple values separated by a colon (:). SQL considers the values to be one and throws an error" Cannot fine the requested Privilege". Example of the row shown below.

Servername  Instancename    Databasename Environment userid      access
ITSUSMPW01430   ITSUSMPW01430   ALL        DEV       userid SYSADMIN:SERVERADMIN

Here 2 roles are requested seperated by : Need some assistance on how can we make SQL consider the values different?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.420399 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO