Adam Haines (3/25/2008)

---

Not sure how it could possibly be a seek with the leading % in the LIKE statement....

Is there a OPTION (FAST N) statement anywhere? All of these...

Database triggers. DDL triggers can be set up to occur on creation/deletion of objects.

BOL reference here:

http://msdn2.microsoft.com/en-us/library/ms190989.aspx

I think the big concern is that the way you would use this would force single-row processing, which in SQL server is VERY inefficient. That is often enough why...

Any chance that there's a DDL trigger somewhere?

Not sure...

Trader Sam (3/25/2008)

---

Ahhh...the key to your solution, Matt, is to build the row string on the INSERT into the temp table, rather than building it when SELECTING from the temp...

I've noticed that the script generator at time puts in too many parentheses, but they're harmless. They hurt nothing, and evaluate to the same thing when all is said...

Doesn't seem to be a problem here. Are you SURE it's in this snippet of code?

I cut and pasted it and it runs over here....

#1.Well - I'd probably build a large FOR XML EXPLICIT query, spit it to disk and post-process it to the format they want (way faster than solution #2). ...

Tim -

I'm in the process of setting up a VPC config to handle VS2008 and SS2008 (since I hear they affect the functionality in their 2005 counterparts, and I...

Steve - I don't know how much control you have over the page formatting, but there's a somewhat advanced version of CSS formatting called "Jello Mold" that allows for dynamic...

It looks like a cute technique, so I will keep it in mind. That being said - doesn't your quote above from BOL state that there must be a...

Marios Philippopoulos (3/25/2008)

---

I'm worried that the new LINQ technology shipping with SQL 2008 will open the door for more inline SQL code. I think it is a step in the...

Trader Sam (3/25/2008)

---

Because you are building a output string for EDI, it doesn't appear that you will be able to totally get away from some kind of row by row...

George Heinrich (3/25/2008)

---

Matt,

Thanks for the input.

The problem is that they set this column up as a varchar(15) and often replicate 0's to the front of it. So a cagecard id...