Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Joining to select's not a union
Message
De
04/02/2005 16:28:20
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00984011
Message ID:
00984030
Vues:
20
I was just using those query's as a simple example.. Here are the real ones.. I need to end up with one row of data from the 2 statements below.
declare @fromdate datetime
declare @season varchar(10)
declare @thrudate datetime
declare @region int
declare @branch int
set @fromdate = '01/01/2004'
set @thrudate = '05/01/2005'
set @region = 16
set @season = 'fall'


select 
count(*) as [regional total],
sum(q5)/ count(q5) as [q5 regional mean],
sum(q9_1)/ count(q9_1) as [q9_1 regional mean],
sum(q9_2)/ count(q9_2) as [q9_2 regional mean],
sum(q9_3)/ count(q9_3) as [q9_3 regional mean],
sum(q9_4)/ count(q9_4) as [q9_4 regional mean],
sum(q10_1)/ count(q10_1) as [q10_1 regional mean],
sum(q10_2)/ count(q10_2) as [q10_2 regional mean],
sum(q10_3)/ count(q10_3) as [q10_3 regional mean],
sum(q10_4)/ count(q10_4) as [q10_4 regional mean],
sum(q16)/ count(q16) as [q16 regional mean],
sum( rating_a )/ count(rating_a) as [rating_a  regional mean], 
sum( rating_b )/ count(rating_b) as [rating_b  regional mean],
sum( rating_c )/ count(rating_c) as [rating_c  regional mean],
sum( rating_d )/ count(rating_d) as [rating_d  regional mean],
sum( rating_e )/ count(rating_e) as [rating_e  regional mean],
sum( rating_f )/ count(rating_f) as [rating_f  regional mean],
sum( rating_g )/ count(rating_g) as [rating_g  regional mean],
sum( rating_h )/ count(rating_h) as [rating_h  regional mean],
sum( rating_i )/ count(rating_i) as [rating_i  regional mean],
sum( rating_j )/ count(rating_j) as [rating_j  regional mean],
sum( rating_k )/ count(rating_k) as [rating_k  regional mean],
sum( rating_l )/ count(rating_l) as [rating_l  regional mean],
sum( rating_m )/ count(rating_m) as [rating_m  regional mean],
sum( rating_n)/ count(rating_n) as [rating_n  regional mean],
sum( rating_o )/ count(rating_o) as [rating_o  regional mean],
sum( rating_p )/ count(rating_p) as [rating_p  regional mean]
from v_bf_boxscores 
where [start date] > = @fromdate and [start date] <= @thrudate 
and season = @season and region = @region

  
select count(*) as [overall total],
sum(q5)/ count(q5) as [q5 overall mean],
sum(q9_1)/ count(q9_1) as [q9_1 overall mean],
sum(q9_2)/ count(q9_2) as [q9_2 overall mean],
sum(q9_3)/ count(q9_3) as [q9_3 overall mean],
sum(q9_4)/ count(q9_4) as [q9_4 overall mean],
sum(q10_1)/ count(q10_1) as [q10_1 overall mean],
sum(q10_2)/ count(q10_2) as [q10_2 overall mean],
sum(q10_3)/ count(q10_3) as [q10_3 overall mean],
sum(q10_4)/ count(q10_4) as [q10_4 overall mean],
sum(q16)/ count(q16) as [q16 overall mean],
sum( rating_a )/ count(rating_a) as [ rating_a  overall mean], 
sum( rating_b )/ count(rating_b) as [ rating_b  overall mean],
sum( rating_c )/ count(rating_c) as [ rating_c  overall mean],
sum( rating_d )/ count(rating_d) as [ rating_d  overall mean],
sum( rating_e )/ count(rating_e) as [ rating_e  overall mean],
sum( rating_f )/ count(rating_f) as [ rating_f  overall mean],
sum( rating_g )/ count(rating_g) as [ rating_g  overall mean],
sum( rating_h )/ count(rating_h) as [ rating_h  overall mean],
sum( rating_i )/ count(rating_i) as [ rating_i  overall mean],
sum( rating_j )/ count(rating_j) as [ rating_j  overall mean],
sum( rating_k )/ count(rating_k) as [ rating_k  overall mean],
sum( rating_l )/ count(rating_l) as [ rating_l  overall mean],
sum( rating_m )/ count(rating_m) as [ rating_m  overall mean],
sum( rating_n)/ count(rating_n) as [ rating_n  overall mean],
sum( rating_o )/ count(rating_o) as [ rating_o  overall mean],
sum( rating_p )/ count(rating_p) as [ rating_p  overall mean]
from v_bf_boxscores 
where [start date] > = @fromdate and [start date] <= @thrudate
and season = @season
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform