Results 1 to 2 of 2

Thread: Running Total cursor

  1. 04-16-2006, 10:25 AM #1
    anaylor01
    anaylor01 is offline Registered User
    Join Date
    Apr 2006
    Posts
    1

    Running Total cursor

    I have two tables. ID table that has these fields
    Code_id,YearPeriod, ReachedDate fields. And table
    Amount that has Code_id,Amount,Date fields. What I
    need to do is write a cursor that when the
    amount.Amount adds up to $100.00 it Updates the
    ReachedDate in the ID table to the amount.date fields
    value of that record. Any help would be greatly appreciated.
    Reply With Quote Reply With Quote
  2. 04-21-2006, 11:36 AM #2
    mmarovic
    mmarovic is offline Registered User
    Join Date
    Apr 2006
    Posts
    3
    See my article: http://www.sql-server-performance.co...ly_problem.asp
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules