Jpotucek,

C'mon... I'm trying to help... I need the answers to the questions I asked above so we can avoid the problems you're having...

Now isn't that odd... aren't those the same stages as a job? 😉

Better think about DBCC UPDATEUSAGE once in a while....

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...