如何根據末次月經的時間 來計算懷孕多少周多少天
例如
DECLARE @dt datetime
SET @dt=GETDATE()
DECLARE @number int
SET @number=3
SELECT tm.YTXM TXM,vx.XM QZ_XM,vx.SFZJHM ZJHM,vx.LXDHHM LXDH,
nx.XM ZF_XM,(SELECT COUNT(YLZD6) FROM TB_CQ_YF_CQTJXX WHERE tj.SJRBH='') as CQJCCS,
sc.SCJGMC SCJG,pg.PGJBMC PGJB,gg.MCYJRQ MCYJ,
gg.TJRQ, DATEADD(Day,@number-(DATEPART(Weekday,@dt)+@@DATEFIRST-1)%7,@dt)JDYZ,
* from TB_UP_JT_JTDADJ jt
left join TB_RYJBXXB nx on jt.JTDAH=nx.JTDAH
left join TB_RYJBXXB vx on jt.JTDAH=vx.JTDAH
LEFT JOIN TB_PU_CQ_GGXX gg on gg.JTDAH=jt.JTDAH
LEFT JOIN TB_PU_YF_TM_TXMXX tm on tm.FNBH=vx.GRDABH
LEFT JOIN TB_CQ_YF_CQTJXX tj on tj.SJRBH=vx.GRDABH
LEFT JOIN TB_CQ_YF_FX_GWSCXX sc on sc.SCRBH=vx.GRDABH
LEFT JOIN TB_CQ_YF_FX_GWPGXX pg on pg.JSPGRBH=vx.GRDABH
left JOIN TB_YF_CS_CSFMJL cs on cs.FNBH=vx.GRDABH
LEFT JOIN TB_YF_JAXX ja on ja.JSZZRBH=vx.GRDABH
where 1=1 AND nx.GRSFBH=1 AND vx.GRSFBH=2 AND vx.BJ=1
uj5u.com熱心網友回復：
DECLARE @dt datetimeSET @dt=GETDATE()
DECLARE @number int
SET @number=3
SELECT tm.YTXM TXM,vx.XM QZ_XM,vx.SFZJHM ZJHM,vx.LXDHHM LXDH,
nx.XM ZF_XM,(SELECT COUNT(YLZD6) FROM TB_CQ_YF_CQTJXX WHERE tj.SJRBH='') as CQJCCS,
sc.SCJGMC SCJG,pg.PGJBMC PGJB,gg.MCYJRQ MCYJ,
gg.TJRQ, DATEADD(Day,@number-(DATEPART(Weekday,@dt)+@@DATEFIRST-1)%7,@dt)JDYZ,
* from TB_UP_JT_JTDADJ jt
left join TB_RYJBXXB nx on jt.JTDAH=nx.JTDAH
left join TB_RYJBXXB vx on jt.JTDAH=vx.JTDAH
LEFT JOIN TB_PU_CQ_GGXX gg on gg.JTDAH=jt.JTDAH
LEFT JOIN TB_PU_YF_TM_TXMXX tm on tm.FNBH=vx.GRDABH
LEFT JOIN TB_CQ_YF_CQTJXX tj on tj.SJRBH=vx.GRDABH
LEFT JOIN TB_CQ_YF_FX_GWSCXX sc on sc.SCRBH=vx.GRDABH
LEFT JOIN TB_CQ_YF_FX_GWPGXX pg on pg.JSPGRBH=vx.GRDABH
left JOIN TB_YF_CS_CSFMJL cs on cs.FNBH=vx.GRDABH
LEFT JOIN TB_YF_JAXX ja on ja.JSZZRBH=vx.GRDABH
where 1=1 AND nx.GRSFBH=1 AND vx.GRSFBH=2 AND vx.BJ=1
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/16124.html
標籤：疑難問題
下一篇：又一個 SQL 句法問題。