Hi Gurus,
I have created two queries which is exactly same in term the structure used but query a limited to current year and previous year and query b limited to previous year and previous to previous year. This is due to calculation logic that required for the query.(note that there is no data in the system for previous year)
When i execute both queries; query a return result but query b running forever and returning "Memory low error"
please advice what should i do
Thank you