Page Comparison

SELECT  p.PROJECT_CD, 'true' AS VALID FROM dwhs_ods..ca_project_t p WHERE 
p.proj_active_cd <> 'N' and p.PROJECT_CD in ('<kfsProjectCode>')
;

SELECT p.PROJECT_CD,
p.OBJ_ID,
p.VER_NBR,
p.PROJ_MGR_UNVL_ID,
p.PROJECT_NM,
p.FIN_COA_CD,
p.ORG_CD,
p.PROJ_ACTIVE_CD,
p.PROJECT_DESC
FROM dwhs_ods..ca_project_t p WHERE
p.proj_active_cd <> 'N' and p.PROJECT_CD in ('<kfsProjectCode>')
;