I've often found that modifying that kind of script to "walk the clustered key" works better.

Also - an "EXISTS" syntax might actually work better. It also makes sure...

If this IS for a GUI application, then someone needs to hit the books and read up on "normalization".

Exactly how many parameters and/or variables (can't tell what these are)...

An ugly way to find out is to use a "locked" table. Again - at this point, we're piling ugly code on top of ugly code, so this may...

Even if you are - shouldn't you be keeping...

Alternatively - simply do a "find/replace", replacing your angled brackets with their HTML equivalent.

That's

replace < with &lt;

replace > with &gt;

Parameters work better when you use sp_executeSQL instead of just EXEC. I'm thinking you could do that using sp_ExecuteSQL.

Considering there's a function to do that in .NET - I'd build a CLR function to handle it.

Agreed on all counts. I even go one step further - I don't keep huge history files in the same database. So - I use a "local" history file...

yup...

Have you tried setting the "update statistics" to ON during the detach? (I'm paraphrasing the actual name). It would at least make sure that the stats are...

BobM (3/25/2008)

---

RBarryYoung -

So there is no 'inline' way to update a value before it gets written? Would the update in your trigger cause the same trigger to fire...

David Naples (3/25/2008)

---

The only downside to having everything in SPs is that it would mean that developers have the ability to write SQL code. It's been my experience that, unless...

Chris Gierlack (3/25/2008)

---

Ahhhh wait. Now I'm getting somewhere. Based on what you just said I ran 3 different scenerios:

1) LIKE %nn%

2) LIKE %nn

3) LIKE nn%

1 and 2 took...

I'm not sure I saw an answer to this - how is the data being used? Is it being access by a common front-end? Do each of the...

AVB - we'd need to start with some better specs. Tell us how the file is to be built: what is in the file header, in the invoice header,...