Luis Cazares (9/24/2013)

---

You have a nice plan and good ideas, but I would really suggest a different approach on the splitter. Check the following link to improve the performance of...

Hi. the only effective way to do this is:

1. Create a VIEW of the table for the low-security user with the columns that s/he may see.

2. Set up two...

Hi. I would personally take a different tack.

1. I'd write a string-split UDF something like this: http://stackoverflow.com/questions/5968839/sql-server-2008-t-sql-udf-split-tailoring. This is a table valued UDF that returns the string...

Hi...

1. The first question I have is whether !!! can appear anywhere else in the text. Probably not, but one should ask.

2. You have a row delimiter of !!!...

Found this out the hard way a fewweeks ago in a database that was part of a peer-to-peer transactional replication topology. :ermm:

Thanks for the point!

"Semper in excretia, sumus solum profundum variat "

How true, and on this question, the depth is excessive. 🙂