-
Alternative of Cursor in SQL Server 2005
Hi,
I have a table which contain following fields
account_no,
Payment_date,
Payment-Amount
Now this table contain all the history of all accounts for payments.
So if any account member has paid bills 100 times there are 100 rows for that and so on for all accounts.
Now I have to display the latest payment date and amount for all accounts.
So I am using the cursor for that, but the cursor is taking lot of minutes due to the large number of accounts.
So please tell me the alternative for this problem.
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
|
|