Evidently in my process I was creating several large temp tables(in excess of 100K rows). When I take them out and do small temp tables everything works fine. Thanks Razz for your help it got me started in the right direction, but right now my brain is fried.
