Thanks for the reply. Yes, it is a very complex query, and yes I did check for memory utilization. SQL is using dynamic and it acquires the max allowed memory when this query is run. Was just wondering if there is a bug associated with this somewhere. had to put this on the back burner, but will pick it up again soon.