DECLARE @VAA01 INT, @VAA07 INT, @VAP01 INT, @ACF01 INT, @SDate datetime, @EDate datetime,@ES varchar(20)
select @VAA01=%d, @VAA07=%d, @VAP01=%d, @ACF01=%d, @SDate='%s', @ES='%s'

--2.19.4以后版本修改
if len(@ES)=10
set @EDate=@ES+' 23:59:59'
else if len(@ES)=16
set @EDate=@ES+':59'
else
set @EDate=@ES

select
   VCF09          AS [Date]   --护理日期
  ,VCF11          AS [Case]   --情况： 01-入院, 02=手术, 03=分娩, 04=转入, 05=回室, 06=出院, 07=死亡, 11=拒测, 12=请假, 13=外出
  ,VCF21          AS [Class]  --班次
  ,CONVERT(CHAR(1), VCF22) + CONVERT(CHAR(1), VCF23) + VCF24 
                  AS [Ah]     --体温 1(体温部位) 2(物理降温标记) 3-Max(体温)
  ,CONVERT(CHAR(1), VCF27) + CONVERT(CHAR(10), VCF30) + ISNULL(VCF28, '')                  
                  AS [Pulse]  --起博器,脉搏,心率
  ,CONVERT(CHAR(1), VCF32) + VCF33 
                  AS [Breath] --呼吸
  ,VCF33          AS [Breath1] --呼吸1,用于表单显示
  ,VCF41 + '/'+ VCF42
                  AS [mmHg]   --血压
  ,CONVERT(CHAR(1), isnull(VCF54,'')) + CONVERT(CHAR(10), isnull(VCF55,'')) + ISNULL(VCF56, '')
                  AS [Pee]       --小便 1(排尿方式) 2-11(尿量) 12-Max(尿次)
  ,CONVERT(CHAR(1), isnull(VCF57,'0')) + CONVERT(CHAR(10), isnull(VCF59,'')) + ISNULL(VCF58, '')
                  AS [Shit]  --大便 
  ,CONVERT(CHAR(1), VCF40) +VCF39
                  AS [Ct]     --皮试
  ,VCF53          AS [Ins]    --总入量
  ,VCF61          AS [Outs]   --总出量
  ,VCF35          AS [Height] --身高
  ,VCF37          AS [Weight] --体重
  ,VCF44          AS [SO2]    --血氧饱和度SO2
  ,VCF63          AS [AC]     --腹围 abdominal circumference 
  ,VCF65          AS [Other1]
  ,VCF66          AS [Other2]
from
  VCF1
where
  VAA01=@VAA01 AND VAA07=@VAA07 AND VAP01=@VAP01 AND ACF01=@ACF01 AND VCF09 BETWEEN @SDate AND @EDate

order by vcf09