>
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.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.