Heh, heh...

Turns out there was nothing wrong with my query, there was a problem on the DB server. Apparently it's been acting oddly...

Hoo-t:

I tried "ON R.ZIP=Range.Zip" right where you had the "ON ..." in your reply and got a different syntax error:

UPDATE dbo.Employee

     SET CongDist = R.CongDist

FROM dbo.Ranged R

     INNER...

Farrell,

Sounded like a good idea. I tried:

UPDATE dbo.Employee

     SET CongDist = R.CongDist

FROM dbo.Ranged R

     INNER JOIN( SELECT R2.Start, R2.Stop FROM dbo.Ranged R2 

                      WHERE dbo.Employee.hzip = R2.Zip) Range

WHERE...

Hopefully to close the debate on the soundness of determining Congressional districts from Zip Codes, we are provided a database of Zip Code to District matching by a data vendor....

Actually it's 1 min to update 30k rows using the 1+M row table as the source for the Update command. Looking at it I might be able to combine a...

1:12 (old) vs 1:09 (new). It doesn't seem like it's a lot but I have to run a total of 9 queries just like it for different target tables all...

Three seconds faster than the original query...

Yup. The table is periodically rebuilt (i.e. for congressional redistricting) and then we need to run it on the whole table.

I tried:

UPDATE dbo.EMPLOYEE SET

          CongDist = dbo.Ranged.CongDist

FROM dbo.Ranged...

That was exactly it.

Thanks.

Thanks. That's what I need to pass along to the IIS folks.

The SQLDTS article is essentially a copy of the code in the MSDN article, with the added description of how to wrap the code in a COM object. We're not...

Try the code at http://www.sqldts.com/default.aspx?218. This shows you how to have conditional processing with multiple paths in a DTS workflow. It will take a little pondering to understand (at least...

We use the loop code in http://www.sqldts.com/default.aspx?246 to process multiple text files in a number of DTS jobs.

You might also want to look at the code at http://www.sqldts.com/default.aspx?218....

Here's where you need to set the cursor location

    Set Conn = New ADODB.Connection

    Conn.CursorLocation=adUseClient

    Conn.Open fstrCnn()

Answered my own question for those of you who are interested...

I had to add "conn.cursorlocation=aduseclient" to my connection definition.