select convert(varchar(100),convert(smalldatetime,C_OrderDate),112) as C_Date,
b.C_KsCode as C_KSCode,
(select top 1 C_KsName from t_sys_ksys x where x.C_KsCode = b.C_KsCode) C_KSName,
(select top 1 I_ClassId from T_Check_DrugLimt x where x.C_DrugCode = b.C_ItemCode) C_ADrugTypeID,
C_ItemCode as C_ADrugID,
(select top 1 C_ClassName from T_Check_DrugLimt x,T_Dict_Drug_Class y where x.C_DrugCode = b.C_ItemCode and x.I_Id = y.I_ClassId)C_ADrugTypeName,
(select top 1 C_DrugName from T_Check_DrugLimt x where x.C_DrugCode = b.C_ItemCode) as C_ADrugName,
case when C_Frequency is not null
then sum(N_SingeDose*cast(left(C_Frequency,charindex('/',C_Frequency)-1) as float)/cast(right(C_Frequency,len(C_Frequency)-charindex('/',C_Frequency)) as float))
else sum(N_SingeDose)
end as ddds,
(select top 1 N_Ddd from T_Check_DrugLimt x where x.C_DrugCode = b.C_ItemCode ) as N_Ddd
from T_His_ZyBr_OrdersInfo b
where I_ItemProp = 1
and (select top 1 I_Adrug from T_Check_DrugLimt x where x.C_DrugCode = B.C_ItemCode )>0
and (select top 1 N_Ddd from T_Check_DrugLimt x where x.C_DrugCode = b.C_ItemCode ) <> 0
group by convert(varchar(100),convert(smalldatetime,C_OrderDate),112),
b.C_KsCode ,
b.C_ItemCode,
C_Frequency
b.C_KsCode as C_KSCode,
(select top 1 C_KsName from t_sys_ksys x where x.C_KsCode = b.C_KsCode) C_KSName,
(select top 1 I_ClassId from T_Check_DrugLimt x where x.C_DrugCode = b.C_ItemCode) C_ADrugTypeID,
C_ItemCode as C_ADrugID,
(select top 1 C_ClassName from T_Check_DrugLimt x,T_Dict_Drug_Class y where x.C_DrugCode = b.C_ItemCode and x.I_Id = y.I_ClassId)C_ADrugTypeName,
(select top 1 C_DrugName from T_Check_DrugLimt x where x.C_DrugCode = b.C_ItemCode) as C_ADrugName,
case when C_Frequency is not null
then sum(N_SingeDose*cast(left(C_Frequency,charindex('/',C_Frequency)-1) as float)/cast(right(C_Frequency,len(C_Frequency)-charindex('/',C_Frequency)) as float))
else sum(N_SingeDose)
end as ddds,
(select top 1 N_Ddd from T_Check_DrugLimt x where x.C_DrugCode = b.C_ItemCode ) as N_Ddd
from T_His_ZyBr_OrdersInfo b
where I_ItemProp = 1
and (select top 1 I_Adrug from T_Check_DrugLimt x where x.C_DrugCode = B.C_ItemCode )>0
and (select top 1 N_Ddd from T_Check_DrugLimt x where x.C_DrugCode = b.C_ItemCode ) <> 0
group by convert(varchar(100),convert(smalldatetime,C_OrderDate),112),
b.C_KsCode ,
b.C_ItemCode,
C_Frequency
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货