Good point! I try to stop people doing that in production code, but a few get through the net.

Configure your flat file source connection with | as the column delimiter and let SSIS do the work for you. See here[/url] for an example.

Is the data coming from a flat file?

Are there always three items?

Are the columns always the same length?

Grant Fritchey (10/23/2014)

---

You could try SQL Search[/url] from Red Gate. It's a free tool that should find those references pretty easily.

Mandatory disclaimer (although I'm not sure why for a free...

If you have your databases scripted into...

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...