 |
||
 |
 |
 |
 |
 |
|
| SQL Coders? by TAFKAM 01/31/2003, 10:03am PST | ||||
 |
 |
|||
| I know V's a database person, anyone else? I've been busting my head against this seemingly simple problem and thought I might as well run it up a flagpole over here as well:
Item=Text PRIMARY KEY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, Q1, Q2, Q3, Q4, FULLYEAR = real 1-12 = Months I have aggregate fields Q1, Q2, Q3, Q4, FULLYEAR that I want to stick the average of the periods into for a table full of records. What's the cleanest, easiest way to do it? 1-12 are nullable. That could potentially whack out the average values for a flat (1+2+3)/3 I thought of using variables and setting them to 1 or 0 depending on if NULL, then dividing by (var1+var2+var3), but that would be seriously wasteful in a loop for all records - Resetting the variables, testing them, writing * 5 fields x *100000000 records. Am I missing something obvious? |
||||
 |
 |
|||
|
SQL Coders? by 01/31/2003, 10:03am PST  Re: SQL Coders? by 01/31/2003, 5:15pm PST Re: SQL Coders? by 01/31/2003, 9:28pm PST Re: SQL Coders? by 02/01/2003, 4:14am PST Re: SQL Coders? by 02/01/2003, 8:40am PST |
