Okay, it looks like what you need is to parse out any rows where Col01, Col02, etc., have a postal code in them. It can be any one of...

A common way to test if there's a row that exists in a sub-table is with an EXISTS statement.

They usually look something like:

Select

case

when exists

(select *...

If I follow your description correctly, you are pulling data into a staging table, then running this on the staging table in order to get the postal code out of...

Evil Kraig F (1/24/2012)

---

Anyone else losing CR/LFs when they copy paste code off the site recently? I've had the problem in anything in a code="", plain or SQL.

EDIT: I...

Are they equality tests? As in @Value = Column. Or are they range/inequality tests, like @Value > Column, or Column between @Value1 and @Value2?

I think I'd go the linked server route.

Do you have a Where clause in your query? Is it against an encrypted column?

I looked a little. See if this article helps: http://www.mssqltips.com/sqlservertip/1137/supporting-tables-for-sql-server-2005-style-maintenance-plans/

All of that is stored in msdb. Maintenance plans are stored as SSIS packages, which aren't particularly query-friendly in the way you're asking. They're stored in msdb.dbo.sysssispackages, but...

You'll have to create a formula. Multiply the hours by 60, sum them up, add in the sum for the minutes. That gives you minutes worked. Divide...

Is the relevant date and time in another table, like an audit log or something?

If not, you can't get data out of a database that was never put into it.

If you really are stuck with a cursor, try Static instead of Fast_Forward Read_Only. Static cursors use more resources in tempdb, but are often faster than other options. ...

SELECT CONVERT(DATE, CURRENT_TIMESTAMP)

Alter table dbo.MyTable

add constraint DF_CurrentDate default(getdate()) on CurrentDate;

If I'm not mistaken, that should do what you need.

Any particular reason to use OpenXML instead of XQuery?

I'm not particularly familiar with OpenXML, but XQuery will get those values easily.