Skip to main content

All Questions

Filter by
Sorted by
Tagged with
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 ...
CJack's user avatar
  • 41
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 | +====================================================...
Nelson's user avatar
  • 1,689
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 = ...
Daedalus Mythos's user avatar
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 ...
Scott Chamberlain's user avatar