Thanks I'll check it out

Check out this example using unpivot

http://wordpress.robertdavidian.com/?p=12

Have you tried recompiling the execution plan? Compare both the SP / straight query plans and see if there different.

Thanks again David.

Thanks David for your quick response. The link you sent was interesting. So basically SQL will use as much memory as it wants unless an external process needs...

I meant to delete the original post. How do I do that?