calculate varianceThis is a discussion on calculate variance within the olap forums in Data Warehousing category; i have Query1 and Query2 Same columns in both (say c1, c2, c3, c4) I want a Query3 with Query3.c1 = Query1.c1 - Query2.c1 Query3.c2 = Query1.c2 - Query2.c2 where Query1.c3 = Query2.c3 and Query1.c4 = Query2.c4 this is the simplest way i can explain it Please help me out on this by sending the answer to jojy.kk-at-gmail.com Thnks JOjy... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
07-10-2008, 02:32 PM
|
 calculate variance i have Query1 and Query2 Same columns in both (say c1, c2, c3, c4) I want a Query3 with Query3.c1 = Query1.c1 - Query2.c1 Query3.c2 = Query1.c2 - Query2.c2 where Query1.c3 = Query2.c3 and Query1.c4 = Query2.c4 this is the simplest way i can explain it Please help me out on this by sending the answer to jojy.kk-at-gmail.com Thnks JOjy  |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 01:45 PM.
