聽說幸福…在山的那邊 (浪機子)

-- =============================================
-- 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'

    IF (@ExpireDat < 0 )
    BEGIN
    SET @ExpireDat = 0
 END
  
 RETURN @ExpireDat
END