Hi, I've got a quick fix but probably not the real answer to your problem.

If you copy a blank cell and do a paste special / values / add...

Once you have written your query in QA stick the results into a global temporary table (SELECT * INTO ##WeAreAllClearlyBonkers FROM sometable). Use a query table to get the data...

You need to be careful how you pass the dates between the two databases. The integers representing a given date in one may represent a different date in the other....

I guess you need to create your own version of the datepicker that inherits the datetime picker and allow it to have a null value. Not sure how you go...

re. Q1) Have you thought about using the sqlDateTime data type which supports nulls? using System.Data.SqlTypes;

Not quite sure I understand the second question..perhaps you could expand...

Just create both temporary tables with create statements and insert the data in!!

Sounds like you might want to use a sql trace rather than schedule a task? Have you thought about using the profiler?

Just been reading an article about using temporary tables and it recommends that you use DDL (i.e. build it yourself) rather than use select into. That way you can be...

That's not a query table though... It can be cumbersome going through a recordset record by record. This is the VBA to add a query table. You need to put...

Yes. In Excel goto Data/Get External Data.New Database query. Follow the steps. It's fairly straightforward and is a good quick way to display your database data in a spreadsheet. Hope it's helpful....

Much easier to use a query table unless you have a specific reason not too!

Have you thought about using a querytable in excel. It might be easier?

Out of interest can you tell me how they worked out that it is faster? And faster than what exactly?

This maybe?

DECLARE @dtmDateTime dateTime

SET @dtmDateTime = getdate()

--DATE WITH NO TIME using conversions

SELECT @dtmDateTime as [Current Date Time],

CONVERT(DATETIME,CONVERT(INT, CONVERT(FLOAT,@dtmDateTime)))

This 2004-12-10 09:32:10.500                               

to this 2004-12-10 00:00:00.000

?

Just for your info. If you want to put a carriage return in a cell while editing the cell hit alt+return.