Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

one question about bind variable cause different execution plan

0 views
Skip to first unread message

lsllcm

unread,
Nov 13, 2009, 11:36:54 PM11/13/09
to
Hi Friends,

I have one question about bind variable cause different execution
plan.

When I run the query without bind variable, and hard - coded
parameter, it runs very quickly. After I change the query as below. It
runs very slow. Do you have any idea?

DECLARE @spc varchar(30)
DECLARE @nbr3 varchar(30)
DECLARE @nbr4 varchar(30)
set @spc = 'SACCO'
set @nbr3 = '101007363'
set @nbr4 = '101007363%'

DECLARE @SQLString nvarchar(4000);
DECLARE @ParmDefinition nvarchar(500);


set @SQLString = N'SELECT TOP 101 A.SERV_PROV_CODE AS
SERV_PROV_CODE, ' +
'A.B1_PER_ID1 AS B1_PER_ID1,' +
'A.B1_PER_ID2 AS B1_PER_ID2,' +
'A.B1_PER_ID3 AS B1_PER_ID3,' +
'A.B1_PER_GROUP, ' +
'A.B1_PER_TYPE, ' +
'A.B1_PER_SUB_TYPE, ' +
'A.B1_PER_CATEGORY, ' +
'A.B1_SPECIAL_TEXT, ' +
'A.B1_CREATED_BY_ACA,' +
'A.R3_STD_TIME_CLASS_CODE, ' +
'A.B1_STANDARD_TIME, ' +
'A.B1_EVENT_CODE,' +
'A.B1_REF_ID, ' +
'A.B1_APPL_STATUS,' +
'A.REC_FUL_NAM, ' +
'A.REC_STATUS,' +
'A.PROJECT_NBR, ' +
'A.B1_ALT_ID, ' +
'A.B1_TRACKING_NBR, ' +
'A.B1_APPL_STATUS_DATE,' +
'A.B1_REF_ID1,' +
'A.B1_REF_ID2,' +
'A.B1_REF_ID3,' +
'A.B1_Q_UD1, ' +
'A.B1_Q_UD2, ' +
'A.B1_Q_UD3, ' +
'A.B1_Q_UD4, ' +
'A.APP_STATUS_GROUP_CODE, ' +
'A.B1_MODULE_NAME,' +
'A.B1_FILE_DD,' +
'A.REC_DATE, ' +
'A.B1_REPORTED_DATE, ' +
'A.B1_APPL_CLASS,' +
'A.B1_APP_TYPE_ALIAS,' +
'A.B1_CREATED_BY,' +
'A.B1_INITIATED_BY_PRODUCT,' +
'B.APP_STATUS,' +
'B.APP_STATUS_DATE, ' +
'B.DISPOSITION, ' +
'B.DISPOSITION_DATE, ' +
'B.TOTAL_FEE, ' +
'B.TOTAL_PAY, ' +
'B.PERCENT_COMPLETE, ' +
'B.BALANCE, ' +
'B.BALANCE_DATE, ' +
'B.HOUSE_COUNT, ' +
'B.BUILDING_COUNT,' +
'B.PUBLIC_OWNED, ' +
'B.CONST_TYPE_CODE, ' +
'B.ACTION, ' +
'B.GA_AGENCY_CODE,' +
'B.GA_BUREAU_CODE,' +
'B.GA_DIVISION_CODE, ' +
'B.GA_OFFICE_CODE,' +
'B.GA_SECTION_CODE, ' +
'B.GA_GROUP_CODE,' +
'B.GA_FNAME, ' +
'B.GA_MNAME, ' +
'B.GA_LNAME, ' +
'B.B1_APPL_SUB_STATUS, ' +
'B.B1_SHORT_NOTES,' +
'B.B1_CLOSED_DATE,' +
'B.B1_CLOSEDBY, ' +
'B.B1_REPORTED_CHANNEL,' +
'B.B1_ASGN_DEPT, ' +
'B.B1_ASGN_STAFF,' +
'B.B1_PRIORITY, ' +
'B.B1_SEVERITY, ' +
'B.B1_ASGN_DATE, ' +
'B.TOTAL_JOB_COST,' +
'B.B1_CLOSED_DEPT,' +
'B.B1_COMPLETE_BY,' +
'B.B1_COMPLETE_DEPT, ' +
'B.B1_COMPLETE_DATE, ' +
'B.B1_SCHEDULED_DATE,' +
'B.B1_CREATOR_DEPT, ' +
'B.PM_SCHEDULE_SEQ, ' +
'B.B1_EST_PROD_UNITS,' +
'B.B1_ACTUAL_PROD_UNITS,' +
'B.B1_EST_COST_PER_UNIT,' +
'B.B1_COST_PER_UNIT, ' +
'B.B1_EST_JOB_COST, ' +
'B.B1_PROD_UNIT_TYPE,' +
'B.B1_CREATED_BY AS B1CREATEDBY, ' +
'B.B1_TRACK_START_DATE,' +
'B.B1_ESTIMATED_DUE_DATE, ' +
'B.B1_IN_POSSESSION_TIME, ' +
'B.C6_ANONYMOUS_FLAG,' +
'B.C6_REFERENCE_TYPE,' +
'B.C6_APPEARANCE_DAYOFWEEK,' +
'B.C6_APPEARANCE_DD, ' +
'B.C6_BOOKING_FLAG, ' +
'B.C6_DFNDT_SIGNATURE_FLAG,' +
'B.C6_ENFORCE_OFFICER_ID, ' +
'B.C6_ENFORCE_OFFICER_NAME,' +
'B.C6_INFRACTION_FLAG, ' +
'B.C6_INSPECTOR_ID, ' +
'B.C6_MISDEMEANOR_FLAG,' +
'B.C6_OFFN_WITNESSED_FLAG, ' +
'B.C6_INSPECTOR_NAME,' +
'B.C6_ENFORCE_DEPT, ' +
'B.C6_INSPECTOR_DEPT,' +
'B.APP_STATUS_REASON,' +
'B.FIRST_ISSUED_DATE,' +
'B.UNDISTRIBUTED_JOB_COST, ' +
'B.B1_VAL_MULTIPLIER,' +
'B.B1_VAL_EXTRA_AMT, ' +
'G.EXPIRATION_CODE, ' +
'G.EXPIRATION_STATUS,' +
'G.EXPIRATION_DATE, ' +
'G.EXPIRATION_INTERVAL,' +
'G.EXPIRATION_INTERVAL_UNITS, ' +
'G.GRACE_PERIOD_INTERVAL, ' +
'G.GRACE_PERIOD_INTERVAL_UNITS,' +
'G.PENALTY_INTERVAL, ' +
'G.PENALTY_INTERVAL_UNITS, ' +
'G.NUM_PENALTY_PERIODS,' +
'G.PENALTY_PERIOD,' +
'G.RENEWAL_FEE_FUNCTION,' +
'G.RENEWAL_FEE_CODE, ' +
'G.PENALTY_FEE_FUNCTION,' +
'G.PENALTY_FEE_CODE, ' +
'G.PAY_PERIOD_GROUP, ' +
'G.UDF1, ' +
'G.UDF2, ' +
'G.UDF3, ' +
'G.UDF4, ' +
'C.B1_WORK_DESC ' +
' FROM B1PERMIT A ' +
' LEFT OUTER JOIN BPERMIT_DETAIL B ON A.SERV_PROV_CODE =
B.SERV_PROV_CODE' +
' AND A.B1_PER_ID1 = B.B1_PER_ID1 ' +
' AND A.B1_PER_ID2 = B.B1_PER_ID2 ' +
' AND A.B1_PER_ID3 = B.B1_PER_ID3 ' +
' LEFT OUTER JOIN BWORKDES C ON A.SERV_PROV_CODE = C.SERV_PROV_CODE '
+
' AND A.B1_PER_ID1 = C.B1_PER_ID1' +
' AND A.B1_PER_ID2 = C.B1_PER_ID2' +
' AND A.B1_PER_ID3 = C.B1_PER_ID3' +
' LEFT OUTER JOIN B1_EXPIRATION G ON A.SERV_PROV_CODE =
G.SERV_PROV_CODE' +
' AND A.B1_PER_ID1 = G.B1_PER_ID1 ' +
' AND A.B1_PER_ID2 = G.B1_PER_ID2 ' +
' AND A.B1_PER_ID3 = G.B1_PER_ID3, ' +
' F4PAYMENT PA, F4RECEIPT RE ' +
' WHERE A.REC_STATUS = ''A'' ' +
' AND A.B1_PER_ID3 NOT LIKE ''#%'' ' +
' AND PA.SERV_PROV_CODE = RE.SERV_PROV_CODE' +
' AND PA.RECEIPT_NBR = RE.RECEIPT_NBR' +
' AND A.SERV_PROV_CODE = PA.SERV_PROV_CODE ' +
' AND A.B1_PER_ID1 = PA.B1_PER_ID1' +
' AND A.B1_PER_ID2 = PA.B1_PER_ID2' +
' AND A.B1_PER_ID3 = PA.B1_PER_ID3' +
' AND ((RE.SERV_PROV_CODE = @spc1 AND RE.RECEIPT_NBR = @nbr1 ) OR '
+
' (RE.SERV_PROV_CODE = @spc2 AND RE.RECEIPT_CUSTOMIZED_NBR LIKE
@nbr2 )) ' +
' ORDER BY A.B1_FILE_DD DESC ';

SET @ParmDefinition = N'@spc1 varchar(30), @nbr1 varchar(30), @spc2
varchar(30), @nbr2 varchar(30) ';
EXECUTE sp_executesql @SQLString, @ParmDefinition,
@spc1 = @spc
, @nbr1 = @nbr3
, @spc2 = @spc
, @nbr2 = @nbr4
;

lsllcm

unread,
Nov 13, 2009, 11:39:37 PM11/13/09
to
The execution plan is as below: You can click more at left bottom link
to see whole message.

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/
showplan" Version="1.0" Build="9.00.4035.00">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementText="(@spc1 varchar(30), @nbr1 varchar
(30), @spc2 varchar(30), @nbr2 varchar(30) )SELECT TOP 101
A.SERV_PROV_CODE AS SERV_PROV_CODE, A.B1_PER_ID1
AS B1_PER_ID1,A.B1_PER_ID2 AS B1_PER_ID2,A.B1_PER_ID3 AS
B1_PER_ID3,A.B1_PER_GROUP, A.B1_PER_TYPE, A.B1_PER_SUB_TYPE,
A.B1_PER_CATEGORY, A.B1_SPECIAL_TEXT,
A.B1_CREATED_BY_ACA,A.R3_STD_TIME_CLASS_CODE, A.B1_STANDARD_TIME,
A.B1_EVENT_CODE,A.B1_REF_ID, A.B1_APPL_STATUS,A.REC_FUL_NAM,
A.REC_STATUS,A.PROJECT_NBR, A.B1_ALT_ID, A.B1_TRACKING_NBR,
A.B1_APPL_STATUS_DATE,A.B1_REF_ID1,A.B1_REF_ID2,A.B1_REF_ID3,A.B1_Q_UD1,
A.B1_Q_UD2, A.B1_Q_UD3, A.B1_Q_UD4, A.APP_STATUS_GROUP_CODE,
A.B1_MODULE_NAME,A.B1_FILE_DD,A.REC_DATE, A.B1_REPORTED_DATE,
A.B1_APPL_CLASS,A.B1_APP_TYPE_ALIAS,A.B1_CREATED_BY,A.B1_INITIATED_BY_PRODUCT,B.APP_STATUS,B.APP_STATUS_DATE,
B.DISPOSITION, B.DISPOSITION_DATE, B.TOTAL_FEE, B.TOTAL_PAY,
B.PERCENT_COMPLETE, B.BALANCE, B.BALANCE_DATE, B.HOUSE_COUNT,
B.BUILDING_COUNT,B.PUBLIC_OWNED, B.CONST_TYPE_CODE, B.ACTION,
B.GA_AGENCY_CODE,B.GA_BUREAU_CODE,B.GA_DIVISION_CODE,
B.GA_OFFICE_CODE,B.GA_SECTION_CODE, B.GA_GROUP_CODE,B.GA_FNAME,
B.GA_MNAME, B.GA_LNAME, B.B1_APPL_SUB_STATUS,
B.B1_SHORT_NOTES,B.B1_CLOSED_DATE,B.B1_CLOSEDBY,
B.B1_REPORTED_CHANNEL,B.B1_ASGN_DEPT, B.B1_ASGN_STAFF,B.B1_PRIORITY,
B.B1_SEVERITY, B.B1_ASGN_DATE,
B.TOTAL_JOB_COST,B.B1_CLOSED_DEPT,B.B1_COMPLETE_BY,B.B1_COMPLETE_DEPT,
B.B1_COMPLETE_DATE, B.B1_SCHEDULED_DATE,B.B1_CREATOR_DEPT,
B.PM_SCHEDULE_SEQ,
B.B1_EST_PROD_UNITS,B.B1_ACTUAL_PROD_UNITS,B.B1_EST_COST_PER_UNIT,B.B1_COST_PER_UNIT,
B.B1_EST_JOB_COST, B.B1_PROD_UNIT_TYPE,B.B1_CREATED_BY AS
B1CREATEDBY,
B.B1_TRACK_START_DATE,B.B1_ESTIMATED_DUE_DATE,
B.B1_IN_POSSESSION_TIME,
B.C6_ANONYMOUS_FLAG,B.C6_REFERENCE_TYPE,B.C6_APPEARANCE_DAYOFWEEK,B.C6_APPEARANCE_DD,
B.C6_BOOKING_FLAG,
B.C6_DFNDT_SIGNATURE_FLAG,B.C6_ENFORCE_OFFICER_ID,
B.C6_ENFORCE_OFFICER_NAME,B.C6_INFRACTION_FLAG, B.C6_INSPECTOR_ID,
B.C6_MISDEMEANOR_FLAG,B.C6_OFFN_WITNESSED_FLAG,
B.C6_INSPECTOR_NAME,B.C6_ENFORCE_DEPT,
B.C6_INSPECTOR_DEPT,B.APP_STATUS_REASON,B.FIRST_ISSUED_DATE,B.UNDISTRIBUTED_JOB_COST,
B.B1_VAL_MULTIPLIER,B.B1_VAL_EXTRA_AMT, G.EXPIRATION_CODE,
G.EXPIRATION_STATUS,G.EXPIRATION_DATE,
G.EXPIRATION_INTERVAL,G.EXPIRATION_INTERVAL_UNITS,
G.GRACE_PERIOD_INTERVAL,
G.GRACE_PERIOD_INTERVAL_UNITS,G.PENALTY_INTERVAL,
G.PENALTY_INTERVAL_UNITS,
G.NUM_PENALTY_PERIODS,G.PENALTY_PERIOD,G.RENEWAL_FEE_FUNCTION,G.RENEWAL_FEE_CODE,
G.PENALTY_FEE_FUNCTION,G.PENALTY_FEE_CODE, G.PAY_PERIOD_GROUP,
G.UDF1, G.UDF2, G.UDF3, G.UDF4, C.B1_WORK_DESC
FROM B1PERMIT A LEFT OUTER JOIN BPERMIT_DETAIL B ON
A.SERV_PROV_CODE = B.SERV_PROV_CODE
AND A.B1_PER_ID1 = B.B1_PER_ID1 AND
A.B1_PER_ID2 = B.B1_PER_ID2 AND
A.B1_PER_ID3 = B.B1_PER_ID3 LEFT OUTER JOIN BWORKDES C ON
A.SERV_PROV_CODE = C.SERV_PROV_CODE AND
A.B1_PER_ID1 = C.B1_PER_ID1 AND
A.B1_PER_ID2 = C.B1_PER_ID2 AND
A.B1_PER_ID3 = C.B1_PER_ID3 LEFT OUTER JOIN B1_EXPIRATION G ON
A.SERV_PROV_CODE = G.SERV_PROV_CODE
AND A.B1_PER_ID1 = G.B1_PER_ID1 AND
A.B1_PER_ID2 = G.B1_PER_ID2 AND
A.B1_PER_ID3 = G.B1_PER_ID3, F4PAYMENT PA, F4RECEIPT RE WHERE
A.REC_STATUS = 'A' AND A.B1_PER_ID3 NOT LIKE '#%' AND
PA.SERV_PROV_CODE = RE.SERV_PROV_CODE AND PA.RECEIPT_NBR =
RE.RECEIPT_NBR AND A.SERV_PROV_CODE = PA.SERV_PROV_CODE AND
A.B1_PER_ID1 = PA.B1_PER_ID1 AND A.B1_PER_ID2 = PA.B1_PER_ID2 AND
A.B1_PER_ID3 = PA.B1_PER_ID3 AND ((RE.SERV_PROV_CODE = @spc1 AND
RE.RECEIPT_NBR = @nbr1 ) OR (RE.SERV_PROV_CODE = @spc2 AND
RE.RECEIPT_CUSTOMIZED_NBR LIKE @nbr2 )) ORDER BY A.B1_FILE_DD DESC "
StatementId="1" StatementCompId="7" StatementType="SELECT"
StatementSubTreeCost="2.48419" StatementEstRows="101"
StatementOptmLevel="FULL">
<QueryPlan CachedPlanSize="254" CompileTime="998"
CompileCPU="156" CompileMemory="2176">
<RelOp NodeId="0" PhysicalOp="Top" LogicalOp="Top"
EstimateRows="101" EstimateIO="0" EstimateCPU="1.01e-005"
AvgRowSize="3909" EstimatedTotalSubtreeCost="2.48419" Parallel="0"
EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="SERV_PROV_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID1" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID2" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID3" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID1" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID2" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID3" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_GROUP" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_TYPE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_SUB_TYPE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_CATEGORY" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="R3_STD_TIME_CLASS_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_FILE_DD" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_SPECIAL_TEXT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD1" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD2" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD3" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD4" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_STANDARD_TIME" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_EVENT_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_CREATED_BY_ACA" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_REPORTED_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="REC_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="REC_FUL_NAM" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="REC_STATUS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="PROJECT_NBR" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_ALT_ID" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_TRACKING_NBR" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_APPL_STATUS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="APP_STATUS_GROUP_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_APPL_STATUS_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_MODULE_NAME" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_APPL_CLASS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_APP_TYPE_ALIAS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_CREATED_BY" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_INITIATED_BY_PRODUCT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_CREATOR_DEPT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="APP_STATUS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="DISPOSITION" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="BALANCE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="APP_STATUS_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="DISPOSITION_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="BALANCE_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="PM_SCHEDULE_SEQ" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="HOUSE_COUNT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="BUILDING_COUNT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="PUBLIC_OWNED" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="CONST_TYPE_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="ACTION" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_AGENCY_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_BUREAU_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_DIVISION_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_OFFICE_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_SECTION_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_GROUP_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_FNAME" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_MNAME" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_LNAME" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="TOTAL_FEE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="TOTAL_PAY" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_APPL_SUB_STATUS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_SHORT_NOTES" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_CLOSED_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_CLOSEDBY" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_REPORTED_CHANNEL" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_ASGN_DEPT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_ASGN_STAFF" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_PRIORITY" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_SEVERITY" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_ASGN_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="TOTAL_JOB_COST" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_CLOSED_DEPT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_COMPLETE_BY" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_COMPLETE_DEPT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_COMPLETE_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_SCHEDULED_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="PERCENT_COMPLETE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_CREATED_BY" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_TRACK_START_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_ESTIMATED_DUE_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_IN_POSSESSION_TIME" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_EST_PROD_UNITS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_ACTUAL_PROD_UNITS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_EST_COST_PER_UNIT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_COST_PER_UNIT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_EST_JOB_COST" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_PROD_UNIT_TYPE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_ANONYMOUS_FLAG" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_REFERENCE_TYPE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_APPEARANCE_DAYOFWEEK" /
>
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_APPEARANCE_DD" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_BOOKING_FLAG" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_DFNDT_SIGNATURE_FLAG" /
>
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_ENFORCE_OFFICER_ID" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_ENFORCE_OFFICER_NAME" /
>
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_INFRACTION_FLAG" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_INSPECTOR_ID" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_MISDEMEANOR_FLAG" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_OFFN_WITNESSED_FLAG" /
>
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_INSPECTOR_NAME" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_ENFORCE_DEPT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="C6_INSPECTOR_DEPT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="APP_STATUS_REASON" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="FIRST_ISSUED_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="UNDISTRIBUTED_JOB_COST" /
>
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_VAL_MULTIPLIER" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BPERMIT_DETAIL]" Alias="[B]" Column="B1_VAL_EXTRA_AMT" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[BWORKDES]" Alias="[C]" Column="B1_WORK_DESC" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="EXPIRATION_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="RENEWAL_FEE_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="PENALTY_FEE_CODE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="EXPIRATION_STATUS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="EXPIRATION_DATE" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="EXPIRATION_INTERVAL" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_INTERVAL_UNITS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="GRACE_PERIOD_INTERVAL" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]"
Column="GRACE_PERIOD_INTERVAL_UNITS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="PENALTY_INTERVAL" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="PENALTY_INTERVAL_UNITS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="NUM_PENALTY_PERIODS" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="RENEWAL_FEE_FUNCTION" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="PENALTY_FEE_FUNCTION" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="PENALTY_PERIOD" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF1" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF2" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF3" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF4" />
<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Alias="[G]" Column="PAY_PERIOD_GROUP" />
</OutputList>
<Top RowCount="0" IsPercent="0" WithTies="0">
<TopExpression>
<ScalarOperator ScalarString="(101)">
<Const ConstValue="(101)" />
</ScalarOperator>
</TopExpression>
<RelOp NodeId="1" PhysicalOp="Nested Loops"
LogicalOp="Left Outer Join" EstimateRows="101" EstimateIO="0"
EstimateCPU="1.50975" AvgRowSize="3909"
EstimatedTotalSubtreeCost="2.48418" Parallel="0" EstimateRebinds="0"
EstimateRewinds="0">
<OutputList>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="SERV_PROV_CODE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_GROUP" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_SUB_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_CATEGORY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="R3_STD_TIME_CLASS_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_FILE_DD" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_SPECIAL_TEXT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD4" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_STANDARD_TIME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_EVENT_CODE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY_ACA" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REPORTED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_FUL_NAM" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_STATUS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="PROJECT_NBR" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_ALT_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_TRACKING_NBR" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_APPL_STATUS" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="APP_STATUS_GROUP_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_MODULE_NAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_APPL_CLASS" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APP_TYPE_ALIAS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_CREATED_BY" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_INITIATED_BY_PRODUCT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CREATOR_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="APP_STATUS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="DISPOSITION" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="BALANCE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="APP_STATUS_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="DISPOSITION_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="BALANCE_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="PM_SCHEDULE_SEQ" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="HOUSE_COUNT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="BUILDING_COUNT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="PUBLIC_OWNED" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="CONST_TYPE_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="ACTION" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_AGENCY_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_BUREAU_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_DIVISION_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_OFFICE_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_SECTION_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_GROUP_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_FNAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_MNAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_LNAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="TOTAL_FEE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="TOTAL_PAY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_APPL_SUB_STATUS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_SHORT_NOTES" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CLOSED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CLOSEDBY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_REPORTED_CHANNEL" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ASGN_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ASGN_STAFF" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_PRIORITY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_SEVERITY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ASGN_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="TOTAL_JOB_COST" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CLOSED_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COMPLETE_BY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COMPLETE_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COMPLETE_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_SCHEDULED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="PERCENT_COMPLETE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CREATED_BY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_TRACK_START_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ESTIMATED_DUE_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_IN_POSSESSION_TIME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_EST_PROD_UNITS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ACTUAL_PROD_UNITS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_EST_COST_PER_UNIT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COST_PER_UNIT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_EST_JOB_COST" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_PROD_UNIT_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ANONYMOUS_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_REFERENCE_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_APPEARANCE_DAYOFWEEK" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_APPEARANCE_DD" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_BOOKING_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_DFNDT_SIGNATURE_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ENFORCE_OFFICER_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ENFORCE_OFFICER_NAME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INFRACTION_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INSPECTOR_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_MISDEMEANOR_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_OFFN_WITNESSED_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INSPECTOR_NAME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ENFORCE_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INSPECTOR_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="APP_STATUS_REASON" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="FIRST_ISSUED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="UNDISTRIBUTED_JOB_COST" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_VAL_MULTIPLIER" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_VAL_EXTRA_AMT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BWORKDES]" Alias="[C]" Column="B1_WORK_DESC" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="RENEWAL_FEE_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_FEE_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_STATUS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_INTERVAL" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_INTERVAL_UNITS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="GRACE_PERIOD_INTERVAL" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="GRACE_PERIOD_INTERVAL_UNITS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_INTERVAL" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_INTERVAL_UNITS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="NUM_PENALTY_PERIODS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="RENEWAL_FEE_FUNCTION" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_FEE_FUNCTION" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_PERIOD" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF4" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PAY_PERIOD_GROUP" />
</OutputList>
<NestedLoops Optimized="0" WithOrderedPrefetch="1">
<OuterReferences>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="SERV_PROV_CODE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID3" />
<ColumnReference Column="Expr1023" />
</OuterReferences>
<RelOp NodeId="3" PhysicalOp="Nested Loops"
LogicalOp="Left Outer Join" EstimateRows="101" EstimateIO="0"
EstimateCPU="1.50975" AvgRowSize="3699"
EstimatedTotalSubtreeCost="2.32218" Parallel="0" EstimateRebinds="0"
EstimateRewinds="0">
<OutputList>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="SERV_PROV_CODE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_GROUP" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_SUB_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_CATEGORY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="R3_STD_TIME_CLASS_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_FILE_DD" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_SPECIAL_TEXT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD4" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_STANDARD_TIME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_EVENT_CODE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY_ACA" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REPORTED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_FUL_NAM" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_STATUS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="PROJECT_NBR" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_ALT_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_TRACKING_NBR" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_APPL_STATUS" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="APP_STATUS_GROUP_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_MODULE_NAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_APPL_CLASS" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APP_TYPE_ALIAS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_CREATED_BY" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_INITIATED_BY_PRODUCT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CREATOR_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="APP_STATUS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="DISPOSITION" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="BALANCE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="APP_STATUS_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="DISPOSITION_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="BALANCE_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="PM_SCHEDULE_SEQ" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="HOUSE_COUNT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="BUILDING_COUNT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="PUBLIC_OWNED" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="CONST_TYPE_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="ACTION" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_AGENCY_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_BUREAU_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_DIVISION_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_OFFICE_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_SECTION_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_GROUP_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_FNAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_MNAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_LNAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="TOTAL_FEE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="TOTAL_PAY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_APPL_SUB_STATUS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_SHORT_NOTES" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CLOSED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CLOSEDBY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_REPORTED_CHANNEL" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ASGN_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ASGN_STAFF" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_PRIORITY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_SEVERITY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ASGN_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="TOTAL_JOB_COST" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CLOSED_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COMPLETE_BY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COMPLETE_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COMPLETE_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_SCHEDULED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="PERCENT_COMPLETE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CREATED_BY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_TRACK_START_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ESTIMATED_DUE_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_IN_POSSESSION_TIME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_EST_PROD_UNITS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ACTUAL_PROD_UNITS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_EST_COST_PER_UNIT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COST_PER_UNIT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_EST_JOB_COST" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_PROD_UNIT_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ANONYMOUS_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_REFERENCE_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_APPEARANCE_DAYOFWEEK" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_APPEARANCE_DD" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_BOOKING_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_DFNDT_SIGNATURE_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ENFORCE_OFFICER_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ENFORCE_OFFICER_NAME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INFRACTION_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INSPECTOR_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_MISDEMEANOR_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_OFFN_WITNESSED_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INSPECTOR_NAME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ENFORCE_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INSPECTOR_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="APP_STATUS_REASON" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="FIRST_ISSUED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="UNDISTRIBUTED_JOB_COST" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_VAL_MULTIPLIER" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_VAL_EXTRA_AMT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BWORKDES]" Alias="[C]" Column="B1_WORK_DESC" />
</OutputList>
<NestedLoops Optimized="0"
WithOrderedPrefetch="1">
<OuterReferences>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="SERV_PROV_CODE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID3" />
<ColumnReference Column="Expr1022" />
</OuterReferences>
<RelOp NodeId="5" PhysicalOp="Nested Loops"
LogicalOp="Left Outer Join" EstimateRows="101" EstimateIO="0"
EstimateCPU="1.50975" AvgRowSize="1697"
EstimatedTotalSubtreeCost="1.98865" Parallel="0" EstimateRebinds="0"
EstimateRewinds="0">
<OutputList>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="SERV_PROV_CODE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_GROUP" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_SUB_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_CATEGORY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="R3_STD_TIME_CLASS_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_FILE_DD" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_SPECIAL_TEXT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD4" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_STANDARD_TIME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_EVENT_CODE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY_ACA" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REPORTED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_FUL_NAM" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_STATUS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="PROJECT_NBR" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_ALT_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_TRACKING_NBR" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_APPL_STATUS" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="APP_STATUS_GROUP_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_MODULE_NAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_APPL_CLASS" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APP_TYPE_ALIAS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_CREATED_BY" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_INITIATED_BY_PRODUCT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CREATOR_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="APP_STATUS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="DISPOSITION" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="BALANCE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="APP_STATUS_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="DISPOSITION_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="BALANCE_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="PM_SCHEDULE_SEQ" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="HOUSE_COUNT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="BUILDING_COUNT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="PUBLIC_OWNED" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="CONST_TYPE_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="ACTION" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_AGENCY_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_BUREAU_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_DIVISION_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_OFFICE_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_SECTION_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="GA_GROUP_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_FNAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_MNAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]" Column="GA_LNAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="TOTAL_FEE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="TOTAL_PAY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_APPL_SUB_STATUS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_SHORT_NOTES" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CLOSED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CLOSEDBY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_REPORTED_CHANNEL" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ASGN_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ASGN_STAFF" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_PRIORITY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_SEVERITY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ASGN_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="TOTAL_JOB_COST" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CLOSED_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COMPLETE_BY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COMPLETE_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COMPLETE_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_SCHEDULED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="PERCENT_COMPLETE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_CREATED_BY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_TRACK_START_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ESTIMATED_DUE_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_IN_POSSESSION_TIME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_EST_PROD_UNITS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_ACTUAL_PROD_UNITS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_EST_COST_PER_UNIT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_COST_PER_UNIT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_EST_JOB_COST" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_PROD_UNIT_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ANONYMOUS_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_REFERENCE_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_APPEARANCE_DAYOFWEEK" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_APPEARANCE_DD" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_BOOKING_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_DFNDT_SIGNATURE_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ENFORCE_OFFICER_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ENFORCE_OFFICER_NAME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INFRACTION_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INSPECTOR_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_MISDEMEANOR_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_OFFN_WITNESSED_FLAG" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INSPECTOR_NAME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_ENFORCE_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="C6_INSPECTOR_DEPT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="APP_STATUS_REASON" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="FIRST_ISSUED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="UNDISTRIBUTED_JOB_COST" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_VAL_MULTIPLIER" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Alias="[B]"
Column="B1_VAL_EXTRA_AMT" />
</OutputList>
<NestedLoops Optimized="0"
WithOrderedPrefetch="1">
<OuterReferences>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="SERV_PROV_CODE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID3" />
<ColumnReference Column="Expr1021" />
</OuterReferences>
<RelOp NodeId="7" PhysicalOp="Nested
Loops" LogicalOp="Inner Join" EstimateRows="101" EstimateIO="0"
EstimateCPU="14.6953" AvgRowSize="588"
EstimatedTotalSubtreeCost="1.65384" Parallel="0" EstimateRebinds="0"
EstimateRewinds="0">
<OutputList>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="SERV_PROV_CODE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_GROUP" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_SUB_TYPE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_CATEGORY" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="R3_STD_TIME_CLASS_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_FILE_DD" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_SPECIAL_TEXT" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD3" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_Q_UD4" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_STANDARD_TIME" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_EVENT_CODE" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY_ACA" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REPORTED_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_FUL_NAM" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="REC_STATUS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="PROJECT_NBR" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_REF_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_ALT_ID" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_TRACKING_NBR" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_APPL_STATUS" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="APP_STATUS_GROUP_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS_DATE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_MODULE_NAME" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_APPL_CLASS" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APP_TYPE_ALIAS" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]" Column="B1_CREATED_BY" /
>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_INITIATED_BY_PRODUCT" />
</OutputList>
<NestedLoops Optimized="0">
<Predicate>
<ScalarOperator
ScalarString="[sacco70].[dbo].[F4PAYMENT].[SERV_PROV_CODE] as [PA].
[SERV_PROV_CODE]=[sacco70].[dbo].[F4RECEIPT].[SERV_PROV_CODE] as [RE].
[SERV_PROV_CODE] AND [sacco70].[dbo].[F4PAYMENT].[RECEIPT_NBR] as [PA].
[RECEIPT_NBR]=[sacco70].[dbo].[F4RECEIPT].[RECEIPT_NBR] as [RE].
[RECEIPT_NBR]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="SERV_PROV_CODE" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="RECEIPT_NBR" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
<RelOp NodeId="8" PhysicalOp="Nested
Loops" LogicalOp="Inner Join" EstimateRows="101" EstimateIO="0"
EstimateCPU="3.6479" AvgRowSize="604"
EstimatedTotalSubtreeCost="1.61079" Parallel="0" EstimateRebinds="0"
EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_GROUP" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_TYPE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_SUB_TYPE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_CATEGORY" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="R3_STD_TIME_CLASS_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_FILE_DD" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_SPECIAL_TEXT" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD4" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_STANDARD_TIME" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_EVENT_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY_ACA" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REPORTED_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_FUL_NAM" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_STATUS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="PROJECT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_ALT_ID" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_TRACKING_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="APP_STATUS_GROUP_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_MODULE_NAME" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_CLASS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APP_TYPE_ALIAS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_INITIATED_BY_PRODUCT" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="RECEIPT_NBR" />
</OutputList>
<NestedLoops Optimized="0"
WithOrderedPrefetch="1">
<OuterReferences>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID3" />
<ColumnReference
Column="Expr1017" />
</OuterReferences>
<RelOp NodeId="10"
PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="244.039"
EstimateIO="0" EstimateCPU="1.2131" AvgRowSize="588"
EstimatedTotalSubtreeCost="0.813748" Parallel="0" EstimateRebinds="0"
EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_GROUP" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_TYPE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_SUB_TYPE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_CATEGORY" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="R3_STD_TIME_CLASS_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_FILE_DD" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_SPECIAL_TEXT" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD4" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_STANDARD_TIME" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_EVENT_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY_ACA" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REPORTED_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_FUL_NAM" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_STATUS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="PROJECT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_ALT_ID" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_TRACKING_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="APP_STATUS_GROUP_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_MODULE_NAME" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_CLASS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APP_TYPE_ALIAS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_INITIATED_BY_PRODUCT" />
</OutputList>
<Filter StartupExpression="0">
<RelOp NodeId="11"
PhysicalOp="Nested Loops" LogicalOp="Inner Join"
EstimateRows="245.816" EstimateIO="0" EstimateCPU="3.67447"
AvgRowSize="588" EstimatedTotalSubtreeCost="0.813409" Parallel="0"
EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_GROUP" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_TYPE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_SUB_TYPE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_CATEGORY" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="R3_STD_TIME_CLASS_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_FILE_DD" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_SPECIAL_TEXT" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD4" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_STANDARD_TIME" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_EVENT_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY_ACA" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REPORTED_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_FUL_NAM" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_STATUS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="PROJECT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_ALT_ID" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_TRACKING_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="APP_STATUS_GROUP_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_MODULE_NAME" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_CLASS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APP_TYPE_ALIAS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_INITIATED_BY_PRODUCT" />
</OutputList>
<NestedLoops Optimized="0"
WithOrderedPrefetch="1">
<OuterReferences>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID3" />
<ColumnReference
Column="Expr1016" />
</OuterReferences>
<RelOp NodeId="13"
PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="245.816"
EstimateIO="6.52312" EstimateCPU="0.967122" AvgRowSize="96"
EstimatedTotalSubtreeCost="0.00536821" Parallel="0"
EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_FILE_DD" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_MODULE_NAME" />
</OutputList>
<IndexScan Ordered="1"
ScanDirection="BACKWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="SERV_PROV_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID1" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID2" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID3" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_FILE_DD" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_MODULE_NAME" />
</DefinedValue>
</DefinedValues>
<Object
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]"
Index="[B1PERMIT_FILEDD_IX]" Alias="[A]" />
</IndexScan>
</RelOp>
<RelOp NodeId="15"
PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek"
EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581"
AvgRowSize="606" EstimatedTotalSubtreeCost="0.807013" Parallel="0"
EstimateRebinds="245.816" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_GROUP" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_TYPE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_SUB_TYPE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_CATEGORY" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="R3_STD_TIME_CLASS_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_SPECIAL_TEXT" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD3" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD4" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_STANDARD_TIME" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_EVENT_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY_ACA" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REPORTED_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_FUL_NAM" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_STATUS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="PROJECT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_ALT_ID" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_TRACKING_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="APP_STATUS_GROUP_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS_DATE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_CLASS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APP_TYPE_ALIAS" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_INITIATED_BY_PRODUCT" />
</OutputList>
<IndexScan Lookup="1"
Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID1" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID2" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID3" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_GROUP" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_TYPE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_SUB_TYPE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_CATEGORY" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="R3_STD_TIME_CLASS_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_SPECIAL_TEXT" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD1" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD2" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD3" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_Q_UD4" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_STANDARD_TIME" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_EVENT_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY_ACA" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REPORTED_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_FUL_NAM" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_STATUS" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="PROJECT_NBR" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_REF_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_ALT_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_TRACKING_NBR" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="APP_STATUS_GROUP_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_STATUS_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APPL_CLASS" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_APP_TYPE_ALIAS" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_CREATED_BY" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_INITIATED_BY_PRODUCT" />
</DefinedValue>
</DefinedValues>
<Object
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]"
Index="[B1PERMIT_PK]" Alias="[A]" TableReferenceId="-1" />
<SeekPredicates>
<SeekPredicate>
<Prefix
ScanType="EQ">
<RangeColumns>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="SERV_PROV_CODE" />

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID1" />

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID2" />

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID3" />
</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[sacco70].[dbo].[B1PERMIT].
[SERV_PROV_CODE] as [A].[SERV_PROV_CODE]">
<Identifier>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="SERV_PROV_CODE" />
</
Identifier>
</
ScalarOperator>

<ScalarOperator ScalarString="[sacco70].[dbo].[B1PERMIT].[B1_PER_ID1]
as [A].[B1_PER_ID1]">
<Identifier>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID1" />
</
Identifier>
</
ScalarOperator>

<ScalarOperator ScalarString="[sacco70].[dbo].[B1PERMIT].[B1_PER_ID2]
as [A].[B1_PER_ID2]">
<Identifier>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID2" />
</
Identifier>
</
ScalarOperator>

<ScalarOperator ScalarString="[sacco70].[dbo].[B1PERMIT].[B1_PER_ID3]
as [A].[B1_PER_ID3]">
<Identifier>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID3" />
</
Identifier>
</
ScalarOperator>
</
RangeExpressions>
</Prefix>
</SeekPredicate>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<Predicate>
<ScalarOperator
ScalarString="NOT [sacco70].[dbo].[B1PERMIT].[B1_PER_ID3] as [A].
[B1_PER_ID3] like '#%' AND [sacco70].[dbo].[B1PERMIT].[REC_STATUS] as
[A].[REC_STATUS]='A'">
<Logical Operation="AND">
<ScalarOperator>
<Logical
Operation="NOT">
<ScalarOperator>
<Intrinsic
FunctionName="like">
<ScalarOperator>
<Identifier>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[B1PERMIT]" Alias="[A]" Column="B1_PER_ID3" />
</Identifier>
</
ScalarOperator>
<ScalarOperator>
<Const
ConstValue="'#%'" />
</
ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Logical>
</ScalarOperator>
<ScalarOperator>
<Compare
CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="REC_STATUS" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const
ConstValue="'A'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp NodeId="80"
PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek"
EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581"
AvgRowSize="25" EstimatedTotalSubtreeCost="0.987555" Parallel="0"
EstimateRebinds="303" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="RECEIPT_NBR" />
</OutputList>
<IndexScan Ordered="1"
ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="SERV_PROV_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="RECEIPT_NBR" />
</DefinedValue>
</DefinedValues>
<Object Database="[sacco70]"
Schema="[dbo]" Table="[F4PAYMENT]" Index="[F4PAYMENT_PK]"
Alias="[PA]" />
<SeekPredicates>
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="B1_PER_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="B1_PER_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4PAYMENT]" Alias="[PA]"
Column="B1_PER_ID3" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator
ScalarString="[sacco70].[dbo].[B1PERMIT].[SERV_PROV_CODE] as [A].
[SERV_PROV_CODE]">
<Identifier>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="SERV_PROV_CODE" />
</Identifier>
</ScalarOperator>
<ScalarOperator
ScalarString="[sacco70].[dbo].[B1PERMIT].[B1_PER_ID1] as [A].
[B1_PER_ID1]">
<Identifier>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID1" />
</Identifier>
</ScalarOperator>
<ScalarOperator
ScalarString="[sacco70].[dbo].[B1PERMIT].[B1_PER_ID2] as [A].
[B1_PER_ID2]">
<Identifier>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID2" />
</Identifier>
</ScalarOperator>
<ScalarOperator
ScalarString="[sacco70].[dbo].[B1PERMIT].[B1_PER_ID3] as [A].
[B1_PER_ID3]">
<Identifier>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[B1PERMIT]" Alias="[A]"
Column="B1_PER_ID3" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekPredicate>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp NodeId="81" PhysicalOp="Table
Spool" LogicalOp="Lazy Spool" EstimateRows="9.73362" EstimateIO="0.01"
EstimateCPU="0.000101952" AvgRowSize="25"
EstimatedTotalSubtreeCost="0.0383829" Parallel="0" EstimateRebinds="0"
EstimateRewinds="101">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</OutputList>
<Spool>
<RelOp NodeId="82"
PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="9.73362"
EstimateIO="0.0112613" EstimateCPU="0.000157359" AvgRowSize="25"
EstimatedTotalSubtreeCost="0.0180041" Parallel="0" EstimateRebinds="0"
EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</OutputList>
<MemoryFractions Input="1"
Output="1" />

lsllcm

unread,
Nov 13, 2009, 11:41:40 PM11/13/09
to
<MemoryFractions Input="1"
Output="1" />
<Sort Distinct="1">
<OrderBy>
<OrderByColumn
Ascending="1">

<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
</OrderByColumn>
<OrderByColumn
Ascending="1">

<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</OrderByColumn>
</OrderBy>
<RelOp NodeId="83"
PhysicalOp="Concatenation" LogicalOp="Concatenation"
EstimateRows="10.7336" EstimateIO="0" EstimateCPU="1.07336e-006"
AvgRowSize="25" EstimatedTotalSubtreeCost="0.00658545" Parallel="0"

EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</OutputList>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</DefinedValue>
</DefinedValues>
<RelOp NodeId="84"

PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek"
EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581"
AvgRowSize="25" EstimatedTotalSubtreeCost="0.0032831" Parallel="0"

EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</OutputList>
<IndexScan Ordered="1"
ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</DefinedValue>
</DefinedValues>
<Object
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]"
Index="[F4RECEIPT_PK]" Alias="[RE]" />

<SeekPredicates>
<SeekPredicate>
<Prefix
ScanType="EQ">
<RangeColumns>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="SERV_PROV_CODE" />

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_NBR" />
</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[@spc1]">
<Identifier>

<ColumnReference Column="@spc1" />
</
Identifier>
</
ScalarOperator>

<ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[@nbr1],0)">
<Identifier>

<ColumnReference Column="ConstExpr1012">

<ScalarOperator>

<Convert DataType="bigint" Style="0" Implicit="1">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr1" />

</
Identifier>
</
ScalarOperator>
</
Convert>
</
ScalarOperator>
</
ColumnReference>

</
Identifier>
</
ScalarOperator>
</
RangeExpressions>
</Prefix>
</SeekPredicate>
</SeekPredicates>
</IndexScan>
</RelOp>
<RelOp NodeId="85"

PhysicalOp="Nested Loops" LogicalOp="Inner Join"
EstimateRows="9.73362" EstimateIO="0.003125" EstimateCPU="0.000167707"
AvgRowSize="39" EstimatedTotalSubtreeCost="0.00329271" Parallel="0"

EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_CUSTOMIZED_NBR" />
</OutputList>
<NestedLoops
Optimized="0">
<OuterReferences>
<ColumnReference
Column="ConstExpr1013">
<ScalarOperator
ScalarString="LikeRangeStart([@nbr2])">
<Intrinsic
FunctionName="LikeRangeStart">

<ScalarOperator>
<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ColumnReference>
<ColumnReference
Column="ConstExpr1014">
<ScalarOperator
ScalarString="LikeRangeEnd([@nbr2])">
<Intrinsic
FunctionName="LikeRangeEnd">

<ScalarOperator>
<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ColumnReference>
<ColumnReference
Column="ConstExpr1015">
<ScalarOperator
ScalarString="LikeRangeInfo([@nbr2])">
<Intrinsic
FunctionName="LikeRangeInfo">

<ScalarOperator>
<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ColumnReference>
</OuterReferences>
<RelOp NodeId="86"
PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar"
EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0"
EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0"
EstimateRewinds="0">
<OutputList>
<ColumnReference
Column="ConstExpr1013">
<ScalarOperator
ScalarString="LikeRangeStart([@nbr2])">
<Intrinsic
FunctionName="LikeRangeStart">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</
ScalarOperator>
</ColumnReference>
<ColumnReference
Column="ConstExpr1014">
<ScalarOperator
ScalarString="LikeRangeEnd([@nbr2])">
<Intrinsic
FunctionName="LikeRangeEnd">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</
ScalarOperator>
</ColumnReference>
<ColumnReference
Column="ConstExpr1015">
<ScalarOperator
ScalarString="LikeRangeInfo([@nbr2])">
<Intrinsic
FunctionName="LikeRangeInfo">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</
ScalarOperator>
</ColumnReference>
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>

<ColumnReference Column="ConstExpr1013">

<ScalarOperator ScalarString="LikeRangeStart([@nbr2])">
<Intrinsic
FunctionName="LikeRangeStart">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>

<ScalarOperator ScalarString="LikeRangeStart([@nbr2])">
<Identifier>

<ColumnReference Column="ConstExpr1013">

<ScalarOperator>

<Intrinsic FunctionName="LikeRangeStart">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>

<Const ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>
</
Identifier>
</
ScalarOperator>
</DefinedValue>
<DefinedValue>

<ColumnReference Column="ConstExpr1014">

<ScalarOperator ScalarString="LikeRangeEnd([@nbr2])">
<Intrinsic
FunctionName="LikeRangeEnd">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>

<ScalarOperator ScalarString="LikeRangeEnd([@nbr2])">
<Identifier>

<ColumnReference Column="ConstExpr1014">

<ScalarOperator>

<Intrinsic FunctionName="LikeRangeEnd">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>

<Const ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>
</
Identifier>
</
ScalarOperator>
</DefinedValue>
<DefinedValue>

<ColumnReference Column="ConstExpr1015">

<ScalarOperator ScalarString="LikeRangeInfo([@nbr2])">
<Intrinsic
FunctionName="LikeRangeInfo">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>

<ScalarOperator ScalarString="LikeRangeInfo([@nbr2])">
<Identifier>

<ColumnReference Column="ConstExpr1015">

<ScalarOperator>

<Intrinsic FunctionName="LikeRangeInfo">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>

<Const ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>
</
Identifier>
</
ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="87"
PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1"
EstimateIO="0" EstimateCPU="0" AvgRowSize="0"
EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0"
EstimateRewinds="0">
<OutputList />
<ConstantScan />
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp NodeId="95"
PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="9.73362"
EstimateIO="0.003125" EstimateCPU="0.000167707" AvgRowSize="39"
EstimatedTotalSubtreeCost="0.00329271" Parallel="0"

EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_CUSTOMIZED_NBR" />

</OutputList>
<IndexScan
Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="SERV_PROV_CODE" />
</DefinedValue>
<DefinedValue>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_NBR" />
</DefinedValue>
<DefinedValue>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_CUSTOMIZED_NBR" />
</DefinedValue>
</DefinedValues>
<Object
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]"
Index="[F4RECEIPT_CUST_REC_IX]" Alias="[RE]" />

<SeekPredicates>
<SeekPredicate>
<Prefix
ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="SERV_PROV_CODE" />
</
RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[@spc2]">

<Identifier>

<ColumnReference Column="@spc2" />

</
Identifier>
</
ScalarOperator>
</
RangeExpressions>
</Prefix>
<StartRange
ScanType="GT">


<RangeColumns>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_CUSTOMIZED_NBR" />
</
RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="LikeRangeStart([@nbr2])">

<Identifier>

<ColumnReference Column="ConstExpr1013">

<ScalarOperator>

<Intrinsic FunctionName="LikeRangeStart">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</Identifier>

</ScalarOperator>

<ScalarOperator>

<Const ConstValue="" />

</ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>

</
Identifier>
</
ScalarOperator>
</
RangeExpressions>
</StartRange>
<EndRange
ScanType="LT">


<RangeColumns>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_CUSTOMIZED_NBR" />
</
RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="LikeRangeEnd([@nbr2])">

<Identifier>

<ColumnReference Column="ConstExpr1014">

<ScalarOperator>

<Intrinsic FunctionName="LikeRangeEnd">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</Identifier>

</ScalarOperator>

<ScalarOperator>

<Const ConstValue="" />

</ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>

</
Identifier>
</
ScalarOperator>
</
RangeExpressions>
</EndRange>
</SeekPredicate>
</SeekPredicates>
<Predicate>
<ScalarOperator
ScalarString="[sacco70].[dbo].[F4RECEIPT].[RECEIPT_CUSTOMIZED_NBR] as
[RE].[RECEIPT_CUSTOMIZED_NBR] like [@nbr2]">

<Intrinsic
FunctionName="like">

<ScalarOperator>

<Identifier>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_CUSTOMIZED_NBR" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />
</
Identifier>
</
ScalarOperator>
</Intrinsic>
</
ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</Concat>
</RelOp>
</Sort>
</RelOp>
</Spool>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp NodeId="97" PhysicalOp="Clustered

Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1"
EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="1117"
EstimatedTotalSubtreeCost="0.334391" Parallel="0"
EstimateRebinds="100.999" EstimateRewinds="0.00139818">
<OutputList>
<ColumnReference Database="[sacco70]"
<IndexScan Ordered="1"
ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_CREATOR_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="APP_STATUS" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="DISPOSITION" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="BALANCE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="APP_STATUS_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="DISPOSITION_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="BALANCE_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="PM_SCHEDULE_SEQ" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="HOUSE_COUNT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="BUILDING_COUNT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="PUBLIC_OWNED" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="CONST_TYPE_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="ACTION" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_AGENCY_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_BUREAU_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_DIVISION_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_OFFICE_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_SECTION_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_GROUP_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_FNAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_MNAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_LNAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="TOTAL_FEE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="TOTAL_PAY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_APPL_SUB_STATUS" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_SHORT_NOTES" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_CLOSED_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_CLOSEDBY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_REPORTED_CHANNEL" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_ASGN_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_ASGN_STAFF" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_PRIORITY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_SEVERITY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_ASGN_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="TOTAL_JOB_COST" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_CLOSED_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_COMPLETE_BY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_COMPLETE_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_COMPLETE_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_SCHEDULED_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="PERCENT_COMPLETE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_CREATED_BY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_TRACK_START_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_ESTIMATED_DUE_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_IN_POSSESSION_TIME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_EST_PROD_UNITS" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_ACTUAL_PROD_UNITS" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_EST_COST_PER_UNIT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_COST_PER_UNIT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_EST_JOB_COST" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_PROD_UNIT_TYPE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_ANONYMOUS_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_REFERENCE_TYPE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_APPEARANCE_DAYOFWEEK" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_APPEARANCE_DD" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_BOOKING_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_DFNDT_SIGNATURE_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_ENFORCE_OFFICER_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_ENFORCE_OFFICER_NAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_INFRACTION_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_INSPECTOR_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_MISDEMEANOR_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_OFFN_WITNESSED_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_INSPECTOR_NAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_ENFORCE_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_INSPECTOR_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="APP_STATUS_REASON" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="FIRST_ISSUED_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="UNDISTRIBUTED_JOB_COST" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_VAL_MULTIPLIER" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_VAL_EXTRA_AMT" />
</DefinedValue>
</DefinedValues>
<Object Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Index="[BPERMIT_DETAIL_PK]"
Alias="[B]" />

<SeekPredicates>
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_PER_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_PER_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_PER_ID3" />
<RelOp NodeId="98" PhysicalOp="Clustered Index

Seek" LogicalOp="Clustered Index Seek" EstimateRows="1"
EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="2011"
EstimatedTotalSubtreeCost="0.333115" Parallel="0"
EstimateRebinds="100.999" EstimateRewinds="0.00139818">
<OutputList>
<ColumnReference Database="[sacco70]"

Schema="[dbo]" Table="[BWORKDES]" Alias="[C]" Column="B1_WORK_DESC" />
</OutputList>
<IndexScan Ordered="1"
ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BWORKDES]" Alias="[C]" Column="B1_WORK_DESC" />
</DefinedValue>
</DefinedValues>
<Object Database="[sacco70]"
Schema="[dbo]" Table="[BWORKDES]" Index="[BWORKDES_PK]" Alias="[C]" />

<SeekPredicates>
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BWORKDES]" Alias="[C]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BWORKDES]" Alias="[C]"
Column="B1_PER_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BWORKDES]" Alias="[C]"
Column="B1_PER_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BWORKDES]" Alias="[C]"
<RelOp NodeId="99" PhysicalOp="Clustered Index

Seek" LogicalOp="Clustered Index Seek" EstimateRows="1"
EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="218"
EstimatedTotalSubtreeCost="0.161571" Parallel="0"
EstimateRebinds="100.999" EstimateRewinds="0.00139818">
<OutputList>
<ColumnReference Database="[sacco70]"
<IndexScan Ordered="1" ScanDirection="FORWARD"
ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="RENEWAL_FEE_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_FEE_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_STATUS" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_INTERVAL" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_INTERVAL_UNITS" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="GRACE_PERIOD_INTERVAL" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="GRACE_PERIOD_INTERVAL_UNITS" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_INTERVAL" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_INTERVAL_UNITS" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="NUM_PENALTY_PERIODS" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="RENEWAL_FEE_FUNCTION" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_FEE_FUNCTION" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_PERIOD" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF1" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF2" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF3" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF4" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PAY_PERIOD_GROUP" />
</DefinedValue>
</DefinedValues>
<Object Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Index="[B1_EXPIRATION_PK]" Alias="[G]" />

<SeekPredicates>
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"

Column="SERV_PROV_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"

Column="B1_PER_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"

Column="B1_PER_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
</Top>
</RelOp>
<ParameterList>
<ColumnReference Column="@nbr2"
ParameterCompiledValue="'101007363%'" />
<ColumnReference Column="@spc2"
ParameterCompiledValue="'SACCO'" />
<ColumnReference Column="@nbr1"
ParameterCompiledValue="'101007363'" />
<ColumnReference Column="@spc1"
ParameterCompiledValue="'SACCO'" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>

lsllcm

unread,
Nov 13, 2009, 11:43:30 PM11/13/09
to
<MemoryFractions Input="1"
Output="1" />
<Sort Distinct="1">
<OrderBy>
<OrderByColumn
Ascending="1">
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
</OrderByColumn>
<OrderByColumn
Ascending="1">

<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</OrderByColumn>
</OrderBy>
<RelOp NodeId="83"
PhysicalOp="Concatenation" LogicalOp="Concatenation"
EstimateRows="10.7336" EstimateIO="0" EstimateCPU="1.07336e-006"
AvgRowSize="25" EstimatedTotalSubtreeCost="0.00658545" Parallel="0"

EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</OutputList>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</DefinedValue>
</DefinedValues>
<RelOp NodeId="84"
PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek"
EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581"
AvgRowSize="25" EstimatedTotalSubtreeCost="0.0032831" Parallel="0"

EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</OutputList>
<IndexScan Ordered="1"
ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
</DefinedValue>
</DefinedValues>
<Object

Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]"
Index="[F4RECEIPT_PK]" Alias="[RE]" />

<SeekPredicates>
<SeekPredicate>
<Prefix
ScanType="EQ">
<RangeColumns>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="SERV_PROV_CODE" />

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_NBR" />
</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[@spc1]">
<Identifier>

<ColumnReference Column="@spc1" />
</
Identifier>
</
ScalarOperator>

<ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[@nbr1],0)">
<Identifier>

<ColumnReference Column="ConstExpr1012">

<ScalarOperator>

<Convert DataType="bigint" Style="0" Implicit="1">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr1" />

</
Identifier>
</
ScalarOperator>
</
Convert>
</
ScalarOperator>
</
ColumnReference>
</
Identifier>
</
ScalarOperator>
</
RangeExpressions>
</Prefix>
</SeekPredicate>
</SeekPredicates>
</IndexScan>
</RelOp>
<RelOp NodeId="85"

PhysicalOp="Nested Loops" LogicalOp="Inner Join"
EstimateRows="9.73362" EstimateIO="0.003125" EstimateCPU="0.000167707"
AvgRowSize="39" EstimatedTotalSubtreeCost="0.00329271" Parallel="0"

EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_CUSTOMIZED_NBR" />
</OutputList>
<NestedLoops
Optimized="0">

<OuterReferences>
<ColumnReference
Column="ConstExpr1013">
<ScalarOperator
ScalarString="LikeRangeStart([@nbr2])">
<Intrinsic
FunctionName="LikeRangeStart">

<ScalarOperator>
<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</ScalarOperator>

</ColumnReference>
<ColumnReference
Column="ConstExpr1014">
<ScalarOperator
ScalarString="LikeRangeEnd([@nbr2])">
<Intrinsic
FunctionName="LikeRangeEnd">

<ScalarOperator>
<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</ScalarOperator>

</ColumnReference>
<ColumnReference
Column="ConstExpr1015">
<ScalarOperator
ScalarString="LikeRangeInfo([@nbr2])">
<Intrinsic
FunctionName="LikeRangeInfo">

<ScalarOperator>
<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</ScalarOperator>

</ColumnReference>
</OuterReferences>
<RelOp NodeId="86"
PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar"
EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0"
EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0"
EstimateRewinds="0">
<OutputList>
<ColumnReference

Column="ConstExpr1013">
<ScalarOperator
ScalarString="LikeRangeStart([@nbr2])">
<Intrinsic
FunctionName="LikeRangeStart">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</
ScalarOperator>
</ColumnReference>
<ColumnReference
Column="ConstExpr1014">
<ScalarOperator
ScalarString="LikeRangeEnd([@nbr2])">
<Intrinsic
FunctionName="LikeRangeEnd">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</
ScalarOperator>
</ColumnReference>
<ColumnReference
Column="ConstExpr1015">
<ScalarOperator
ScalarString="LikeRangeInfo([@nbr2])">
<Intrinsic
FunctionName="LikeRangeInfo">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</Intrinsic>
</
ScalarOperator>
</ColumnReference>
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>

<ColumnReference Column="ConstExpr1013">

<ScalarOperator ScalarString="LikeRangeStart([@nbr2])">
<Intrinsic
FunctionName="LikeRangeStart">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>

<ScalarOperator ScalarString="LikeRangeStart([@nbr2])">
<Identifier>

<ColumnReference Column="ConstExpr1013">

<ScalarOperator>

<Intrinsic FunctionName="LikeRangeStart">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>

<Const ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>
</
Identifier>
</
ScalarOperator>
</DefinedValue>
<DefinedValue>

<ColumnReference Column="ConstExpr1014">

<ScalarOperator ScalarString="LikeRangeEnd([@nbr2])">
<Intrinsic
FunctionName="LikeRangeEnd">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>

<ScalarOperator ScalarString="LikeRangeEnd([@nbr2])">
<Identifier>

<ColumnReference Column="ConstExpr1014">

<ScalarOperator>

<Intrinsic FunctionName="LikeRangeEnd">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>

<Const ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>
</
Identifier>
</
ScalarOperator>
</DefinedValue>
<DefinedValue>

<ColumnReference Column="ConstExpr1015">

<ScalarOperator ScalarString="LikeRangeInfo([@nbr2])">
<Intrinsic
FunctionName="LikeRangeInfo">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>
<Const
ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>

<ScalarOperator ScalarString="LikeRangeInfo([@nbr2])">
<Identifier>

<ColumnReference Column="ConstExpr1015">

<ScalarOperator>

<Intrinsic FunctionName="LikeRangeInfo">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>

<Const ConstValue="" />
</
ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>
</
Identifier>
</
ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="87"
PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1"
EstimateIO="0" EstimateCPU="0" AvgRowSize="0"
EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0"
EstimateRewinds="0">

<OutputList />
<ConstantScan />
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp NodeId="95"
PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="9.73362"
EstimateIO="0.003125" EstimateCPU="0.000167707" AvgRowSize="39"
EstimatedTotalSubtreeCost="0.00329271" Parallel="0"

EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_NBR" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]" Alias="[RE]"
Column="RECEIPT_CUSTOMIZED_NBR" />

</OutputList>
<IndexScan
Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="SERV_PROV_CODE" />
</DefinedValue>
<DefinedValue>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_NBR" />
</DefinedValue>
<DefinedValue>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_CUSTOMIZED_NBR" />
</DefinedValue>
</DefinedValues>
<Object

Database="[sacco70]" Schema="[dbo]" Table="[F4RECEIPT]"
Index="[F4RECEIPT_CUST_REC_IX]" Alias="[RE]" />

<SeekPredicates>
<SeekPredicate>
<Prefix
ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="SERV_PROV_CODE" />
</
RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[@spc2]">

<Identifier>

<ColumnReference Column="@spc2" />

</
Identifier>
</
ScalarOperator>
</
RangeExpressions>
</Prefix>
<StartRange
ScanType="GT">


<RangeColumns>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_CUSTOMIZED_NBR" />
</
RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="LikeRangeStart([@nbr2])">

<Identifier>

<ColumnReference Column="ConstExpr1013">

<ScalarOperator>

<Intrinsic FunctionName="LikeRangeStart">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</Identifier>

</ScalarOperator>

<ScalarOperator>

<Const ConstValue="" />

</ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>
</
Identifier>
</
ScalarOperator>
</
RangeExpressions>
</StartRange>
<EndRange
ScanType="LT">


<RangeColumns>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_CUSTOMIZED_NBR" />
</
RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="LikeRangeEnd([@nbr2])">

<Identifier>

<ColumnReference Column="ConstExpr1014">

<ScalarOperator>

<Intrinsic FunctionName="LikeRangeEnd">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />

</Identifier>

</ScalarOperator>

<ScalarOperator>

<Const ConstValue="" />

</ScalarOperator>
</
Intrinsic>
</
ScalarOperator>
</
ColumnReference>
</
Identifier>
</
ScalarOperator>
</
RangeExpressions>
</EndRange>
</SeekPredicate>
</SeekPredicates>
<Predicate>
<ScalarOperator

ScalarString="[sacco70].[dbo].[F4RECEIPT].[RECEIPT_CUSTOMIZED_NBR] as
[RE].[RECEIPT_CUSTOMIZED_NBR] like [@nbr2]">
<Intrinsic
FunctionName="like">

<ScalarOperator>

<Identifier>

<ColumnReference Database="[sacco70]" Schema="[dbo]"
Table="[F4RECEIPT]" Alias="[RE]" Column="RECEIPT_CUSTOMIZED_NBR" />

</
Identifier>
</
ScalarOperator>

<ScalarOperator>

<Identifier>

<ColumnReference Column="@nbr2" />
</
Identifier>
</
ScalarOperator>

</Intrinsic>
</
ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</Concat>
</RelOp>
</Sort>
</RelOp>
</Spool>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp NodeId="97" PhysicalOp="Clustered

Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1"
EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="1117"
EstimatedTotalSubtreeCost="0.334391" Parallel="0"
EstimateRebinds="100.999" EstimateRewinds="0.00139818">
<OutputList>
<ColumnReference Database="[sacco70]"
<IndexScan Ordered="1"
ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_CREATOR_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="APP_STATUS" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="DISPOSITION" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="BALANCE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="APP_STATUS_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="DISPOSITION_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="BALANCE_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="PM_SCHEDULE_SEQ" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="HOUSE_COUNT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="BUILDING_COUNT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="PUBLIC_OWNED" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="CONST_TYPE_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="ACTION" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_AGENCY_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_BUREAU_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_DIVISION_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_OFFICE_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_SECTION_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_GROUP_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_FNAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_MNAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="GA_LNAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="TOTAL_FEE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="TOTAL_PAY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_APPL_SUB_STATUS" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_SHORT_NOTES" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_CLOSED_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_CLOSEDBY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_REPORTED_CHANNEL" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_ASGN_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_ASGN_STAFF" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_PRIORITY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_SEVERITY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_ASGN_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="TOTAL_JOB_COST" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_CLOSED_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_COMPLETE_BY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_COMPLETE_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_COMPLETE_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_SCHEDULED_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="PERCENT_COMPLETE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_CREATED_BY" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_TRACK_START_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_ESTIMATED_DUE_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_IN_POSSESSION_TIME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_EST_PROD_UNITS" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_ACTUAL_PROD_UNITS" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_EST_COST_PER_UNIT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_COST_PER_UNIT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_EST_JOB_COST" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_PROD_UNIT_TYPE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_ANONYMOUS_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_REFERENCE_TYPE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_APPEARANCE_DAYOFWEEK" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_APPEARANCE_DD" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_BOOKING_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_DFNDT_SIGNATURE_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_ENFORCE_OFFICER_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_ENFORCE_OFFICER_NAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_INFRACTION_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_INSPECTOR_ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_MISDEMEANOR_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_OFFN_WITNESSED_FLAG" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_INSPECTOR_NAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_ENFORCE_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="C6_INSPECTOR_DEPT" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="APP_STATUS_REASON" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="FIRST_ISSUED_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="UNDISTRIBUTED_JOB_COST" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_VAL_MULTIPLIER" />
</DefinedValue>
<DefinedValue>
<ColumnReference

Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_VAL_EXTRA_AMT" />
</DefinedValue>
</DefinedValues>
<Object Database="[sacco70]"
Schema="[dbo]" Table="[BPERMIT_DETAIL]" Index="[BPERMIT_DETAIL_PK]"
Alias="[B]" />

<SeekPredicates>
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_PER_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_PER_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BPERMIT_DETAIL]"
Alias="[B]" Column="B1_PER_ID3" />
<RelOp NodeId="98" PhysicalOp="Clustered Index

Seek" LogicalOp="Clustered Index Seek" EstimateRows="1"
EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="2011"
EstimatedTotalSubtreeCost="0.333115" Parallel="0"
EstimateRebinds="100.999" EstimateRewinds="0.00139818">
<OutputList>
<ColumnReference Database="[sacco70]"

Schema="[dbo]" Table="[BWORKDES]" Alias="[C]" Column="B1_WORK_DESC" />
</OutputList>
<IndexScan Ordered="1"
ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[BWORKDES]" Alias="[C]" Column="B1_WORK_DESC" />
</DefinedValue>
</DefinedValues>
<Object Database="[sacco70]"
Schema="[dbo]" Table="[BWORKDES]" Index="[BWORKDES_PK]" Alias="[C]" />

<SeekPredicates>
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BWORKDES]" Alias="[C]"
Column="SERV_PROV_CODE" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BWORKDES]" Alias="[C]"
Column="B1_PER_ID1" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BWORKDES]" Alias="[C]"
Column="B1_PER_ID2" />
<ColumnReference
Database="[sacco70]" Schema="[dbo]" Table="[BWORKDES]" Alias="[C]"
<RelOp NodeId="99" PhysicalOp="Clustered Index

Seek" LogicalOp="Clustered Index Seek" EstimateRows="1"
EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="218"
EstimatedTotalSubtreeCost="0.161571" Parallel="0"
EstimateRebinds="100.999" EstimateRewinds="0.00139818">
<OutputList>
<ColumnReference Database="[sacco70]"
<IndexScan Ordered="1" ScanDirection="FORWARD"
ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="RENEWAL_FEE_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_FEE_CODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_STATUS" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_DATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_INTERVAL" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="EXPIRATION_INTERVAL_UNITS" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="GRACE_PERIOD_INTERVAL" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="GRACE_PERIOD_INTERVAL_UNITS" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_INTERVAL" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_INTERVAL_UNITS" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="NUM_PENALTY_PERIODS" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="RENEWAL_FEE_FUNCTION" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_FEE_FUNCTION" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PENALTY_PERIOD" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF1" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF2" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF3" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]" Column="UDF4" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"
Column="PAY_PERIOD_GROUP" />
</DefinedValue>
</DefinedValues>
<Object Database="[sacco70]" Schema="[dbo]"
Table="[B1_EXPIRATION]" Index="[B1_EXPIRATION_PK]" Alias="[G]" />

<SeekPredicates>
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"

Column="SERV_PROV_CODE" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"

Column="B1_PER_ID1" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"

Column="B1_PER_ID2" />
<ColumnReference Database="[sacco70]"
Schema="[dbo]" Table="[B1_EXPIRATION]" Alias="[G]"

Erland Sommarskog

unread,
Nov 14, 2009, 4:21:18 PM11/14/09
to
lsllcm (lsl...@gmail.com) writes:
> I have one question about bind variable cause different execution
> plan.
>
> When I run the query without bind variable, and hard - coded
> parameter, it runs very quickly. After I change the query as below. It
> runs very slow. Do you have any idea?

First of all, I'm afraid that I did not make the effort of trying to
reconstruct the .sqlplan file from your three posts. You mentioned a
link in your post, but I did not see any. Maybe that is only one that
is visible on Google News from where you appear to post. If you are not
able to make proper attachments, the best is to make the file available
for download and post the URL.

It also helps, if you can post CREATE TABLE and CREATE INDEX statements
for your tables.

So to your question, when you hard-code value, the optimizer has more
information than when you use parameters. When you use parameters the
optimizer must account for all possible values the parameters may have,
as the query plan may be reused with other values. This can affect the
outcome.

Next, I don't really understand why you make this as dynamic SQL, but
maybe this is sent from your client in your application.

Anyway, I notice this condition:

> ' AND ((RE.SERV_PROV_CODE = @spc1 AND RE.RECEIPT_NBR = @nbr1 ) OR '
> +
> ' (RE.SERV_PROV_CODE = @spc2 AND RE.RECEIPT_CUSTOMIZED_NBR LIKE
> @nbr2 )) ' +
> ' ORDER BY A.B1_FILE_DD DESC ';

Conditions with OR is always a challenge for the optimizer. You may
help the optimizer by writing the query as:

SELECT TOP 101 *
FROM (SELECT ...
...
AND RE.SERV_PROV_CODE = @spc1 AND RE.RECEIPT_NBR = @nbr1
UNION
SELECT ...
AND RE.SERV_PROV_CODE = @spc2 AND
RE.RECEIPT_CUSTOMIZED_NBR LIKE) AS u
ORDER BY B1_FILE_DD


--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

bill

unread,
Nov 16, 2009, 1:19:35 AM11/16/09
to
On Nov 14, 2:21 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> lsllcm (lsl...@gmail.com) writes:
> I have one question about bind variable cause different execution
> plan.
>
> When I run the query without bind variable, and hard - coded
> parameter, it runs very quickly. After I change the query as below. It
> runs very slow. Do you have any idea?

Reading the plan from the posts was too difficult for me, but I do
have an idea: Make sure your variable is EXACTLY the same data type
as the column to which you are comparing.

I had a case once where the column was a varchar, and I made the
variable an Nvarchar. The query performed horribly. When I changed
the variable to be a varchar, the query sped up by a factor of 4 (or
perhaps it was 10, I can't remember).

I remember someone telling me that the performance penalty for this
type of datatype mis-match can vary based on the collation page you
are using, but I don't remember the details. I believe that with
certain collations an Nvarchar / varchar mismatch can change the plan
from an index seek to a scan.


Thanks,

Bill

Erland Sommarskog

unread,
Nov 16, 2009, 3:45:07 PM11/16/09
to
bill (billma...@gmail.com) writes:
> Reading the plan from the posts was too difficult for me, but I do
> have an idea: Make sure your variable is EXACTLY the same data type
> as the column to which you are comparing.

Very good point.



> I had a case once where the column was a varchar, and I made the
> variable an Nvarchar. The query performed horribly. When I changed
> the variable to be a varchar, the query sped up by a factor of 4 (or
> perhaps it was 10, I can't remember).
>
> I remember someone telling me that the performance penalty for this
> type of datatype mis-match can vary based on the collation page you
> are using, but I don't remember the details. I believe that with
> certain collations an Nvarchar / varchar mismatch can change the plan
> from an index seek to a scan.

Yes. If you have a Windows collation, SQL Server seeks the index, but
in a more roundabout way. This is possible, because the varchar set
is a true subset of the full Unicode. My tests indicates that this gives
an overhead of factor 2 or 3.

But if you have an SQL collation, there different rules for some characters
between varchar and nvarchar, why the index is dead. How much this costs
you in terms of factor, depends on much data there is. It may over a
thousand times slower - or worse.

0 new messages