Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nheath.ipswitch
Starting Member
1 Post |
 Posted - 2011-12-08 : 15:46:21
|
| I have a query that works just fine against MySQL using the make_set function. The problem is, I need it to work against the MSSQL database - and I can't seem to find something that can replace that function within MSSQL. Here's the scenario:The query selects a bunch of information from the database, but when it comes to permissions (this is run against a secure server application), I use the make_set function to determine the specific permissions that each user has like this: (MAKE_SET(folderuser.Relationship,'N','b','S','','r','w','l','d','' ,'' ,'a','x','k','s','t','v','' ,'' ,'' ,'' ,'R','W','L','D','u','A') as Permissions)And as I mentioned, I can't find a way to create the same functionality when pulling the data from MSSQL. "folderuser.relationship" returns the binary data that the array of data is being checked against.Thank you in advance for your feedback. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-09 : 01:57:25
|
| i think you need to create a udf for this in sql server to achieve same functionality------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
|
|
make_set: MSSQL equivalent?