I need some help in my sql stuck with some project where i need to make a sliding ,moving window of sum of different amounts of money(threshold set for all days) in last 1,20, 40 and 150 days. The one with 40 days is slightly on a different filter. This window checks if transaction is beyond a certain amount in these days then some documents are needed. All data is arranged in tables.
Second query relates to first in a way that if highlighted in first case then it needs to be checked if documents were provided in next 10 days.
I have done the first query using sub queries but i am stuck in last part of first one where i need to use some more conditions for 40 days and cannot include it in the same set of sub query.
Do let me know i need urgent help.Thanks.
5 freelance font une offre moyenne de €7/heure pour ce travail
Hi, I am proficient in Sql and certified in SQL Querying 70-461. If you need urgent help I can do it. Please contact me for discussion about your project.