It's just what it says, "The package failed validation." Presumably there is some other error message that gives more information about how it failed. We would need that...

I think what you are looking for is

WHERE field NOT LIKE '%[^0-9]%'

The square brackets specify a subset of characters determined by the contained expression.

The caret (^) at the beginning of...

The first error is probably caused by using an old version of dtexec. This will happen if you have both the SQL 2000 and SQL 2005 client tools installed...

Remember dtField represents a...

You could also try the undocumented stored procedure sp_msforeachtable.

Drew

You have a couple of choices. In this case, a CROSS APPLY is probably going to perform best, but you may find that a CTE with ROW_NUMBER() will perform...

First, you have to remember that SQL is optimized for set-based operations while the language that you are translating from is most likely primarily a procedural language. Translating directly...

From books online

The datatype returned by a function is part of the database state, so you can't write...

You're probably better off doing this in the presentation layer rather than in T-SQL. For instance, this is easy to do in SSRS by specifying the visibility property of...

opc.three (3/17/2011)

---

Using a binary collation was my initial thought. I suspect that adding the check for datalength will be slower than using the collation method but have not tested out...

You are...

The problem is that you are using absolute paths on the original column when you should be using relative paths on the derived columns.

SELECT stores.detail.value('(StoreName)[1]', 'varchar(50)') AS store_name

...

There is a separate forum for SQL 7.0/2000...

You'll probably want to use the ROW_NUMBER() partitioned by the Category for determining the columns. Before pivoting you'll have

A Aardvark 1

A ...

I'm not sure about other tools, but I've found that for creating complex XML structures using T-SQL, you're better off using FOR XML EXPLICIT instead of any of the other...