hi
Could someone please help me in following:
I have VB 6 program which print reports, manually by pressing Print
button, base upon Policy Statuses. I want to create a SQL job or any
automatic process to go through Policy table in SQL2000 and find out all
Policies with ‘Pending Open’ Status and then compare Commencement Date,
which stored in Benefit table, and today’s date. If Commencement Date on
or before today then change Policy Status to ‘Open’ and then print
Policy Status report by using VB6 but this time report will print
automatic after Policy Status changed to Open.
Any solution please
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!