That sounds like a mess and I don't see what use a view containing that (even if possible) would do. What do you want to show? Where do you want...

Yeah that's good advice. As part of our improvement works we do have plans to split the load into smaller batches, and to include the updates as part of the...

No you can't. You need to create a form of relationship. Otherwise why have them in the same view?

EDIT: Maybe I misunderstood this!

Shocking all of them! 😛

Aha! So we have been provided a download link along with our developer license. DVD no longer supplied. Job done.

Is that the answer? I need a dev edition cd? Will that come through with the licenses generally?

If I install Enterprise evaluation now can I upgrade it?

Thanks for the reply.

I will try using output - good thinking. I normally only turn that on for vague errors - should have guessed it would contain more useful information...

I think that may well be the only option! (other than building my own logging functionality - yuck!)

Cheers

Let me know how that test goes BA Zero 😉 - I'm not in front of a SQL server until Tuesday now so no chance to test myself

actually i should have made it clearer - the timestamp does not represent the time it was last updated. It is the system time from the db we retrieve the...

it gets a little more complex that that as this product can sometimes drift x amount of minutes behind. So i need a way of saying, has the timestamp moved...

Yes but i'm pretty sure any precedence constraints requiring an expression to be met will not be met and therefore it will not move to the only enabled task (will...

I could do that, but I would have to store the data in a permanent table.

What I have done so far is to create a table variable that stores the...

Thanks Da-Zero - that will help me too!

I could do that, but surely there is a better method? I have tons of control flow tasks and containers and precedence constraints based on variable values (so it will...