Using regression functions in a query.
From: Scott <smaclellan_at_sweetheart.com>
Date: Thu, 30 May 2002 17:06:38 GMT
Message-ID: <y_sJ8.950$%k1.726445_at_monger.newsread.com>
Date: Thu, 30 May 2002 17:06:38 GMT
Message-ID: <y_sJ8.950$%k1.726445_at_monger.newsread.com>
I need to issue a SELECT statement with the REGR_SLOPE() and REGR_INTERCEPT() functions and then use the returned values against the individual values in the same table. Is there any way to do this in a single SQL statement or do I need to store the values in a temporary table? Received on Thu May 30 2002 - 19:06:38 CEST