連續逾期

IF EXISTS(SELECT FROM SYS.TABLES WHERE NAME='SPD') DROP TABLE SPD;
WITH CTE1 AS
(
SELECT
IIF(PD_DueDT>=ISNULL(PD_DebitSuccDT,'9999-12-31'),0,1) AS FLAG/逾期FLAG/,
ROW_NUMBER() OVER(PARTITION BY PD_EFH_SN ORDER BY PD_Termth) AS ID/期次序號/,
MAX(PD_Termth) OVER (PARTITION BY PD_EFH_SN)AS CurrID/當前最大期次序號*/,

為武岡等地區用戶提供了全套網頁設計制作服務，及武岡網站建設行業解決方案。主營業務為成都做網站、網站建設、武岡網站設計，以傳統方式定制建設網站，并提供域名空間備案等一條龍服務，秉承以專業、用心的態度為用戶提供真誠的服務。我們深信只要達到每一位用戶的要求，就會得到認可，從而選擇與我們長期合作。這樣，我們也可以走得更遠！

• FROM PD WHERE PD_DueDT<=GETDATE() AND PD_Termth>0
  ),
  CTE2 AS
  (
  SELECT
  SUM(FLAG) OVER(PARTITION BY PD_EFH_SN ORDER BY PD_Termth ROWS UNBOUNDED PRECEDING) AS AccuFlag/累計逾期期次/,

• FROM CTE1
  ),
  CTE3 AS
  (
  SELECT
  ID-AccuFlag AS FlagGrp/逾期分組/,

• FROM CTE2
  ),
  CTE4 AS
  (
  SELECT
  SUM(FLAG) OVER (PARTITION BY PD_EFH_SN,FlagGrp) AS CountFlag/分組計數/,

• FROM CTE3 WHERE FLAG=1
  ),
  CTE5 AS
  (
  SELECT
  MAX(CountFlag) OVER (PARTITION BY PD_EFH_SN) AS MaxContFlag/最大連續/,
  MAX(AccuFlag) OVER (PARTITION BY PD_EFH_SN) AS TotFlag/歷史累計/,
  IIF(ID=PD_TotTerm,CountFlag,0) AS CurrContFlag/當前累計/,
  ROW_NUMBER() OVER (PARTITION BY PD_EFH_SN ORDER BY PD_Termth DESC) AS CurrTermth,

• FROM CTE4
  )
  SELECT DISTINCT PD_EFH_SN,MaxContFlag,TotFlag,CurrContFlag,'XFY' AS DataSource INTO SPD FROM CTE5 WHERE CurrTermth=1

分享名稱：連續逾期
URL標題：http://m.kartarina.com/article22/pipicc.html

成都網站建設公司_創新互聯，為您提供網站設計公司、外貿網站建設、網站導航、網站改版、網站建設、營銷型網站建設

廣告

聲明：本網站發布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源： 創新互聯