--删除旧记录
delete from SYS_Scripts where id=917 --删除脚本内容
GO


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=917)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(917, 50, 'SQL_YjFeeAll', Null, '加载所有病人预交费用', 1, 1, Null, 1, '
select * from (
select
  VBL01, VBL02  ,VBL03  ,VBL04  ,VBL05  ,a.VAA01 ,a.VAA07 ,a.BCK01 ,a.BAQ03 ,BBO02
  ,VBL11 ,VBL12 ,VBL13 ,VBL14 ,VBL15 ,VAK01 ,VBL17 ,VBL18 ,VBL19 ,VBL01A ,a.BCE01
  ,BCE02 ,BCE03 ,VBL24 ,VBL25 ,VBL26,b.VAA05,b.VAA04, b.vaa10, c.ABW02, d.BCK03,
  e.ABJ02 , ISNULL(VBM04,0) VBM04, ISNULL(VBM05,0) VBM05, ISNULL(VBM04,0) - ISNULL(VBM05,0) as yjye ,
  a.PARTS ,g.BCK01c
from V_VBL_FULL a with(nolock)
  JOIN VAA1 b with(nolock) ON a.VAA01 = b.VAA01
  JOIN VAE1 g with(nolock) ON g.VAE01 = a.VAA07 
  LEFT JOIN ABW1 c ON b.ABW01 = c.ABW01
  left JOIN BCK1 d ON a.BCK01 = d.BCK01
  Left JOIN ABJ1 e ON b.ABJ01 = e.ABJ01
  Left JOIN VBM2 f with(nolock) on a.VAA07 = f.VAA07 and f.ACF01 = 2  
where a.VBL04=4 and a.VBL27 =1 ) as g
where 1=1
', '2017-03-23 17:12:00', '(8065)冯义强', 0)
else
print 'SYS_Scripts.id=917 已经存在.'

GO