Good spot, Bill! -- rk
-----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Bill Anderson Sent: Friday, August 17, 2012 12:29 AM To: profoxt...@leafe.com Subject: Re: Query taking 4 minutes...ugh Store the AddBS() function and the cClaimsTable reference to variables, then use those variables in the SELECT statement. You're evaluating each expression with every row. Bill Anderson _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD044216907E393@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.