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...

Why do the CONVERT when the ROUND works without it?

No problem.  The other thing you should consider doing is creating a lookup table:

DayNo (int, PK), Day (varchar(10))

and then populating it as follows:

1     Monday

2     Tuesday

........

7     Sunday

Then you can just do...

This can be achieved in many fewer lines, try this:

declare @days char(100), @classday varchar(10), @dayno int

set @days = '         Monday    Tuesday   Wednesday Thursday  Friday    Saturday  Sunday'

set @classday = 'Sunday'

set @dayno...

Eh?  Was this supposed to be part of another thread?  If not: "Which stored procedure?"

If your question is just: "Can stored procedures be called from VB6?", the answer is yes. ...

Sorry if this is obvious, but is Excel installed on the SQL Server server itself (if you know what I mean)?

Your error is happening at the CreateObject line, before the...

But I've just eaten 3 pieces of fried chicken & need to remove the grease somehow - not on my screen either

A fixed-length file has ALL records the same length!  Yours does not, so it is not.

If you've got less than 65,535 rows you can do it in Excel in 1...