Results 1 to 2 of 2

Thread: Stored Procedure

  1. #1
    Bruce Clark Guest

    Stored Procedure

    I have a table that I need to scan for updated information, and, if the data has changed, issue a report of those changes. Also, I need to scan for what changes have been effected - so that I will have multiple reports based on what/how the data has changed (and I have no idea how!).

    Question 1: Is a stored procedure the best/only way to go (rules looked like the way to go, but I believe I can only have 1 rule per table(?)).

    Question 2: How to output the data? Can I output the data into a table after each result is returned from the stored procedure or do I have to wait until all the results are returned? Can I return the results to a spreadsheet or something on the order of Crystal Reports?

    Question 3: As I need this to occur daily, can I simply run it (whatever it is) as a scheduled task?

    Question 4: Can I receive an email of the resulting output?

    Since Chrismas is coming soon, I won`t ask for anything else (well maybe a Cubs pennant, but that`s probably too much!).

    Thank you very much for your consideration and assistance.

    Bruce Clark

  2. #2
    FREDDY Guest

    Stored Procedure (reply)

    Hi,

    This is a situation where a trigger would be best. You can set a trigger on inserts, updates and deletes.
    You can also capture the information being changed or added. (Deleted, Inserted)


    Hope this helps..

    Freddy.

    On 9/25/98 1:00:14 AM, Bruce Clark wrote:
    > I have a table that I need to scan for updated information, and, if the
    > data has changed, issue a report of those changes. Also, I need to scan for
    > what changes have been effected - so that I will have multiple reports
    > based on what/how the data has changed (and I have no idea
    > how!).

    Question 1: Is a stored procedure the best/only way to go (rules
    > looked like the way to go, but I believe I can only have 1 rule per
    > table(?)).

    Question 2: How to output the data? Can I output the data
    > into a table after each result is returned from the stored procedure or do
    > I have to wait until all the results are returned? Can I return the results
    > to a spreadsheet or something on the order of Crystal Reports?

    Question
    > 3: As I need this to occur daily, can I simply run it (whatever it is) as a
    > scheduled task?

    Question 4: Can I receive an email of the resulting
    > output?

    Since Chrismas is coming soon, I won`t ask for anything else
    > (well maybe a Cubs pennant, but that`s probably too much!).

    Thank you
    > very much for your consideration and assistance.

    Bruce Clark

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •