Thursday, March 17, 2011

Checking the condition with the serial number

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

No comments:

Post a Comment