This kind of thing can get ugly in a hurry. Stop and think about appearance of the text in a situation with multiple sentences, and you start to...

I have to agree strongly that a table is a far better container for items between job steps when not using SSIS, and for the following reasons:

1.) It's easy to...

Without any sample data to work with, we have nothing to go on. I have to presume that the query that takes a long time is at least...

Yup, that's the problem all right. You posted your question in the SQL 2005 portion of the forum. I was coding on that basis, so the...

Interesting that the trigger only fires on insert, as an UPDATE could easily make it possible to change the value of a record so that it no longer matches. ...

Ummm... I think the real problem depends on the nature of the comparison. Looking for dates within x number of days of each other is NOT something...

Interesting that this topic should happen to come up at the point when I'm just starting to look beyond what I do with my domain controller. I...

As long as we're going down humor lane... how about a deadpan response?

DELETE FROM SQLSERVERCENTRAL

WHERE THREAD = ''

Steve

(aka smunson)

:-D:-D:-D

Please see my edited post. I realized I needed a few additional changes to get it right.

Steve

(aka smunson)

:-):-):-)

Ryan,

You may have just cleared up my confusion. When you join to the Service Order Jobs table, you can CROSS APPLY to a correlated subquery instead of joining...

Nothing beyond the fact that each database's schema was identical, and that all the databases were on the same instance of SQL 2005. The data source query's first...

I must be confused... I was going on the basis of the OP's original statement:

I am only interested in pulling back the one Service Order Job for each...

I hate to rain on the MAX of the DATE party, but just using MAX alone isn't going to get the results needed, as what happens when there's more than...

GSquared,

I don't recall the original poster mentioning whether those spaces had to be continuous. For example, what if you have a string like "My Good Boy Did A...

Jeff,

Here's the results from my machine (Quad-Core Intel Q9550 @ 2.83GHz, running Vista Ultimate 64-bit (SP2) and SQL Server 2005 Developer Edition 64-bit (SP3)):

===== Create VARCHAR table ===========================================

SQL Server Execution...