Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community, I have the following situation:
I loaded a table from a financial statement to group by qty of installments paid the payment year and months, it loads correctly however need to load a table with the amount of accumulated payments remembering that there are months that can not occur and even payments occur in other months, following code below:
So I created a solution for using for loop, however I'm dealing with a database of over 1 million records and it is extremely slow to load, I need another solution.
in waiting, thanks
LOAD
ID_DOC,
YEAR,
MONTH,
count(DATE) AS PAY_MONTH
Resident DOCUMENT
Group by ID_DOC, YEAR, MONTH
order by ID_DOC, YEAR, MONTH;
I found the perfect solution, thanks
I found the perfect solution, thanks