Jon,

That's a great question, but there's no way I know of. I'll ping a few people and see if they have an idea.

Steve

Wow, that is very interesting. It doesn't seem to give great specs on the process in terms of energy required vs energy received, but it seems somewhat self sustaining.

This would...

Which project? Building the agents or the script?

GPF2^192 wins for the best post of the day!!!!!

I like Remi's solution. Might want to add another column to order by

Select col1, col2, col3, 1 'ord' from dbo.OracleTable

UNION ALL

Select cast(count(*), null, null as SameDataType as col1), 2 'ord'...

Which tool are you using? I'm sure Lumigent or the other firm's tech support could work with you to recover the data.

And one of ours

http://www.sqlservercentral.com/columnists/sjones/sqlmailresources.asp

Where are the suck-ups? No votes for Andy, Brian or myself . We have shirts and books to give away

You can create a linked server which will allow you to query a table on server B from server A. The syntax is in books online and there. There are...

As an update, I have moved this to administration (SQL Server 2k)

Beware of the times, which are also included. You might want to add one day to the end day if you are missing values.

One of your fields is an identity field. Typcially you leave that field out of the insert () list and do not insert a value for it in the VALUEs...

That's less fun. Besides, I think I learned a few things by reading all the posts

I ended up changing the alias name so...

How do you tell that you have later dates? Is it just by the date? Is there some other linkage? If it's just by date, then how would you ever...

I like using something to differentiate variables from other code, especially non SQL languages.

for iCounter = 1 to 10

instead of

for counter = 1 to...