Yes. It was very poorly worded.

I could understand if you say "moved the criteria" rather than changed the criteria. Strictly speaking, if you changed to the...

Another poor QOD.

The option of disabling the triggers is a valid choice and seems more reasonable given the question. Please give points to anyone who answered that way.

Oracle's PL/SQL is a very robust language that is very similar to Ada. It has strong typing, some overloading, exception handling on a par with the currently popular languages,...

Thanks to jarney for this. IMHO, it really helps to have references to MSDN or BOL.

These sort of references can quickly dispell unsubstantiated arguments and different experiences....

I would recommend that we get some references to MSDN or BOL to back up the answer.

There seem to be too many other experiences out there that contradict...

I think it would be quite helpful to have the "proof" in the answer by including references to the appropriate MSDN page, BOL topic, or other on-line article in the...

There is another outstanding SQL Server problem report that I just came across that is very similar and probably explains this.

The published problem doesn't list subqueries as affected,...

It appears that without the CAST to VARCHAR(1000) there is some sort of assumption about the length of the result.

So if there is an explicit CAST that assumption...

Could someone post the KB article relating to this bug. I couldn't find it.

The detailed procedure can be gleaned from the code by anyone familiar with the database. Even for a technical spec, it's usually the "why" or the concept that are...

Your right. The word "Server" should not have been capitalized as if it were a proper noun.

I think that the reference should have been to "SQLServer2". Server2 might have been any old variable containing anything.

The first two answers seem to imply the prefix "Nothing."...

For the first method "SET @table = dbo.fn_splitstring..." the error message says it all: you need to declare @table first.

Use:

DECLARE @table TABLE ( item VARCHAR(255) ) --...

So why can't they be used in UDFs?

Perhaps the signs are different in the UK, but here in the US we have maximum speed or speed limit, not "maximum limit", and a few with "minimum speed". ...