I presume that you are not capturing the changes themselves - you just know what tables are affected and want to send those to your 'live' server?  This sounds a...

OK - we're going to have to go into a bit more detail then.  Can you please post examples of the query that you are using, the source data, the expected...

But the left() function returns a varchar, not a datetime, so there's something strange going on here

Perhaps your problem is linked to the...

It seems that you are not sure of the root of the problem - is it VB, or is it SQL Server?  I suggest that you run Profiler to see...

So can you write the SELECT query for the unrelated table separately?  Eg something like this:

select CMclientName

from SCHOOLNET.dbo.clientmaster

WHERE CMclientName = 'whatever'

If you can,...

Can you use WAITFOR?  Check BOL for more details.

In Enterprise Manager, expand Management, right click on SQL Server Agent and select properties.  You'll be able to change the logon properties for the SQL Server Agent service there.

Have you run the stored proc with the debugger?  It might shed some light on things.

Regards

Or this

declare @m as money

set @m = 200.2365

select round(@m,2,1)

It does the rounding that you want, but leaves the 4 dps.

It's pretty straightforward.  Getdate() takes no parameters and always returns the current (system) datetime.  If you want other dates based on 'now', you'll have to use additional functions (eg for...

This link might be relevant:

http://support.microsoft.com/default.aspx?scid=kb;en-us;275847&sd=tech

I do not see why your query should not work, as long as:

a) StartDate and EndDate are both DateTimes

b) In the WHERE clause, you are careful with the getdate() bit. ...

I think that table variables might give you what you need - they can be passed as parameters to/from stored procedures - try reading the on-line help and see how...

What do you mean by 'linked table'?  Are you talking about a table residing in a linked server?  Or perhaps you're using Access and have linked to a SQL Server...

I still think that the error is happening before processing gets to the

Set Excel_WorkBook = Excel_Application.Workbooks.Open(sFilename)

line.  To prove it one way or the other, try changing sFilename to...