Hi all,

Can anyone help me with the following query please?

SELECT TOP 100 PERCENT T.DOCKET, T.NAME, T.ADDRESS AS homeAddress,
T.CITY AS homeCity, T.STATE AS homeState, T.CHARTER_DESC,
T.ZIP AS homeZip, ISNULL(getBranchCode.branchCode,
'0') AS branchCode, B2.OFFICE_TYPE, B2.ADDRESS, B2.CITY, B2.COUNTY,
B2.STATE, B2.ZIP,
B2.DEPOSITS
FROM dbo.THRIFT_HISTORY_RPT T INNER JOIN
dbo.BRANCH_OFFICES_RPT B2 ON T.DOCKET = B2.DOCKET
INNER JOIN
dbo.BRANCH_OFFICES_RPT B1 ON B2.DOCKET = B1.DOCKET
RIGHT OUTER JOIN
(SELECT DISTINCT A.Docket, B.Seq_Num, '1' AS
branchCode
FROM Branch_Offices_Rpt B,
All_Institutions_Rpt A
WHERE A.Docket = B.Docket AND B.Cycle_Date
= '30-JUN-02' AND A.State = B.State AND A.Entity_Type = 'T' AND (A.Docket =
'08551')
GROUP BY A.Docket, B.Seq_Num) getBranchCode ON
B2.DOCKET = getBranchCode.Docket AND B2.SEQ_NUM = getBranchCode.Seq_Num
WHERE ('30-JUN-02' BETWEEN T.RECORD_START_DATE AND T.RECORD_END_DATE)
AND (T.DOCKET = '08551') AND (B2.CYCLE_DATE = '30-JUN-02') AND
(B2.CHANGE_CODE <> 'C') AND
(B1.CYCLE_DATE = '30-JUN-02') AND (B1.CHANGE_CODE <>
'C') AND (B1.OFFICE_TYPE = 'H')
ORDER BY getBranchCode.branchCode

The query works, but for large output rows, >20 it takes a few minutes to
run.

Thanks.

Sang Nahm
MS Sql Server LazyDBA home page