SELECT * FROM
(SELECT
ROW_NUMBER() OVER (ORDER BY ALY_ID ASC) AS ROWID,
ISNULL(FCO_ID,0) AS FCO_ID,
ISNULL(FCOCode,'') AS FCOCode,
ISNULL(FCODescription,'') AS FCODescription,
ISNULL(AnalysisCOde,'') AS AnalysisCode,
ISNULL(ALYDesc,'') AS ALYDesc,
ISNULL(ALPType,'') AS ALPType,
ISNULL(ALPMinType,'') AS ALPMinType,
ISNULL(CAST(ALPMinVal AS VARCHAR(5)),'') AS ALPMinVal,
ISNULL(CAST(ALPMaxVal AS VARCHAR(5)),'') AS ALMaxVal,
ISNULL(ALPConform,'') AS ALPConform,
ISNULL(ALPDetect,'') AS ALPDetect,
ISNULL(CAST(RStatus AS VARCHAR(5)),'') AS RStatus,
ISNULL(LMBy,'') AS LMBy
FROM
TempFull) AS T
WHERE
ROWID>=720001
(SELECT
ROW_NUMBER() OVER (ORDER BY ALY_ID ASC) AS ROWID,
ISNULL(FCO_ID,0) AS FCO_ID,
ISNULL(FCOCode,'') AS FCOCode,
ISNULL(FCODescription,'') AS FCODescription,
ISNULL(AnalysisCOde,'') AS AnalysisCode,
ISNULL(ALYDesc,'') AS ALYDesc,
ISNULL(ALPType,'') AS ALPType,
ISNULL(ALPMinType,'') AS ALPMinType,
ISNULL(CAST(ALPMinVal AS VARCHAR(5)),'') AS ALPMinVal,
ISNULL(CAST(ALPMaxVal AS VARCHAR(5)),'') AS ALMaxVal,
ISNULL(ALPConform,'') AS ALPConform,
ISNULL(ALPDetect,'') AS ALPDetect,
ISNULL(CAST(RStatus AS VARCHAR(5)),'') AS RStatus,
ISNULL(LMBy,'') AS LMBy
FROM
TempFull) AS T
WHERE
ROWID>=720001
No comments:
Post a Comment