SELECT JC_JCZBH AS 寄存证编号, JCR_NAME AS 寄存人, WZ_NAME AS 亡者姓名, JC_KSRQ AS 寄存开始日期, dbo.Return_Max_Date(GHJCB_ID) AS 寄存结束日期, YEAR(dbo.Return_Max_Date(GHJCB_ID)) - YEAR(JC_KSRQ) AS 寄存年限, GH_CFLM + GH_CFTSH + GH_CFJG + GH_CFBH AS 寄存位置, JC_JBR AS 经办人, JC_JCZFFRQ AS 寄存证发放日期 into #tmpTable FROM dbo.GHTSH_JCDJB Aselect TOP 100 PERCENT * from #tmpTable order by JC_KSRQ,寄存年限
WZ_NAME AS 亡者姓名, JC_KSRQ AS 寄存开始日期,
dbo.Return_Max_Date(GHJCB_ID) AS 寄存结束日期,
YEAR(dbo.Return_Max_Date(GHJCB_ID)) - YEAR(JC_KSRQ) AS 寄存年限,
GH_CFLM + GH_CFTSH + GH_CFJG + GH_CFBH AS 寄存位置, JC_JBR AS 经办人,
JC_JCZFFRQ AS 寄存证发放日期 into #tmpTable
FROM dbo.GHTSH_JCDJB Aselect TOP 100 PERCENT * from #tmpTable order by JC_KSRQ,寄存年限