work but I get a syntax error
UPDATE Account a
SET a.last_update = (SELECT TOP 1 h.tranDate
FROM History h
WHERE a.Account_Number = h.Account_Number
ORDER BY h.tranDate DESC)
Basically what this is supposed to do is look at each account number in the
account table. Go to the history table for that account number and grab the
last date it sees for the history of that account number and populate the
account table with that date.
Any help would greatly be appreciated!
Jeff
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
