Heh... I know the feeling...

Study sp_ExecuteSQL in BOL... it'll show you how to do exactly what you want.

It would be very helpful if you put this in just before the exec and printed out the result for us...

PRINT @strQuery

Dang, Joe... between this and the NULLs problem, I'm thinking that you've landed in a doozy of a place. Who are these geniuses that you keep having fights about...

Heh... if you took 5 minutes out ahead of time to fix it, you wouldn't have...

You might have a bit more luck getting a response to your posted this in the "Data Transformation Services" forum...

Yeah... that's the disappointing truth...

I'm actually on vacation, right now... I'll see if I can find that script at work on Monday... it's in a piece of automation I...

Heh... Jason, I'm sitting here reading where you wrote...

So if a NULL @variable is put in you won't return any records other than NULLS. Likewise, no matter what variable is...

Heh... at the very least, I'll go outside to have a smoke before I hit the "GO" button. Gives me time to think about whether I need to reword...

We have to compare the SRH table with contract_id and from the SRH table we have to take the field values which is lastly updated.. For example for single contract...

Thanks, Ian... great feedback! I really appreciate it.

Another possible reason is if you have to write...

Michael Meierruth (11/29/2007)

---

FYI, in France they...

Heh... That would be true for outputs... imported files are a whole (or is it "hole"?) 'nuther story....

TheSQLGuru (11/29/2007)

---

Kevin Boles. Glad to meet you. You must be Jeff Moden, right?? 😉

BTW, do you LIVE on this forum or something?? I needed the link...

The problem is that the header row does not have the same number of delimiters as the rest of the file. Unfortunately, Bulk Insert counts delimiters as well as...