Tagged Questions
2
votes
2answers
77 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
vote
3answers
258 views
Find and remove gaps in sequence across two different columns
I've tried to solve this problem using a set-based approach. However, since I need to look at each row I think I must use a cursor; please correct me if I'm wrong.
The table:
Project, item, method, ...
1
vote
2answers
892 views
Why is this MySQL proc using cursors failing to retrieve results?
I am importing data from a third-party vendor. I have already imported their tables into my existing database. Now, I just need to iterate through each of their person records, munge it a little bit, ...
1
vote
1answer
391 views
When to open your MySQL cursor
A relatively simple question but from all my research I have been unable to find a decent answer.
Which is technically more correct, open your cursor after your handlers have been defined or before ...
0
votes
1answer
263 views
Date Format in Sql Server
I am importing data from another sources, which has multiple columns but I am facing problem in date column like I have multiple format in this column like:
dd/mm/yyyy
mm/dd/yyyy
mmm-yyyy
Can you ...
