-- =============================================
-- Author:
-- Create date: 20161101
-- Description: 取得逾期天數
-- select [dbo].[fn_GetExpireDat](CaseNo),ApplyDat,* from Tbl_Table
-- =============================================
ALTER FUNCTION [dbo].[fn_GetExpireDat]
(
@CaseNo varchar(48)
)
RETURNS int
AS
BEGIN
declare @ExpireDat int
set @ExpireDat = 0
select @ExpireDat = datediff(day,Convert(CHAR(8),Dateadd(D,cast(Para3.ParaDefine as int),ApplyDat),112) , Convert(CHAR(8),getdate(),112) )
FROM Tbl_Table
INNER JOIN Sys_Parameter Para3 on Para3.ParaType = 'Public' and Para3.ParaKind ='Priority' and Para3.ParaValue = Tbl_CaseMain.Priority
WHERE CaseNo =@CaseNo and left(isnull(CaseCurrFlowStepID,''),1) <> 'Z'