Have you looked at bcp's -E option?

/Kenneth

The max number of seconds in a minute is 59, thus adding a second to 59 should indeed be 0 (as long as you're dealing with seconds as a datetime...

I wonder how they have implemented that function? If they rely on sp_depends (ie sysdepends table), then it doesn't work

/Kenneth

Something like this?

(as a bonus this also lists which type of object 'word' is found in)

-- a quick & dirty way...

If you want to be able to use eventual indices on the datecolumn and if you don't want to supply any parameters, and if you by 'yesterday' mean the day...

It's all explained in BOL, just look for '@@IDENTITY'.

/Kenneth

Ouch, sorry Frank, I forgot 

(editing 'Depending on circumstances' to 'It depends')

/Kenneth

Ah, so it was a PHB requirement behind it all..

Well, as I see it, the moral of this story is: never ever let the...

Search BOL for "Distributed Queries and Distributed Transactions" - there's a lot of good info there on the subject.

I'm dubious though, if it's such a good idea to have distributed...

No, haven't done it.

Can you expand on more precisely what you're trying to do?

/Kenneth

Depending on circumstances and exactly how you want to use it, there are three different things you should look at.

@@IDENTITY, SCOPE_IDENTITY, and IDENT_CURRENT. All three are described in detail in BOL.

/Kenneth

Checking the return value doesn't say if any data was returned or not, it only tells if sp_help_job failed (which of course means there was no data

Well, I don't quite get how the priorities would work, so I can't comment on that, but - if speed isn't the problem, why not then put the hugeDerived into...

IF you want to try out the suggested solution, be sure to read this http://www.sommarskog.se/dynamic_sql.html before you decide if it's a good idea or not to use dynamic SQL.

There...

I'm having a really hard time figuring out how this can be done.

You want two querys (that is two separate select statements) both using the same "table", in this case...