Can you expand on this bit please?

I don't know what turning a...

John Mitchell-245523 (10/22/2014)

---

You can do it by breaking each permission down into a sum of powers of two. Something like this should work:

SELECT UserName, ServerOperation, SUM(DISTINCT p)

FROM #Operations o

OUTER...

Interesting.

If you could find a way of breaking down the permission at row level (eg, from 7 to (4,2,1)), it may be possible to do a SUM() on the UNIONed...

:smooooth: Simple is good.

Try using square brackets around the variable name.

johnix76 (10/21/2014)

---

Hi,

i tried to use xp_cmdshell in order to execute a vbscript from a trigger and it works, but i notice that trigger wait until the vbscript was terminated.

i...

Sure. Use Jeff Moden's Splitter – see here[/url].

Eirikur Eiriksson (10/21/2014)

---

I strongly belief that dynamic SQL solutions should be avoided if possible, it normally doesn't take much of an additional complexity to render them useless or at least...

ScottPletcher (10/20/2014)

---

If the controlling column(s) are all from the same table, I suggest a computed column. That leaves the defining logic in only a single place, and allows the...

Exactly what I had in mind.

ronan.healy (10/20/2014)

---

No there is no great way to do this. The question I was wondering with the padding was more that will work well. But I was wondering when it...

Eirikur, do you ever do anything slowly? 😛

Steve Jones - SSC Editor (10/20/2014)

---

There isn't a great way to do this. You'd probably need to think about importing as ints, then transforming with the appropriate number of 0s...

Wow, good question.

If you were to model this in the database as you suggest, I would think that the best-performing solution would be one which generated dynamic SQL to perform...

What's the datatype of the column in the target table?

John's solution handles everything up to 999, not just 100.