All Questions
2 questions
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 = ...
- 267
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 ...
- 1,045