| description:
|
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Retrieved rows from the TRAKiT database and select from LR_PARCEL</SPAN></P><P><SPAN>SELECT</SPAN></P><P><SPAN>CASE WHEN STATUS = ‘SEE PARENT PROJECT’ THEN PARENT_PROJECT_NO</SPAN></P><P><SPAN>ELSE PROJECT_NO</SPAN></P><P><SPAN>END AS PROJECT_NUMBER,</SPAN></P><P><SPAN>[PARENT_PROJECT_NO]</SPAN></P><P><SPAN>,[PROJECT_NO]</SPAN></P><P><SPAN>,[PROJECT_NAME]</SPAN></P><P><SPAN>,[PROJECTTYPE]</SPAN></P><P><SPAN>,[STATUS]</SPAN></P><P><SPAN>,[APPLICANT_NAME]</SPAN></P><P><SPAN>,[SITE_APN]</SPAN></P><P><SPAN>,[SITE_ADDR]</SPAN></P><P><SPAN>,[SITE_CITY]</SPAN></P><P><SPAN>,[SITE_STATE]</SPAN></P><P><SPAN>,[SITE_ZIP]</SPAN></P><P><SPAN>,[APPLIED]</SPAN></P><P><SPAN>,[APPROVED]</SPAN></P><P><SPAN>,[CLOSED]</SPAN></P><P><SPAN>FROM [TRAKIT_prod].[dbo].[PROJECT_MAIN]</SPAN></P><P><SPAN>WHERE STATUS IN (‘COMPLETE’,’ON HOLD',‘PENDING ASSIGNMENT’,’PENDING STATUS LTR', ‘SEE PARENT PROJECT’)</SPAN></P><P><SPAN>AND APPLIED != ‘2012-01-01 00:00:00.000’</SPAN></P></DIV></DIV></DIV> |