April 15, 2005 at 2:52 pm
I am creating a site to manage sales, payments, and scheduled payments if the user is financing their balance. I have it set up to store the sale, and payment transactions, but I am wondering if there is a way to automate the payment schedule process.
I would like to have the sales person enter the sale, the down payment,the number of payments, and the payment start date. I would then like the stored procedure to fire the same number of times as the number of payments and then increase the payment date month value by 1.
Is this possible using asp.net vb?
April 18, 2005 at 8:00 am
This was removed by the editor as SPAM
April 19, 2005 at 9:35 am
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. See SQL server BOL for examples.
You can then insert these values into a temporary table and select from the temp table to get back the values. Or store them in a permanent table somewhere.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply