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...

SELECT Convert(varchar(25), Max(dt), 100)

FROM #Temp

WHERE DateDiff(Month, dt, Getdate()) BETWEEN 1 AND 2

GROUP BY DateDiff(Month, dt, Getdate())

ORDER BY Max(dt)

I personally would return the dates in datetime format, rather than converting them...

Because they appear in the SELECT clause instead of the FROM clause the aliases a, b, and c are column aliases, but you are trying to treat a and b...