建议还是分三次查吧,不然就写成:select @a=(select pi_gram from b_Papertype_Item where pi_type='3101')
, @b=(select pi_gram from b_Papertype_Item where pi_type='3120')
, @c=(select pi_gram from b_Papertype_Item where pi_type='3130')
, @b=(select pi_gram from b_Papertype_Item where pi_type='3120')
, @c=(select pi_gram from b_Papertype_Item where pi_type='3130')
@a=max(case when pi_type='3101' then pi_gram end),
@b=max(case when pi_type='3120' then pi_gram end),
@c=max(case when pi_type='3130' then pi_gram end)
from
b_Papertype_Item
@b=(case when pi_type='3120' then pi_gram else @b end),
@c=(case when pi_type='3130' then pi_gram else @c end) from b_Papertype_Item
@a = case when pi_type='3101' then pi_gram else @a end
,@b = case when pi_type='3120' then pi_gram else @b end
,@c = case when pi_type='3130' then pi_gram else @c end
from b_Papertype_Item
select @a=case pi_type when '3101' then pi_gram end,
@b=case pi_type when '3120' then pi_gram end ,
@c=case pi_type when '3130' then pi_gram end
from b_Papertype_Item
where pi_gram in(3101,3120,3130)