>I thought maybe the failure to reference the server and schema explicitly might be a violation of syntax? I seem to remember getting a syntax error in TSQL building a string like that and not using server.schema as part of the table reference.
>
>Actually, I was missing a quote in this part of the string:
>
>AND (HCT.SAMPLE_LOCATION IN ("SR", LF","LR")
>
>I just couldn't see it after looking at it for so long...
>
>Thanks, Charles.
>
>How goes it?
>
>-- Marcia

Really well. My contract at Dow Jones has survived the creation of the joint venture with S&P so now I am up to my ears in writing stuff to integrate systems which gives me a chance to do a lot of SSIS and TSQL work that has really stretched my skill set to new places. Of course being able to bill 40 consultant hours a week on a W2 while never leaving my house is kind of cool too <bg>

I'm hoping this one lasts well into next year. McGraw Hill - which is the majority owner of the joint venture through its ownership of S&P - is an Oracle - Java shop so at some point my .NET - SQL won't be as useful, but there is a lot of data and systems stuff to do between now and complete integration so I'm hoping to be involved in that as long as possible.

Have become a real believer on set-based back end processing now. It was a blind spot for me before and in the future I'll be looking at development with a lot more options in mind.