create proc query_user
as
select
u.id,u.cname,[fcount]=case when u.type in(3,4) then fs.[count]*0.8 when u.type=2 then fs.[count]*0.7 else fs.[count]*0.6 end
from
t_user u
join
t_fenshu fs on u.id=fs.uid
go
exec query_user
as
select
u.id,u.cname,[fcount]=case when u.type in(3,4) then fs.[count]*0.8 when u.type=2 then fs.[count]*0.7 else fs.[count]*0.6 end
from
t_user u
join
t_fenshu fs on u.id=fs.uid
go
exec query_user
as
select
u.id,
u.cname,
case when u.type = 3 or u.type = 4 then 0.3 when u.type = 2 then 0.7 else 0.6 end * fs.fcount
from t_user u
left join t_fenshu fs on u.id=fs.uid
go
as
select
u.id,
u.cname,
case when u.type int(3,4) then 0.3 when u.type = 2 then 0.7 else 0.6 end * fs.fcount
from t_user u
left join t_fenshu fs on u.id=fs.uid
go