Skip to Content
0
Former Member
Jun 08, 2011 at 05:05 AM

Query hit memory low error

46 Views

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