On Fri, August 17, 2012 12:29 am, Bill Anderson wrote: > 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.
No....really? But that's not part of the SELECT fields; it's just part of the FROM part. You're saying that that definitely gets evaluated for every row in a select? Jeez...if that's the case, I should just textmerge the entire thing into a variable and just execute the variable (&lcSQL). It's a moot point now, because I've already retooled it to load a simple lookup table when the text files are loaded, and hence the lookup table is the fair unique sample of all the provider numbers in the Claims and Discharge tables. Still...your tip perplexes me as it just doesn't seem to make sense that the FROM line would be evaluated for each row. Hmmmmmm... Thanks just the same for the reply! --Mike _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
