I don't know if there are any tools out there or not, but I find the best way is to implement a 'use case'. This is a UML concept that...

Why not pass a stored procedure the start date and number of payments.

Then, just put a loop in the sp from 1 to number of payments using the while statement....

Unfortunately there is no minus equivalent from oracle in sql server, which is what you really want.

The choices I can see for you are:

Use the not exists query. Will take...

Sounds to me that your log and data files are trying to increase by 50%, but there is no more physical space to get.

Either increase your physical disk space, or...

I didn't mean that literally.

I have never come across the need to check for errors in stored procedures. I work in data warehousing and perform checks on data after load etc...

Try reformatting and testing in a different way. This link worked for me OK.

http://authors.aspalliance.com/brettb/VBScriptRegularExpressions.asp

Not aware you can create a spreadsheet with filesystemobject. All you're doing is renaming text file with excel extension. Will cause errors when opening.

This script will create a new excel file and set connection so that you can write to it:

--------------------------------------------------------------------------

'**********************************************************************

'  Visual Basic ActiveX Script

' Author:  Jon Stokes

' Created: 10th Sep 2004

' Purpose: To create excel...

Copule of things that might help.

1. I never use a local variable that is set with different values each time it runs. I find that the script often falls over. Create...

The best for business objects is BOB.

http://www.forumtopics.com/busobj/

Has a crystal forum, too. Good for going forward as the two join together.

Thanks again for the advice.

I've never needed to put error handling in before, but I think I've sussed it now.

Thanks a bunch Kenneth.

I was making the mistake of trying to put the output into a temp table rather than a variable.

I am now execute the code in a seperate sp and...

It all depends on what you want to do.

If you only want to export tables along with data, then most etl tools will do this for you. Some of thenm allow...

Sounds to me like you are using a mapped drive on your pc that does not exist on the pc that is failing.

Are you connecting to excel through an activex script?

If so, make sure you set the object to nothing at the end.

Is it just a normal package of excel source...