All Questions
Tagged with cursors sql-server-2005
4 questions
3
votes
1
answer
284
views
How to show when loan was paid off
First time posting but have been a reader for over 10 years. I have a need to show when a loan was paid off regardless of the rolling balance from refinancing/taking out additional loans.
In the ...
0
votes
1
answer
435
views
INSERT from SELECT using a CURSOR
I have a table that looks like this:
+====================================================+
| aid | uid | eid | name | dob | paid |
+====================================================...
4
votes
4
answers
3k
views
Keep track of time intensive stored procedure with prints
I am no database admin nor is my SQL-foo any good (yet), but have a few tasks to get done in MSSQL, and one is a rather time intensive procedure where I fetch from a CURSOR and WHILE @@FETCH_STATUS = ...
2
votes
2
answers
143
views
Performing a "Spread Negitive" over a dataset
I have a situation where a table that represents outstanding balances and credits are both contained in one table. What I need to do is apply all outstanding credits (preferably in order of oldest ...