Keeping Track of Data on a Report

Posted on 2011-05-04
Last Modified: 2012-06-27
In VFP I run a SELECT on Orders....

Then another SELECT * FROM cQuery WHERE cQuery.Order NOT IN (SELECT SentOrders.Order FROM SentOrders.DBF) into Cursor cNewRA

IF Count > 0
Select SentOrders
Append from dbf(cNewRA)

I run this every hour and with the hits I get I comare to the DBF from the last hour and if any new ones I can Email that out with the new orders
nothing happens until the next hour it runs

My question is how do I code this in SQL Server r2 so it can have a Table to store SentOrders and I can compare the new SELCT to it every hour and if there is new records send in EMAIL and update the SentOrders Table

Question by:jaymz69
    LVL 22

    Accepted Solution


    Author Closing Comment

    Looks like what I need.


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now