Saturday, February 25, 2012

Problems when using TOP statement

Hi!
I have a query that takes about 3 seconds to process. When I add TOP 20 to
reduce the number of hits the same query takes 18 seconds. Is this a correct
behaviour?
/Henke
absolutely not. Can you post your query, and possibly your table schema.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Henke" <henke_nord@.hotmail.com> wrote in message
news:OPz3QwV%23EHA.208@.TK2MSFTNGP12.phx.gbl...
> Hi!
> I have a query that takes about 3 seconds to process. When I add TOP 20 to
> reduce the number of hits the same query takes 18 seconds. Is this a
correct
> behaviour?
> /Henke
>
|||Hi, and thanks for your answer! Here is the query and a script that I hope
can generate the parts of our database that is involved.
SELECT TOP 20 dbo.SalesProject.SalesProjectID AS SPV_SalesProjectID,
dbo.SalesProject.SalesProjectNumber AS SPV_SalesProjectNumber,
dbo.SalesProject.SalesProjectName AS SPV_SalesProjectName,
dbo.SalesProject.CustomerID AS SPV_CustomerID,
dbo.SalesProject.SalesProjectTypeID AS SPV_SalesProjectTypeID,
dbo.SalesProject.PhaseID AS SPV_PhaseID, dbo.Customer.CustomerID AS
CV_CustomerID, dbo.Customer.CustomerNumber AS CV_CustomerNumber,
dbo.Customer.CustomerName AS CV_CustomerName,
dbo.Customer.CustomerBusinessGroupID AS CV_CustomerBusinessGroupID,
dbo.Customer.OrganisationNumber AS CV_OrganisationNumber,
dbo.Customer.Street AS CV_Street, dbo.Customer.ZipCode AS CV_ZipCode,
dbo.Customer.City AS CV_City
FROM dbo.Customer LEFT OUTER JOIN
dbo.SalesProject ON dbo.Customer.CustomerID = dbo.SalesProject.CustomerID
WHERE (dbo.SalesProject.SalesProjectID IN
(SELECT SalesprojectID
FROM RealEstate
WHERE (RealEstateID IN
(SELECT Building.RealestateID
FROM Building
WHERE BuildingID IN
(SELECT BuildingID
FROM InstallationAddress
WHERE InstallationAddress.Street LIKE 'drottning%' AND
Replace(InstallationAddress.ZipCode, ' ', '') LIKE '65224%' AND
InstallationAddress.City LIKE 'karlstad%')))))
OR(dbo.SalesProject.SalesProjectID IN
(SELECT SalesProjectID
FROM ConnectionAddress
WHERE ConnectionAddress.Street LIKE 'drottning%' AND
Replace(ConnectionAddress.ZipCode, ' ', '') LIKE '65224%' AND
ConnectionAddress.City LIKE 'karlstad%'))
/Henke
"Hilary Cotter" <hilary.cotter@.gmail.com> skrev i meddelandet
news:uBC7hnW%23EHA.2112@.TK2MSFTNGP14.phx.gbl...
> absolutely not. Can you post your query, and possibly your table schema.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Henke" <henke_nord@.hotmail.com> wrote in message
> news:OPz3QwV%23EHA.208@.TK2MSFTNGP12.phx.gbl...
> correct
>
begin 666 top_problem.sql
M__YI`&8`( !E`'@.`:0!S`'0`<P`@.`"@.`<P!E`&P`90!C`'0`( `J`" `9@.!R
M`&\`;0`@.`&0`8@.!O`"X`<P!Y`',`;P!B`&H`90!C`'0`<P`@.` '<`: !E`'(`
M90`@.`&D`9 `@.`#T`( !O`&(`:@.!E`&,`= !?`&D`9 `H`$X`)P!;`&0`8@.!O
M`%T`+@.!;`$8`2P!?`&D`;@.!S`'0`80!L`&P`80!T`&D`;P!N` %\`80!D`&0`
M<@.!E`',`<P!?`&(`=0!I`&P`9 !I`&X`9P!=`"<`*0`@.`&$`;@.!D`" `3P!"
M`$H`10!#`%0`4 !2`$\`4 !%`%(`5 !9`"@.`:0!D`"P`( !.`"<`20!S`$8`
M;P!R`&4`:0!G`&X`2P!E`'D`)P`I`" `/0`@.`#$`*0`-``H`00!,`%0`10!2
M`" `5 !!`$(`3 !%`" `6P!D`&(`;P!=`"X`6P!)`&X`<P!T`&$`; !L`&$`
M= !I`&\`;@.!!`&0`9 !R`&4`<P!S`%T`( !$`%(`3P!0`" `0P!/`$X`4P!4
M`%(`00!)`$X`5 `@.`$8`2P!?`&D`;@.!S`'0`80!L`&P`80!T`&D`;P!N`%\`
M80!D`&0`<@.!E`',`<P!?`&(`=0!I`&P`9 !I`&X`9P`-``H`1P!/``T`"@.`-
M``H`:0!F`" `90!X`&D`<P!T`',`( `H`',`90!L`&4`8P!T`" `*@.`@.`&8`
M<@.!O`&T`( !D`&(`;P`N`',`>0!S`&\`8@.!J`&4`8P!T`',`( !W`&@.`90!R
M`&4`( !I`&0`( `]`" `;P!B`&H`90!C`'0`7P!I`&0`* !.`"<`6P!D`&(`
M;P!=`"X`6P!&`$L`7P!"`'4`:0!L`&0`:0!N`&<`7P!"`'4`: 0!L`&0`:0!N
M`&<`5 !Y`' `90!=`"<`*0`@.`&$`;@.!D`" `3P!"`$H`10!#`%0`4 !2`$\`
M4 !%`%(`5 !9`"@.`:0!D`"P`( !.`"<`20!S`$8`;P!R`&4`:0!G`&X`2P!E
M`'D`)P`I`" `/0`@.`#$`*0`-``H`00!,`%0`10!2`" `5 !!`$(`3 !%`" `
M6P!D`&(`;P!=`"X`6P!"`'4`:0!L`&0`:0!N`&<`70`@.`$0`4 @.!/`% `( !#
M`$\`3@.!3`%0`4@.!!`$D`3@.!4`" `1@.!+`%\`0@.!U`&D`; !D`&D`;@.!G`%\`
M0@.!U`&D`; !D`&D`;@.!G`%0`>0!P`&4`#0`*`$<`3P`-``H`#0`*`&D`9@.`@.
M`&4`> !I`',`= !S`" `* !S`&4`; !E`&,`= `@.`"H`( !F`'(`;P!M`" `
M9 !B`&\`+@.!S`'D`<P!O`&(`:@.!E`&,`= !S`" `=P!H`&4`<@.!E`" `:0!D
M`" `/0`@.`&\`8@.!J`&4`8P!T`%\`:0!D`"@.`3@.`G`%L`9 !B`&\`70`N`%L`
M1@.!+`%\`0P!U`',`= !O`&T`90!R`%\`0P!U`',`= !O`&T`90!R`%T`)P`I
M`" `80!N`&0`( !/`$(`2@.!%`$,`5 !0`%(`3P!0`$4`4@.!4`%D`* !I`&0`
M+ `@.`$X`)P!)`',`1@.!O`'(`90!I`&<`;@.!+`&4`>0`G`"D`( `]`" `,0`I
M``T`"@.!!`$P`5 !%`%(`( !4`$$`0@.!,`$4`( !;`&0`8@.!O`%T`+@.!;`$,`
M=0!S`'0`;P!M`&4`<@.!=`" `1 !2`$\`4 `@.`$,`3P!.`%,`5 !2`$$`20!.
M`%0`( !&`$L`7P!#`'4`<P!T`&\`;0!E`'(`7P!#`'4`<P!T`&\`;0!E `'(`
M#0`*`$<`3P`-``H`#0`*`&D`9@.`@.`&4`> !I`',`= !S`" `* !S`&4`; !E
M`&,`= `@.`"H`( !F`'(`;P!M`" `9 !B`&\`+@.!S`'D`<P!O`&(`:@.!E`&,`
M= !S`" `=P!H`&4`<@.!E`" `:0!D`" `/0`@.`&\`8@.!J`&4`8P!T`%\`:0!D
M`"@.`3@.`G`%L`9 !B`&\`70`N`%L`1@.!+`%\`<P!A`&P`90!S`' `<@.!O`&H`
M90!C`'0`7P!C`'4`<P!T`&\`;0!E`'(`70`G`"D`( !A`&X`9 `@.`$\`0@.!*
M`$4`0P!4`% `4@.!/`% `10!2`%0`60`H`&D`9 `L`" `3@.`G`$D`<P!&`&\`
M<@.!E`&D`9P!N`$L`90!Y`"<`*0`@.`#T`( `Q`"D`#0`*`$$`3 !4`$4`4@.`@.
M`%0`00!"`$P`10`@.`%L`9 !B`&\`70`N`%L`4P!A`&P`90!S`% `<@.!O`&H`
M90!C`'0`70`@.`$0`4@.!/`% `( !#`$\`3@.!3`%0`4@.!!`$D`3@.!4`" `1@.!+
M`%\`<P!A`&P`90!S`' `<@.!O`&H`90!C`'0`7P!C`'4`<P!T`&\`;0!E`'(`
M#0`*`$<`3P`-``H`#0`*`&D`9@.`@.`&4`> !I`',`= !S`" `* !S`&4`; !E
M`&,`= `@.`"H`( !F`'(`;P!M`" `9 !B`&\`+@.!S`'D`<P!O`&(`:@.!E`&,`
M= !S`" `=P!H`&4`<@.!E`" `:0!D`" `/0`@.`&\`8@.!J`&4`8P!T`%\`:0!D
M`"@.`3@.`G`%L`9 !B`&\`70`N`%L`1@.!+`%\`8P!U`',`= !O`&T`90!R`%\`
M0P!U`',`= !O`&T`90!R`$(`=0!I`',`;@.!E`',`<P!'`'(`;P!U`' `70`G
M`"D`( !A`&X`9 `@.`$\`0@.!*`$4`0P!4`% `4@.!/`% `10!2`%0`60`H`&D`
M9 `L`" `3@.`G`$D`<P!&`&\`<@.!E`&D`9P!N`$L`90!Y`"<`*0`@.`#T`( `Q
M`"D`#0`*`$$`3 !4`$4`4@.`@.`%0`00!"`$P`10`@.`%L`9 !B`&\`70`N`%L`
M0P!U`',`= !O`&T`90!R`%T`( !$`%(`3P!0`" `0P!/`$X`4P!4`%(`00!)
M`$X`5 `@.`$8`2P!?`&,`=0!S`'0`;P!M`&4`<@.!?`$,`=0!S`'0`;P!M `&4`
M<@.!"`'4`:0!S`&X`90!S`',`1P!R`&\`=0!P``T`"@.!'`$\`# 0`*``T`"@.!I
M`&8`( !E`'@.`:0!S`'0`<P`@.`"@.`<P!E`&P`90!C`'0`( `J`" `9@.!R`&\`
M;0`@.`&0`8@.!O`"X`<P!Y`',`;P!B`&H`90!C`'0`<P`@.`'<`: !E`'(`90`@.
M`&D`9 `@.`#T`( !O`&(`:@.!E`&,`= !?`&D`9 `H`$X`)P!;`&0`8@.!O`%T`
M+@.!;`$8`2P!?`&(`=0!I`&P`9 !I`&X`9P!?`'(`90!A`&P`7P!E`',`= !A
M`'0`90!=`"<`*0`@.`&$`;@.!D`" `3P!"`$H`10!#`%0`4 !2`$\`4 !%`%(`
M5 !9`"@.`:0!D`"P`( !.`"<`20!S`$8`;P!R`&4`:0!G`&X`2P!E`'D`)P`I
M`" `/0`@.`#$`*0`-``H`00!,`%0`10!2`" `5 !!`$(`3 !%`" `6P!D`&(`
M;P!=`"X`6P!"`'4`:0!L`&0`:0!N`&<`70`@.`$0`4@.!/`% `( !#`$\`3@.!3
M`%0`4@.!!`$D`3@.!4`" `1@.!+`%\`8@.!U`&D`; !D`&D`;@.!G`%\`<@.!E`&$`
M; !?`&4`<P!T`&$`= !E``T`"@.!'`$\`#0`*``T`"@.!I`&8`( !E`'@.`:0!S
M`'0`<P`@.`"@.`<P!E`&P`90!C`'0`( `J`" `9@.!R`&\`;0`@.`&0`8@.!O`"X`
M<P!Y`',`;P!B`&H`90!C`'0`<P`@.`'<`: !E`'(`90`@.`&D`9 `@.`#T`( !O
M`&(`:@.!E`&,`= !?`&D`9 `H`$X`)P!;`&0`8@.!O`%T`+@.!;`$8`2P!?`$$`
M8P!T`&D`=@.!I`'0`>0!?`%,`80!L`&4`<P!0`'(`;P!J`&4`8 P!T`%T`)P`I
M`" `80!N`&0`( !/`$(`2@.!%`$,`5 !0`%(`3P!0`$4`4@.!4`%D`* !I`&0`
M+ `@.`$X`)P!)`',`1@.!O`'(`90!I`&<`;@.!+`&4`>0`G`"D`( `]`" `,0`I
M``T`"@.!!`$P`5 !%`%(`( !4`$$`0@.!,`$4`( !;`&0`8@.!O`%T`+@.!;`$$`
M8P!T`&D`=@.!I`'0`>0!=`" `1 !2`$\`4 `@.`$,`3P!.`%,`5 !2`$$`20!.
M`%0`( !&`$L`7P!!`&,`= !I`'8`:0!T`'D`7P!3`&$`; !E`',`4 !R`&\`
M:@.!E`&,`= `-``H`1P!/``T`"@.`-``H`:0!F`" `90!X`&D`<P!T`',`( `H
M`',`90!L`&4`8P!T`" `*@.`@.`&8`<@.!O`&T`( !D`&(`;P`N`',`>0!S`&\`
M8@.!J`&4`8P!T`',`( !W`&@.`90!R`&4`( !I`&0`( `]`" `;P!B`&H`90!C
M`'0`7P!I`&0`* !.`"<`6P!D`&(`;P!=`"X`6P!&`$L`7P!#`&\`;@.!F`&D`
M9P!U`'(`90!D`$$`9P!R`&4`90!M`&4`;@.!T`%\`4P!A`&P`9 0!S`% `<@.!O
M`&H`90!C`'0`70`G`"D`( !A`&X`9 `@.`$\`0@.!*`$4`0P!4`% `4@.!/`% `
M10!2`%0`60`H`&D`9 `L`" `3@.`G`$D`<P!&`&\`<@.!E`&D`9P!N`$L`90!Y
M`"<`*0`@.`#T`( `Q`"D`#0`*`$$`3 !4`$4`4@.`@.`%0`00!"`$P`10`@.`%L`
M9 !B`&\`70`N`%L`0P!O`&X`9@.!I`&<`=0!R`&4`9 !!`&<`<@.!E`&4`;0!E
M`&X`= !=`" `1 !2`$\`4 `@.`$,`3P!.`%,`5 !2`$$`20!.`%0`( !&`$L`
M7P!#`&\`;@.!F`&D`9P!U`'(`90!D`$$`9P!R`&4`90!M`&4`; @.!T`%\`4P!A
M`&P`90!S`% `<@.!O`&H`90!C`'0`#0`*`$<`3P`-``H`#0`*`&D`9@.`@.`&4`
M> !I`',`= !S`" `* !S`&4`; !E`&,`= `@.`"H`( !F`'(`;P!M`" `9 !B
M`&\`+@.!S`'D`<P!O`&(`:@.!E`&,`= !S`" `=P!H`&4`<@.!E`" `:0!D`" `
M/0`@.`&\`8@.!J`&4`8P!T`%\`:0!D`"@.`3@.`G`%L`9 !B`&\`70`N`%L`1@.!+
M`%\`0P!O`&X`;@.!E`&,`= !I`&\`;@.!!`&0`9 !R`&4`<P!S`%\`4P!A`&P`
M90!S`% `<@.!O`&H`90!C`'0`70`G`"D`( !A`&X`9 `@.`$\`0@.!*`$4`0P!4
M`% `4@.!/`% `10!2`%0`60`H`&D`9 `L`" `3@.`G`$D`<P!&`&\`<@.!E`&D`
M9P!N`$L`90!Y`"<`*0`@.`#T`( `Q`"D`#0`*`$$`3 !4`$4`4@.`@.`%0`00!"
M`$P`10`@.`%L`9 !B`&\`70`N`%L`0P!O`&X`;@.!E`&,`= !I`&\`;@.!!`&0`
M9 !R`&4`<P!S`%T`( !$`%(`3P!0`" `0P!/`$X`4P!4`%(`00!)`$X`5 `@.
M`$8`2P!?`$,`;P!N`&X`90!C`'0`:0!O`&X`00!D`&0`<@.!E` ',`<P!?`%,`
M80!L`&4`<P!0`'(`;P!J`&4`8P!T``T`"@.!'`$\`#0`*``T`" @.!I`&8`( !E
M`'@.`:0!S`'0`<P`@.`"@.`<P!E`&P`90!C`'0`( `J`" `9@.!R`&\`;0`@.`&0`
M8@.!O`"X`<P!Y`',`;P!B`&H`90!C`'0`<P`@.`'<`: !E`'(`90`@.`&D`9 `@.
M`#T`( !O`&(`:@.!E`&,`= !?`&D`9 `H`$X`)P!;`&0`8@.!O`%T`+@.!;`$8`
M2P!?`$,`=0!R`'(`90!N`'0`20!3`% `7P!3`&$`; !E`',`4 !R`&\`:@.!E
M`&,`= !=`"<`*0`@.`&$`;@.!D`" `3P!"`$H`10!#`%0`4 !2`$\`4 !%`%(`
M5 !9`"@.`:0!D`"P`( !.`"<`20!S`$8`;P!R`&4`:0!G`&X`2P!E`'D`)P`I
M`" `/0`@.`#$`*0`-``H`00!,`%0`10!2`" `5 !!`$(`3 !%`" `6P!D`&(`
M;P!=`"X`6P!#`'4`<@.!R`&4`;@.!T`$D`4P!0`%T`( !$`%(`3P!0`" `0P!/
M`$X`4P!4`%(`00!)`$X`5 `@.`$8`2P!?`$,`=0!R`'(`90!N`'0`20!3`% `
M7P!3`&$`; !E`',`4 !R`&\`:@.!E`&,`= `-``H`1P!/``T`"@.`-``H`:0!F
M`" `90!X`&D`<P!T`',`( `H`',`90!L`&4`8P!T`" `*@.`@.`&8`<@.!O`&T`
M( !D`&(`;P`N`',`>0!S`&\`8@.!J`&4`8P!T`',`( !W`&@.`90!R`&4`( !I
M`&0`( `]`" `;P!B`&H`90!C`'0`7P!I`&0`* !.`"<`6P!D`&(`;P!=`"X`
M6P!&`$L`7P!$`&\`8P!U`&T`90!N`'0`7P!3`&$`; !E`',`4 !R`&\`:@.!E
M`&,`= !=`"<`*0`@.`&$`;@.!D`" `3P!"`$H`10!#`%0`4 !2`$\`4 !%`%(`
M5 !9`"@.`:0!D`"P`( !.`"<`20!S`$8`;P!R`&4`:0!G`&X`2P!E`'D`)P`I
M`" `/0`@.`#$`*0`-``H`00!,`%0`10!2`" `5 !!`$(`3 !%`" `6P!D`&(`
M;P!=`"X`6P!$`&\`8P!U`&T`90!N`'0`70`@.`$0`4@.!/`% `( !#`$\`3@.!3
M`%0`4@.!!`$D`3@.!4`" `1@.!+`%\`1 !O`&,`=0!M`&4`;@.!T`%\`4P!A`&P`
M90!S`% `<@.!O`&H`90!C`'0`#0`*`$<`3P`-``H`#0`*`&D`9@.`@.`&4`> !I
M`',`= !S`" `* !S`&4`; !E`&,`= `@.`"H`( !F`'(`;P!M`" `9 !B`&\`
M+@.!S`'D`<P!O`&(`:@.!E`&,`= !S`" `=P!H`&4`<@.!E`" `:0!D`" `/0`@.
M`&\`8@.!J`&4`8P!T`%\`:0!D`"@.`3@.`G`%L`9 !B`&\`70`N`%L`1@.!+`%\`
M10!V`&4`;@.!T`%\`4P!A`&P`90!S`% `<@.!O`&H`90!C`'0`70`G`"D`( !A
M`&X`9 `@.`$\`0@.!*`$4`0P!4`% `4@.!/`% `10!2`%0`60`H`&D`9 `L`" `
M3@.`G`$D`<P!&`&\`<@.!E`&D`9P!N`$L`90!Y`"<`*0`@.`#T`( `Q`"D`#0`*
M`$$`3 !4`$4`4@.`@.`%0`00!"`$P`10`@.`%L`9 !B`&\`70`N`%L`10!V`&4`
M;@.!T`%T`( !$`%(`3P!0`" `0P!/`$X`4P!4`%(`00!)`$X`5 `@.`$8`2P!?
M`$4`=@.!E`&X`= !?`%,`80!L`&4`<P!0`'(`;P!J`&4`8P!T``T`"@.!'`$\`
M#0`*``T`"@.!I`&8`( !E`'@.`:0!S`'0`<P`@.`"@.`<P!E`&P`90!C`'0`( `J
M`" `9@.!R`&\`;0`@.`&0`8@.!O`"X`<P!Y`',`;P!B`&H`90!C`'0`< P`@.`'<`
M: !E`'(`90`@.`&D`9 `@.`#T`( !O`&(`:@.!E`&,`= !?`&D`9 `H`$X`)P!;
M`&0`8@.!O`%T`+@.!;`$8`2P!?`% `: !A`',`90!(`&D`<P!T`&\`<@.!Y`%\`
M4P!A`&P`90!S`% `<@.!O`&H`90!C`'0`70`G`"D`( !A`&X`9 `@.`$\`0@.!*
M`$4`0P!4`% `4@.!/`% `10!2`%0`60`H`&D`9 `L`" `3@.`G`$D`<P!&`&\`
M<@.!E`&D`9P!N`$L`90!Y`"<`*0`@.`#T`( `Q`"D`#0`*`$$`3 !4`$4`4@.`@.
M`%0`00!"`$P`10`@.`%L`9 !B`&\`70`N`%L`4 !H`&$`<P!E`$@.`:0!S`'0`
M;P!R`'D`70`@.`$0`4@.!/`% `( !#`$\`3@.!3`%0`4@.!!`$D`3@.!4`" `1@.!+
M`%\`4 !H`&$`<P!E`$@.`:0!S`'0`;P!R`'D`7P!3`&$`; !E`',`4 !R`&\`
M:@.!E`&,`= `-``H`1P!/``T`"@.`-``H`:0!F`" `90!X`&D`<P!T`',`( `H
M`',`90!L`&4`8P!T`" `*@.`@.`&8`<@.!O`&T`( !D`&(`;P`N`',`>0!S`&\`
M8@.!J`&4`8P!T`',`( !W`&@.`90!R`&4`( !I`&0`( `]`" `;P!B`&H`90!C
M`'0`7P!I`&0`* !.`"<`6P!D`&(`;P!=`"X`6P!&`$L`7P!R`&4`80!L`%\`
M90!S`'0`80!T`&4`7P!S`&$`; !E`',`< !R`&\`:@.!E`&,`= !=`"<`*0`@.
M`&$`;@.!D`" `3P!"`$H`10!#`%0`4 !2`$\`4 !%`%(`5 !9`"@.`:0!D`"P`
M( !.`"<`20!S`$8`;P!R`&4`:0!G`&X`2P!E`'D`)P`I`" `/0`@.`#$`*0`-
M``H`00!,`%0`10!2`" `5 !!`$(`3 !%`" `6P!D`&(`;P!=`"X`6P!2`&4`
M80!L`$4`<P!T`&$`= !E`%T`( !$`%(`3P!0`" `0P!/`$X`4P!4`%(`00!)
M`$X`5 `@.`$8`2P!?`'(`90!A`&P`7P!E`',`= !A`'0`90!?`',`80!L`&4`
M<P!P`'(`;P!J`&4`8P!T``T`"@.!'`$\`#0`*``T`"@.!I`&8`( !E`'@.`:0!S
M`'0`<P`@.`"@.`<P!E`&P`90!C`'0`( `J`" `9@.!R`&\`;0`@.`&0`8@.!O`"X`
M<P!Y`',`;P!B`&H`90!C`'0`<P`@.`'<`: !E`'(`90`@.`&D`9 `@.`#T`( !O
M`&(`:@.!E`&,`= !?`&D`9 `H`$X`)P!;`&0`8@.!O`%T`+@.!;`$8`2P!?`%,`
M>0!S`'0`90!M`$D`;@.!T`&4`9P!R`&$`= !I`&\`;@.!?`%,`80!L`&4`<P!0
M`'(`;P!J`&4`8P!T`%T`)P`I`" `80!N`&0`( !/`$(`2@.!%`$,`5 !0`%(`
M3P!0`$4`4@.!4`%D`* !I`&0`+ `@.`$X`)P!)`',`1@.!O`'(`90!I`&<`;@.!+
M`&4`>0`G`"D`( `]`" `,0`I``T`"@.!!`$P`5 !%`%(`( !4`$$`0@.!,`$4`
M( !;`&0`8@.!O`%T`+@.!;`%,`>0!S`'0`90!M`$D`;@.!T`&4`9P!R `&$`= !I
M`&\`;@.!=`" `1 !2`$\`4 `@.`$,`3P!.`%,`5 !2`$$`20!.`%0`( !&`$L`
M7P!3`'D`<P!T`&4`;0!)`&X`= !E`&<`<@.!A`'0`:0!O`&X`7P!3`&$`; !E
M`',`4 !R`&\`:@.!E`&,`= `-``H`1P!/``T`"@.`-``H`:0!F`" `90!X`&D`
M<P!T`',`( `H`',`90!L`&4`8P!T`" `*@.`@.`&8`<@.!O`&T`( !D`&(`;P`N
M`',`>0!S`&\`8@.!J`&4`8P!T`',`( !W`&@.`90!R`&4`( !I`&0`( `]`" `
M;P!B`&H`90!C`'0`7P!I`&0`* !.`"<`6P!D`&(`;P!=`"X`6P!&`$L`7P!8
M`%,`80!L`&4`<P!0`'(`;P!J`&4`8P!T`$,`;P!N`'0`80!C` '0`7P!3`&$`
M; !E`',`4 !R`&\`:@.!E`&,`= !=`"<`*0`@.`&$`;@.!D`" `3P!"`$H`10!#
M`%0`4 !2`$\`4 !%`%(`5 !9`"@.`:0!D`"P`( !.`"<`20!S`$8`;P!R`&4`
M:0!G`&X`2P!E`'D`)P`I`" `/0`@.`#$`*0`-``H`00!,`%0`10!2`" `5 !!
M`$(`3 !%`" `6P!D`&(`;P!=`"X`6P!8`%,`80!L`&4`<P!0`'(`;P!J`&4`
M8P!T`$,`;P!N`'0`80!C`'0`70`@.`$0`4@.!/`% `( !#`$\`3@.!3`%0`4@.!!
M`$D`3@.!4`" `1@.!+`%\`6 !3`&$`; !E`',`4 !R`&\`:@.!E`&,`= !#`&\`
M;@.!T`&$`8P!T`%\`4P!A`&P`90!S`% `<@.!O`&H`90!C`'0`#0`*`$<`3P`-
M``H`#0`*`&D`9@.`@.`&4`> !I`',`= !S`" `* !S`&4`; !E`&,`= `@.`"H`
M( !F`'(`;P!M`" `9 !B`&\`+@.!S`'D`<P!O`&(`:@.!E`&,`= !S`" `=P!H
M`&4`<@.!E`" `:0!D`" `/0`@.`&\`8@.!J`&4`8P!T`%\`:0!D`"@.`3@.`G`%L`
M9 !B`&\`70`N`%L`1@.!+`%\`4P!A`&P`90!S`% `<@.!O`&H`90!C`'0`7P!3
M`&$`; !E`',`4 !R`&\`:@.!E`&,`= !4`'D`< !E`%T`)P`I`" `80!N`&0`
M( !/`$(`2@.!%`$,`5 !0`%(`3P!0`$4`4@.!4`%D`* !I`&0`+ `@.`$X`)P!)
M`',`1@.!O`'(`90!I`&<`;@.!+`&4`>0`G`"D`( `]`" `,0`I``T`"@.!!`$P`
M5 !%`%(`( !4`$$`0@.!,`$4`( !;`&0`8@.!O`%T`+@.!;`%,`80!L`&4`<P!0
M`'(`;P!J`&4`8P!T`%T`( !$`%(`3P!0`" `0P!/`$X`4P!4`%(`00!)`$X`
M5 `@.`$8`2P!?`%,`80!L`&4`<P!0`'(`;P!J`&4`8P!T`%\`4P!A `&P`90!S
M`% `<@.!O`&H`90!C`'0`5 !Y`' `90`-``H`1P!/``T`"@.`-``H`:0!F`" `
M90!X`&D`<P!T`',`( `H`',`90!L`&4`8P!T`" `*@.`@.`&8`<@.!O`&T`( !D
M`&(`;P`N`',`>0!S`&\`8@.!J`&4`8P!T`',`( !W`&@.`90!R`&4`( !I`&0`
M( `]`" `;P!B`&H`90!C`'0`7P!I`&0`* !.`"<`6P!D`&(`;P!=`"X`6P!"
M`'4`:0!L`&0`:0!N`&<`70`G`"D`( !A`&X`9 `@.`$\`0@.!*`$4`0P!4`% `
M4@.!/`% `10!2`%0`60`H`&D`9 `L`" `3@.`G`$D`<P!5`',`90!R`%0`80!B
M`&P`90`G`"D`( `]`" `,0`I``T`"@.!D`'(`;P!P`" `= !A`&(`; !E`" `
M6P!D`&(`;P!=`"X`6P!"`'4`:0!L`&0`:0!N`&<`70`-``H`1P!/``T`"@.`-
M``H`:0!F`" `90!X`&D`<P!T`',`( `H`',`90!L`&4`8P!T`" `*@.`@.`&8`
M<@.!O`&T`( !D`&(`;P`N`',`>0!S`&\`8@.!J`&4`8P!T`',`( !W`&@.`90!R
M`&4`( !I`&0`( `]`" `;P!B`&H`90!C`'0`7P!I`&0`* !.`"<`6P!D`&(`
M;P!=`"X`6P!"`'4`:0!L`&0`:0!N`&<`5 !Y`' `90!=`"<`*0`@.`&$`;@.!D
M`" `3P!"`$H`10!#`%0`4 !2`$\`4 !%`%(`5 !9`"@.`:0!D`"P`( !.`"<`
M20!S`%4`<P!E`'(`5 !A`&(`; !E`"<`*0`@.`#T`( `Q`"D`#0`*`&0`<@.!O
M`' `( !T`&$`8@.!L`&4`( !;`&0`8@.!O`%T`+@.!;`$(`=0!I`&P`9 !I`&X`
M9P!4`'D`< !E`%T`#0`*`$<`3P`-``H`#0`*`&D`9@.`@.`&4`> !I`',`= !S
M`" `* !S`&4`; !E`&,`= `@.`"H`( !F`'(`;P!M`" `9 !B`&\`+@.!S`'D`
M<P!O`&(`:@.!E`&,`= !S`" `=P!H`&4`<@.!E`" `:0!D`" `/0`@.`&\`8@.!J
M`&4`8P!T`%\`:0!D`"@.`3@.`G`%L`9 !B`&\`70`N`%L`0P!O`&X`;@.!E`&,`
M= !I`&\`;@.!!`&0`9 !R`&4`<P!S`%T`)P`I`" `80!N`&0`( !/`$(`2@.!%
M`$,`5 !0`%(`3P!0`$4`4@.!4`%D`* !I`&0`+ `@.`$X`)P!)`',`50!S`&4`
M<@.!4`&$`8@.!L`&4`)P`I`" `/0`@.`#$`*0`-``H`9 !R`&\`< `@.`'0`80!B
M`&P`90`@.`%L`9 !B`&\`70`N`%L`0P!O`&X`;@.!E`&,`= !I`&\`;@.!!`&0`
M9 !R`&4`<P!S`%T`#0`*`$<`3P`-``H`#0`*`&D`9@.`@.`&4`> !I`',`= !S
M`" `* !S`&4`; !E`&,`= `@.`"H`( !F`'(`;P!M`" `9 !B`&\`+@.!S`'D`
M<P!O`&(`:@.!E`&,`= !S`" `=P!H`&4`<@.!E`" `:0!D`" `/0`@.`&\`8@.!J
M`&4`8P!T`%\`:0!D`"@.`3@.`G`%L`9 !B`&\`70`N`%L`0P!U`',`= !O`&T`
M90!R`%T`)P`I`" `80!N`&0`( !/`$(`2@.!%`$,`5 !0`%(`3P!0`$4`4@.!4
M`%D`* !I`&0`+ `@.`$X`)P!)`',`50!S`&4`<@.!4`&$`8@.!L`&4`)P`I`" `
M/0`@.`#$`*0`-``H`9 !R`&\`< `@.`'0`80!B`&P`90`@.`%L`9 !B`&\`70`N
M`%L`0P!U`',`= !O`&T`90!R`%T`#0`*`$<`3P`-``H`#0`*`&D`9@.`@.`&4`
M> !I`',`= !S`" `* !S`&4`; !E`&,`= `@.`"H`( !F`'(`;P!M`" `9 !B
M`&\`+@.!S`'D`<P!O`&(`:@.!E`&,`= !S`" `=P!H`&4`<@.!E`" `:0!D`" `
M/0`@.`&\`8@.!J`&4`8P!T`%\`:0!D`"@.`3@.`G`%L`9 !B`&\`70`N`%L`0P!U
M`',`= !O`&T`90!R`$(`=0!S`&D`;@.!E`',`<P!'`'(`;P!U`' `70`G`"D`
M( !A`&X`9 `@.`$\`0@.!*`$4`0P!4`% `4@.!/`% `10!2`%0`60`H`&D`9 `L
M`" `3@.`G`$D`<P!5`',`90!R`%0`80!B`&P`90`G`"D`( `]`" `,0`I``T`
M"@.!D`'(`;P!P`" `= !A`&(`; !E`" `6P!D`&(`;P!=`"X`6P!#`'4`<P!T
M`&\`;0!E`'(`0@.!U`',`:0!N`&4`<P!S`$<`<@.!O`'4`< !=``T`"@.!'`$\`
M#0`*``T`"@.!I`&8`( !E`'@.`:0!S`'0`<P`@.`"@.`<P!E`&P`90!C`'0`( `J
M`" `9@.!R`&\`;0`@.`&0`8@.!O`"X`<P!Y`',`;P!B`&H`90!C`'0`< P`@.`'<`
M: !E`'(`90`@.`&D`9 `@.`#T`( !O`&(`:@.!E`&,`= !?`&D`9 `H`$X`)P!;
M`&0`8@.!O`%T`+@.!;`$D`;@.!S`'0`80!L`&P`80!T`&D`;P!N` $$`9 !D`'(`
M90!S`',`70`G`"D`( !A`&X`9 `@.`$\`0@.!*`$4`0P!4`% `4@.!/`% `10!2
M`%0`60`H`&D`9 `L`" `3@.`G`$D`<P!5`',`90!R`%0`80!B`&P`90`G`"D`
M( `]`" `,0`I``T`"@.!D`'(`;P!P`" `= !A`&(`; !E`" `6P!D`&(`;P!=
M`"X`6P!)`&X`<P!T`&$`; !L`&$`= !I`&\`;@.!!`&0`9 !R`&4`<P!S`%T`
M#0`*`$<`3P`-``H`#0`*`&D`9@.`@.`&4`> !I`',`= !S`" `* !S`&4`; !E
M`&,`= `@.`"H`( !F`'(`;P!M`" `9 !B`&\`+@.!S`'D`<P!O`&(`:@.!E`&,`
M= !S`" `=P!H`&4`<@.!E`" `:0!D`" `/0`@.`&\`8@.!J`&4`8P!T`%\`:0!D
M`"@.`3@.`G`%L`9 !B`&\`70`N`%L`4@.!E`&$`; !%`',`= !A`'0`90!=`"<`
M*0`@.`&$`;@.!D`" `3P!"`$H`10!#`%0`4 !2`$\`4 !%`%(`5 !9`"@.`:0!D
M`"P`( !.`"<`20!S`%4`<P!E`'(`5 !A`&(`; !E`"<`*0`@.`#T`( `Q`"D`
M#0`*`&0`<@.!O`' `( !T`&$`8@.!L`&4`( !;`&0`8@.!O`%T`+@.!;`%(`90!A
M`&P`10!S`'0`80!T`&4`70`-``H`1P!/``T`"@.`-``H`:0!F`" `90!X`&D`
M<P!T`',`( `H`',`90!L`&4`8P!T`" `*@.`@.`&8`<@.!O`&T`( !D`&(`;P`N
M`',`>0!S`&\`8@.!J`&4`8P!T`',`( !W`&@.`90!R`&4`( !I`&0`( `]`" `
M;P!B`&H`90!C`'0`7P!I`&0`* !.`"<`6P!D`&(`;P!=`"X`6P!3`&$`; !E
M`',`4 !R`&\`:@.!E`&,`= !=`"<`*0`@.`&$`;@.!D`" `3P!"`$H`10!#`%0`
M4 !2`$\`4 !%`%(`5 !9`"@.`:0!D`"P`( !.`"<`20!S`%4`<P!E`'(`5 !A
M`&(`; !E`"<`*0`@.`#T`( `Q`"D`#0`*`&0`<@.!O`' `( !T`&$`8@.!L`&4`
M( !;`&0`8@.!O`%T`+@.!;`%,`80!L`&4`<P!0`'(`;P!J`&4`8P!T `%T`#0`*
M`$<`3P`-``H`#0`*`&D`9@.`@.`&4`> !I`',`= !S`" `* !S`&4`; !E`&,`
M= `@.`"H`( !F`'(`;P!M`" `9 !B`&\`+@.!S`'D`<P!O`&(`:@.!E`&,`= !S
M`" `=P!H`&4`<@.!E`" `:0!D`" `/0`@.`&\`8@.!J`&4`8P!T`%\`:0!D`"@.`
M3@.`G`%L`9 !B`&\`70`N`%L`4P!A`&P`90!S`% `<@.!O`&H`90!C`'0`5 !Y
M`' `90!=`"<`*0`@.`&$`;@.!D`" `3P!"`$H`10!#`%0`4 !2`$\`4 !%`%(`
M5 !9`"@.`:0!D`"P`( !.`"<`20!S`%4`<P!E`'(`5 !A`&(`; !E`"<`*0`@.
M`#T`( `Q`"D`#0`*`&0`<@.!O`' `( !T`&$`8@.!L`&4`( !;`&0`8@.!O`%T`
M+@.!;`%,`80!L`&4`<P!0`'(`;P!J`&4`8P!T`%0`>0!P`&4`7 0`-``H`1P!/
M``T`"@.`-``H`0P!2`$4`00!4`$4`( !4`$$`0@.!,`$4`( !;`&0`8@.!O`%T`
M+@.!;`$(`=0!I`&P`9 !I`&X`9P!=`" `* `-``H`"0!;`$(`=0!I`&P`9 !I
M`&X`9P!)`$0`70`@.`%L`:0!N`'0`70`@.`$D`1 !%`$X`5 !)`%0`60`@.`"@.`
M,0`L`" `,0`I`" `3@.!/`%0`( !.`%4`3 !,`" `+ `-``H`"0!;`$(`=0!I
M`&P`9 !I`&X`9P!.`&$`;0!E`%T`( !;`'8`80!R`&,`: !A`'(`70`@.`"@.`
M,0`P`# `*0`@.`$,`3P!,`$P`00!4`$4`( !&`&D`;@.!N`&D`<P!H`%\`4P!W
M`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L``T`"@.`)`%L`
M4@.!E`&$`; !%`',`= !A`'0`90!)`$0`70`@.`%L`:0!N`'0`70`@.`$X`50!,
M`$P`( `L``T`"@.`)`%L`0@.!U`&D`; !D`&D`;@.!G`$0`90!S`&,`<@.!I`' `
M= !I`&\`;@.!=`" `6P!V`&$`<@.!C`&@.`80!R`%T`( `H`#$`, `P`"D`( !#
M`$\`3 !,`$$`5 !%`" `1@.!I`&X`;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`
M7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`%,`;P!C`&L`90!T
M`$,`;P!U`&X`= !!`' `80!R`'0`;0!E`&X`= !S`%T`( !;`&D`;@.!T`%T`
M( !.`%4`3 !,`" `+ `-``H`"0!;`%,`;P!C`&L`90!T`$,`;P!U`&X`= !#
M`&\`;0!M`&4`<@.!C`&D`80!L`%T`( !;`&D`;@.!T`%T`( !.`%4`3 !,`" `
M+ `-``H`"0!;`%,`;P!C`&L`90!T`$,`;P!U`&X`= !.`&\`;@.!#`&\`;0!M
M`&4`<@.!C`&D`80!L`%T`( !;`&D`;@.!T`%T`( !.`%4`3 !,`" `+ `-``H`
M"0!;`$$`< !A`'(`= !M`&4`;@.!T`$8`; !O`&\`<@.!S`$,`;P!U`&X`= !=
M`" `6P!I`&X`= !=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!%`&X`= !R`&$`
M;@.!C`&4`0P!O`'4`;@.!T`%T`( !;`&D`;@.!T`%T`( !.`%4`3 !,`" `+ `-
M``H`"0!;`$,`;P!N`',`= !R`'4`8P!T`&D`;P!N`%D`90!A`'(`70`@.`%L`
M=@.!A`'(`8P!H`&$`<@.!=`" `* `T`"D`( !#`$\`3 !,`$$`5 !%`" `1@.!I
M`&X`;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.`%4`
M3 !,`" `+ `-``H`"0!;`$,`=0!L`'0`=0!R`&4`30!A`'(`:P!4`'D`< !E
M`$D`1 !=`" `6P!I`&X`= !=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!)`&X`
M<P!T`&$`; !L`&4`9 !,`&$`;@.!3`'0`80!T`&4`20!$`%T`( !;`&D`;@.!T
M`%T`( !.`%4`3 !,`" `+ `-``H`"0!;`$(`80!S`&4`;0!E`&X`= !3`'0`
M80!T`&4`20!$`%T`( !;`&D`;@.!T`%T`( !.`%4`3 !,`" `+ `-``H`"0!;
M`$$`= !T`&D`8P!3`'0`80!T`&4`20!$`%T`( !;`&D`;@.!T`%T`( !.`%4`
M3 !,`" `+ `-``H`"0!;`%,`: !E`&P`= !E`'(`4@.!O`&\`;0!=`" `6P!I
M`&X`= !=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!!`&P`= !E`'(`;@.!A`'0`
M:0!V`&4`0P!H`&$`;@.!N`&4`; !3`'0`80!T`&4`20!$`%T`( !;`&D`;@.!T
M`%T`( !.`%4`3 !,`" `+ `-``H`"0!;`%(`90!F`'4`<P!E`$,`: !U`'0`
M90!3`'0`80!T`&4`20!$`%T`( !;`&D`;@.!T`%T`( !.`%4`3 !,`" `+ `-
M``H`"0!;`$(`=0!I`&P`9 !I`&X`9P!4`'D`< !E`$D`1 !=`" `6P!I`&X`
M= !=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!&`&D`<@.!6`&$`; !I`&0`70`@.
M`%L`:0!N`'0`70`@.`$X`3P!4`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!)`',`
M00!C`'0`:0!V`&4`70`@.`%L`:0!N`'0`70`@.`$X`50!,`$P`( `L``T`"@.`)
M`%L`0P!R`&4`80!T`&4`9 !=`" `6P!D`&$`= !E`'0`:0!M`&4`70`@.`$X`
M50!,`$P`( `L``T`"@.`)`%L`50!P`&0`80!T`&4`9 !=`" `6P!D`&$`= !E
M`'0`:0!M`&4`70`@.`$X`50!,`$P`( `-``H`*0`@.`$\`3@.`@.`%L`4 !2`$D`
M30!!`%(`60!=``T`"@.!'`$\`#0`*``T`"@.!#`%(`10!!`%0`1 0`@.`%0`00!"
M`$P`10`@.`%L`9 !B`&\`70`N`%L`0@.!U`&D`; !D`&D`;@.!G`%0`>0!P`&4`
M70`@.`"@.`#0`*``D`6P!"`'4`:0!L`&0`:0!N`&<`5 !Y`' `90!)`$0`70`@.
M`%L`:0!N`'0`70`@.`$X`3P!4`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!"`'4`
M:0!L`&0`:0!N`&<`5 !Y`' `90!.`&$`;0!E`%T`( !;`'8`80!R`&,`: !A
M`'(`70`@.`"@.`-0`P`"D`( !#`$\`3 !,`$$`5 !%`" `1@.!I`&X`;@.!I`',`
M: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-
M``H`"0!;`$(`=0!I`&P`9 !I`&X`9P!4`'D`< !E`$0`90!S`&,`<@.!I`' `
M= !I`&\`;@.!=`" `6P!V`&$`<@.!C`&@.`80!R`%T`( `H`#(`-0`U`"D`( !#
M`$\`3 !,`$$`5 !%`" `1@.!I`&X`;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`
M7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`%,`;P!R`'0`3P!R
M`&0`90!R`%T`( !;`&D`;@.!T`%T`( !.`%4`3 !,`" `#0`*`"D`( !/`$X`
M( !;`% `4@.!)`$T`00!2`%D`70`-``H`1P!/``T`"@.`-``H`0P!2`$4`00!4
M`$4`( !4`$$`0@.!,`$4`( !;`&0`8@.!O`%T`+@.!;`$,`;P!N`&X`90!C`'0`
M:0!O`&X`00!D`&0`<@.!E`',`<P!=`" `* `-``H`"0!;`$,`;P!N`&X`90!C
M`'0`:0!O`&X`00!D`&0`<@.!E`',`<P!)`$0`70`@.`%L`:0!N` '0`70`@.`$D`
M1 !%`$X`5 !)`%0`60`@.`"@.`,0`L`" `,0`I`" `3@.!/`%0`( !.`%4`3 !,
M`" `+ `-``H`"0!;`%,`80!L`&4`<P!0`'(`;P!J`&4`8P!T`$D`1 !=`" `
M6P!I`&X`= !=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!3`'0`<@.!E`&4`= !=
M`" `6P!V`&$`<@.!C`&@.`80!R`%T`( `H`#$`, `P`"D`( !#`$\`3 !,`$$`
M5 !%`" `1@.!I`&X`;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!
M`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`%H`:0!P`$,`;P!D`&4`70`@.`%L`
M=@.!A`'(`8P!H`&$`<@.!=`" `* `Q`# `*0`@.`$,`3P!,`$P`00!4`$4`( !&
M`&D`;@.!N`&D`<P!H`%\`4P!W`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.`$X`
M50!,`$P`( `L``T`"@.`)`%L`0P!I`'0`>0!=`" `6P!V`&$`<@.!C`&@.`80!R
M`%T`( `H`#$`, `P`"D`( !#`$\`3 !,`$$`5 !%`" `1@.!I`&X`;@.!I`',`
M: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-
M``H`"0!;`%@.`8P!O`&\`<@.!D`&D`;@.!A`'0`90!=`" `6P!I`&X`= !=`" `
M3@.!5`$P`3 `@.`"P`#0`*``D`6P!9`&,`;P!O`'(`9 !I`&X`80!T`&4`70`@.
M`%L`:0!N`'0`70`@.`$X`50!,`$P`( `L``T`"@.`)`%L`00!D`&0`:0!T`&D`
M;P!N`&$`; !)`&X`9@.!O`'(`;0!A`'0`:0!O`&X`70`@.`%L`=@.!A`'(`8P!H
M`&$`<@.!=`" `* `V`# `, `P`"D`( !#`$\`3 !,`$$`5 !%`" `1@.!I`&X`
M;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.`%4`3 !,
M`" `+ `-``H`"0!;`$8`:0!R`%8`80!L`&D`9 !=`" `6P!I`&X`= !=`" `
M3@.!/`%0`( !.`%4`3 !,`" `+ `-``H`"0!;`%(`10!&`$X`4@.!=`" `6P!I
M`&X`= !=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!"`#(`00!D`'(`20!$`%T`
M( !;`&D`;@.!T`%T`( !.`%4`3 !,`" `+ `-``H`"0!;`% `;P!P`$X`80!M
M`&4`70`@.`%L`=@.!A`'(`8P!H`&$`<@.!=`" `* `Q`# `, `I`" `0P!/`$P`
M3 !!`%0`10`@.`$8`:0!N`&X`:0!S`&@.`7P!3`'<`90!D`&D`<P!H `%\`0P!)
M`%\`00!3`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!0`&\`< !$`&D`<P!T`&$`
M;@.!C`&4`70`@.`%L`=@.!A`'(`8P!H`&$`<@.!=`" `* `U`# `*0`@.`$,`3P!,
M`$P`00!4`$4`( !&`&D`;@.!N`&D`<P!H`%\`4P!W`&4`9 !I`',`: !?`$,`
M20!?`$$`4P`@.`$X`50!,`$P`( `L``T`"@.`)`%L`5 !E`&P`90!3`'0`80!T
M`&D`;P!N`$X`80!M`&4`70`@.`%L`=@.!A`'(`8P!H`&$`<@.!=` " `* `Q`# `
M, `I`" `0P!/`$P`3 !!`%0`10`@.`$8`:0!N`&X`:0!S`&@.`7P!3`'<`90!D
M`&D`<P!H`%\`0P!)`%\`00!3`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!4`&4`
M; !E`%,`= !A`'0`:0!O`&X`1 !I`',`= !A`&X`8P!E`%T`( !;`'8`80!R
M`&,`: !A`'(`70`@.`"@.`-0`P`"D`( !#`$\`3 !,`$$`5 !%`" `1@.!I`&X`
M;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.`%4`3 !,
M`" `+ `-``H`"0!;`$D`<P!!`&,`= !I`'8`90!=`" `6P!V`&$`<@.!C`&@.`
M80!R`%T`( `H`#4`, `I`" `0P!/`$P`3 !!`%0`10`@.`$8`:0!N`&X`:0!S
M`&@.`7P!3`'<`90!D`&D`<P!H`%\`0P!)`%\`00!3`" `3@.!5`$P`3 `@.`"P`
M#0`*``D`6P!#`'(`90!A`'0`90!D`%T`( !;`&0`80!T`&4`= !I`&T`90!=
M`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!5`' `9 !A`'0`90!D`%T`( !;`&0`
M80!T`&4`= !I`&T`90!=`" `3@.!5`$P`3 `@.``T`"@.`I`" `3P!.`" `6P!0
M`%(`20!-`$$`4@.!9`%T`#0`*`$<`3P`-``H`#0`*`$,`4@.!%`$$`5 !%`" `
M5 !!`$(`3 !%`" `6P!D`&(`;P!=`"X`6P!#`'4`<P!T`&\`;0!E`'(`70`@.
M`"@.`#0`*``D`6P!#`'4`<P!T`&\`;0!E`'(`20!$`%T`( !;`&D`;@.!T`%T`
M( !)`$0`10!.`%0`20!4`%D`( `H`#$`+ `@.`#$`*0`@.`$X`3P!4`" `3@.!5
M`$P`3 `@.`"P`#0`*``D`6P!#`'4`<P!T`&\`;0!E`'(`3@.!U`&T`8@.!E `'(`
M70`@.`%L`:0!N`'0`70`@.`$X`3P!4`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!0
M`&$`<@.!E`&X`= !#`'4`<P!T`&\`;0!E`'(`20!$`%T`( !;`&D`;@.!T`%T`
M( !.`%4`3 !,`" `+ `-``H`"0!;`$D`<P!0`&$`<@.!E`&X`= !=`" `6P!I
M`&X`= !=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!"`'(`80!N`&,`: !)`$0`
M70`@.`%L`:0!N`'0`70`@.`$X`50!,`$P`( `L``T`"@.`)`%L`0P!U`',`= !O
M`&T`90!R`$(`=0!S`&D`;@.!E`',`<P!'`'(`;P!U`' `20!$`%T`( !;`&D`
M;@.!T`%T`( !.`%4`3 !,`" `+ `-``H`"0!;`$,`=0!S`'0`;P!M`&4`<@.!.
M`&$`;0!E`%T`( !;`'8`80!R`&,`: !A`'(`70`@.`"@.`,@.`U`#4`*0`@.`$,`
M3P!,`$P`00!4`$4`( !&`&D`;@.!N`&D`<P!H`%\`4P!W`&4`9 !I`',`: !?
M`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L``T`"@.`)`%L`3P!R`&<`80!N`&D`
M<P!A`'0`:0!O`&X`3@.!U`&T`8@.!E`'(`70`@.`%L`=@.!A`'(`8 P!H`&$`<@.!=
M`" `* `R`# `*0`@.`$,`3P!,`$P`00!4`$4`( !&`&D`;@.!N`&D`<P!H`%\`
M4P!W`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L``T`"@.`)
M`%L`4P!T`'(`90!E`'0`70`@.`%L`=@.!A`'(`8P!H`&$`<@.!=` " `* `Q`# `
M, `I`" `0P!/`$P`3 !!`%0`10`@.`$8`:0!N`&X`:0!S`&@.`7P!3`'<`90!D
M`&D`<P!H`%\`0P!)`%\`00!3`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!3`'0`
M<@.!E`&4`= `R`%T`( !;`'8`80!R`&,`: !A`'(`70`@.`"@.`,0`P`# `*0`@.
M`$,`3P!,`$P`00!4`$4`( !&`&D`;@.!N`&D`<P!H`%\`4P!W`&4`9 !I`',`
M: !?`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L``T`"@.`)`%L`6@.!I`' `0P!O
M`&0`90!=`" `6P!V`&$`<@.!C`&@.`80!R`%T`( `H`#$`, `I`" `0P!/`$P`
M3 !!`%0`10`@.`$8`:0!N`&X`:0!S`&@.`7P!3`'<`90!D`&D`<P!H `%\`0P!)
M`%\`00!3`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!#`&D`= !Y`%T`( !;`'8`
M80!R`&,`: !A`'(`70`@.`"@.`,0`P`# `*0`@.`$,`3P!,`$P`00!4`$4`( !&
M`&D`;@.!N`&D`<P!H`%\`4P!W`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.`$X`
M50!,`$P`( `L``T`"@.`)`%L`4 !H`&\`;@.!E`$X`=0!M`&(`90!R`#$`70`@.
M`%L`=@.!A`'(`8P!H`&$`<@.!=`" `* `U`# `*0`@.`$,`3P!,`$P`00!4`$4`
M( !&`&D`;@.!N`&D`<P!H`%\`4P!W`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.
M`$X`50!,`$P`( `L``T`"@.`)`%L`4 !H`&\`;@.!E`$X`=0!M`&(`90!R`#(`
M70`@.`%L`=@.!A`'(`8P!H`&$`<@.!=`" `* `U`# `*0`@.`$,`3P!,`$P`00!4
M`$4`( !&`&D`;@.!N`&D`<P!H`%\`4P!W`&4`9 !I`',`: !?`$,`20!?`$$`
M4P`@.`$X`50!,`$P`( `L``T`"@.`)`%L`1@.!A`'@.`3@.!U`&T`8@.!E`'(`70`@.
M`%L`=@.!A`'(`8P!H`&$`<@.!=`" `* `U`# `*0`@.`$,`3P!,`$P`00!4`$4`
M( !&`&D`;@.!N`&D`<P!H`%\`4P!W`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.
M`$X`50!,`$P`( `L``T`"@.`)`%L`10!M`&$`:0!L`$$`9 !D`'(`90!S`',`
M70`@.`%L`=@.!A`'(`8P!H`&$`<@.!=`" `* `R`#4`-0`I`" `0P!/`$P`3 !!
M`%0`10`@.`$8`:0!N`&X`:0!S`&@.`7P!3`'<`90!D`&D`<P!H` %\`0P!)`%\`
M00!3`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!5`%(`3 !=`" `6P!V`&$`<@.!C
M`&@.`80!R`%T`( `H`#(`-0`U`"D`( !#`$\`3 !,`$$`5 !%`" `1@.!I`&X`
M;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.`%4`3 !,
M`" `+ `-``H`"0!;`% `80!R`$0`:0!V`&D`<P!I`&\`;@.!)`$0`70`@.`%L`
M=@.!A`'(`8P!H`&$`<@.!=`" `* `R`# `*0`@.`$,`3P!,`$P`00!4`$4`( !&
M`&D`;@.!N`&D`<P!H`%\`4P!W`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.`$X`
M50!,`$P`( `L``T`"@.`)`%L`00!D`&0`:0!T`&D`;P!N`&$`; !)`&X`9@.!O
M`'(`;0!A`'0`:0!O`&X`70`@.`%L`=@.!A`'(`8P!H`&$`<@.!=` " `* `X`# `
M, `P`"D`( !#`$\`3 !,`$$`5 !%`" `1@.!I`&X`;@.!I`',`: !?`%,`=P!E
M`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`$D`
M<P!!`&,`= !I`'8`90!=`" `6P!I`&X`= !=`" `3@.!5`$P`3 `@.`"P`#0`*
M``D`6P!#`'(`90!A`'0`90!D`%T`( !;`&0`80!T`&4`= !I`&T`90!=`" `
M3@.!5`$P`3 `@.`"P`#0`*``D`6P!5`' `9 !A`'0`90!D`%T`( !;`&0`80!T
M`&4`= !I`&T`90!=`" `3@.!5`$P`3 `@.``T`"@.`I`" `3P!.`" `6P!0`%(`
M20!-`$$`4@.!9`%T`#0`*`$<`3P`-``H`#0`*`$,`4@.!%`$$`5 !%`" `5 !!
M`$(`3 !%`" `6P!D`&(`;P!=`"X`6P!#`'4`<P!T`&\`;0!E`'(`0@.!U`',`
M:0!N`&4`<P!S`$<`<@.!O`'4`< !=`" `* `-``H`"0!;`$,`=0!S`'0`;P!M
M`&4`<@.!"`'4`<P!I`&X`90!S`',`1P!R`&\`=0!P`$D`1 !=`" `6P!I`&X`
M= !=`" `3@.!/`%0`( !.`%4`3 !,`" `+ `-``H`"0!;`$,`=0!S`'0`;P!M
M`&4`<@.!"`'4`<P!I`&X`90!S`',`1P!R`&\`=0!P`$X`80!M` &4`70`@.`%L`
M=@.!A`'(`8P!H`&$`<@.!=`" `* `U`# `*0`@.`$,`3P!,`$P`00!4`$4`( !&
M`&D`;@.!N`&D`<P!H`%\`4P!W`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.`$X`
M50!,`$P`( `L``T`"@.`)`%L`0P!U`',`= !O`&T`90!R`$(`=0!S`&D`;@.!E
M`',`<P!'`'(`;P!U`' `1 !E`',`8P!R`&D`< !T`&D`;P!N`%T`( !;`'8`
M80!R`&,`: !A`'(`70`@.`"@.`,@.`U`#4`*0`@.`$,`3P!,`$P`00!4`$4`( !&
M`&D`;@.!N`&D`<P!H`%\`4P!W`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.`$X`
M50!,`$P`( `L``T`"@.`)`%L`4P!O`'(`= !/`'(`9 !E`'(`70`@.`%L`:0!N
M`'0`70`@.`$X`50!,`$P`( `-``H`*0`@.`$\`3@.`@.`%L`4 !2`$D`30!!`%(`
M60!=``T`"@.!'`$\`#0`*``T`"@.!#`%(`10!!`%0`10`@.`%0`0 0!"`$P`10`@.
M`%L`9 !B`&\`70`N`%L`20!N`',`= !A`&P`; !A`'0`:0!O`&X`00!D`&0`
M<@.!E`',`<P!=`" `* `-``H`"0!;`$D`;@.!S`'0`80!L`&P`80!T`&D`;P!N
M`$$`9 !D`'(`90!S`',`20!$`%T`( !;`&D`;@.!T`%T`( !)`$0`10!.`%0`
M20!4`%D`( `H`#$`+ `@.`#$`*0`@.`$X`3P!4`" `3@.!5`$P`3 `@.`"P`#0`*
M``D`6P!"`'4`:0!L`&0`:0!N`&<`20!$`%T`( !;`&D`;@.!T`%T`( !.`%4`
M3 !,`" `+ `-``H`"0!;`$(`,@.!!`&0`<@.!)`$0`70`@.`%L`:0!N`'0`70`@.
M`$X`50!,`$P`( `L``T`"@.`)`%L`4P!T`'(`90!E`'0`70`@.`%L`=@.!A`'(`
M8P!H`&$`<@.!=`" `* `Q`# `, `I`" `0P!/`$P`3 !!`%0`10`@.`$8`:0!N
M`&X`:0!S`&@.`7P!3`'<`90!D`&D`<P!H`%\`0P!)`%\`00!3` " `3@.!5`$P`
M3 `@.`"P`#0`*``D`6P!:`&D`< !#`&\`9 !E`%T`( !;`'8`80!R`&,`: !A
M`'(`70`@.`"@.`,0`P`"D`( !#`$\`3 !,`$$`5 !%`" `1@.!I`&X`;@.!I`',`
M: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-
M``H`"0!;`$,`:0!T`'D`70`@.`%L`=@.!A`'(`8P!H`&$`<@.!=` " `* `Q`# `
M, `I`" `0P!/`$P`3 !!`%0`10`@.`$8`:0!N`&X`:0!S`&@.`7P!3`'<`90!D
M`&D`<P!H`%\`0P!)`%\`00!3`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!8`&,`
M;P!O`'(`9 !I`&X`80!T`&4`70`@.`%L`:0!N`'0`70`@.`$X`50!,`$P`( `L
M``T`"@.`)`%L`60!C`&\`;P!R`&0`:0!N`&$`= !E`%T`( !;`&D`;@.!T`%T`
M( !.`%4`3 !,`" `+ `-``H`"0!;`$8`:0!R`%8`80!L`&D`9 !=`" `6P!I
M`&X`= !=`" `3@.!/`%0`( !.`%4`3 !,`" `+ `-``H`"0!;`$D`<P!!`&,`
M= !I`'8`90!=`" `6P!I`&X`= !=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!#
M`'(`90!A`'0`90!D`%T`( !;`&0`80!T`&4`= !I`&T`90!=`" `3@.!5`$P`
M3 `@.`"P`#0`*``D`6P!5`' `9 !A`'0`90!D`%T`( !;`&0`80!T`&4`= !I
M`&T`90!=`" `3@.!5`$P`3 `@.``T`"@.`I`" `3P!.`" `6P!0`%(`20!-`$$`
M4@.!9`%T`#0`*`$<`3P`-``H`#0`*`$,`4@.!%`$$`5 !%`" `5 !!`$(`3 !%
M`" `6P!D`&(`;P!=`"X`6P!2`&4`80!L`$4`<P!T`&$`= !E`%T`( `H``T`
M"@.`)`%L`4@.!E`&$`; !%`',`= !A`'0`90!)`$0`70`@.`%L`:0!N`'0`70`@.
M`$D`1 !%`$X`5 !)`%0`60`@.`"@.`,0`L`" `,0`I`" `3@.!/`%0`( !.`%4`
M3 !,`" `+ `-``H`"0!;`%(`90!A`&P`10!S`'0`80!T`&4`3@.!A`&T`90!=
M`" `6P!V`&$`<@.!C`&@.`80!R`%T`( `H`#$`, `P`"D`( !#`$\`3 !,`$$`
M5 !%`" `1@.!I`&X`;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!
M`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`$8`3@.!2`%T`( !;`&D`;@.!T`%T`
M( !.`%4`3 !,`" `+ `-``H`"0!;`%,`80!L`&4`<P!P`'(`;P!J`&4`8P!T
M`$D`1 !=`" `6P!I`&X`= !=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!8`&,`
M;P!O`'(`9 !I`&X`80!T`&4`70`@.`%L`:0!N`'0`70`@.`$X`50!,`$P`( `L
M``T`"@.`)`%L`60!C`&\`;P!R`&0`:0!N`&$`= !E`%T`( !;`&D`;@.!T`%T`
M( !.`%4`3 !,`" `+ `-``H`"0!;`$8`:0!R`%8`80!L`&D`9 !=`" `6P!I
M`&X`= !=`" `3@.!/`%0`( !.`%4`3 !,`" `+ `-``H`"0!;`$D`<P!!`&,`
M= !I`'8`90!=`" `6P!I`&X`= !=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!#
M`'(`90!A`'0`90!D`%T`( !;`&0`80!T`&4`= !I`&T`90!=`" `3@.!5`$P`
M3 `@.`"P`#0`*``D`6P!5`' `9 !A`'0`90!D`%T`( !;`&0`80!T`&4`= !I
M`&T`90!=`" `3@.!5`$P`3 `@.``T`"@.`I`" `3P!.`" `6P!0`%(`20!-`$$`
M4@.!9`%T`#0`*`$<`3P`-``H`#0`*`$,`4@.!%`$$`5 !%`" `5 !!`$(`3 !%
M`" `6P!D`&(`;P!=`"X`6P!3`&$`; !E`',`4 !R`&\`:@.!E`&,`= !=`" `
M* `-``H`"0!;`%,`80!L`&4`<P!0`'(`;P!J`&4`8P!T`$D`1 !=`" `6P!I
M`&X`= !=`" `20!$`$4`3@.!4`$D`5 !9`" `* `Q`"P`( `Q`"D`( !.`$\`
M5 `@.`$X`50!,`$P`( `L``T`"@.`)`%L`4P!A`&P`90!S`% `<@.!O`&H`90!C
M`'0`3@.!U`&T`8@.!E`'(`70`@.`%L`:0!N`'0`70`@.`$X`50!,` $P`( `L``T`
M"@.`)`%L`4P!A`&P`90!S`% `<@.!O`&H`90!C`'0`3@.!A`&T`90!=`" `6P!V
M`&$`<@.!C`&@.`80!R`%T`( `H`#$`, `P`"D`( !#`$\`3 !,`$$`5 !%`" `
M1@.!I`&X`;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.
M`%4`3 !,`" `+ `-``H`"0!;`% `<@.!O`',`< !E`&,`= !3`&\`=0!R`&,`
M90!)`$0`70`@.`%L`:0!N`'0`70`@.`$X`50!,`$P`( `L``T`"@.`)`%L`0P!U
M`',`= !O`&T`90!R`$D`1 !=`" `6P!I`&X`= !=`" `3@.!/`%0`( !.`%4`
M3 !,`" `+ `-``H`"0!;`%,`80!L`&4`<P!0`'(`;P!J`&4`8P!T`%0`>0!P
M`&4`20!$`%T`( !;`&D`;@.!T`%T`( !.`%4`3 !,`" `+ `-``H`"0!;`% `
M: !A`',`90!)`$0`70`@.`%L`:0!N`'0`70`@.`$X`50!,`$P`( `L``T`"@.`)
M`%L`10!M`' `; !O`'D`90!E`$,`;P!U`&X`= !=`" `6P!I`&X`= !=`" `
M3@.!5`$P`3 `@.`"P`#0`*``D`6P!0`'(`;P!B`&$`8@.!I`&P`:0!T`'D`5@.!A
M`&P`=0!E`%T`( !;`&D`;@.!T`%T`( !.`%4`3 !,`" `+ `-``H`"0!;`% `
M<@.!O`&(`80!B`&D`; !I`'0`>0!!`&<`<@.!E`&4`;0!E`&X`= !$`&$`= !E
M`%T`( !;`&0`80!T`&4`= !I`&T`90!=`" `3@.!5`$P`3 `@.`"P`#0`*``D`
M6P!7`&$`;@.!T`&4`9 !)`%0`1 !A`'0`90!=`" `6P!D`&$`= !E`'0`:0!M
M`&4`70`@.`$X`50!,`$P`( `L``T`"@.`)`%L`3 !A`',`= !0`&\`<P!S`&D`
M8@.!L`&4`20!4`$0`80!T`&4`70`@.`%L`9 !A`'0`90!T`&D`;0!E`%T`( !.
M`%4`3 !,`" `+ `-``H`"0!;`%<`80!N`'0`90!D`%,`< !E`&4`9 !=`" `
M6P!F`&P`;P!A`'0`70`@.`$X`50!,`$P`( `L``T`"@.`)`%L`5P!A`&X`= !E
M`&0`20!0`$$`9 !D`'(`90!S`',`0P!O`'4`;@.!T`%T`( !;`&D`;@.!T`%T`
M( !.`%4`3 !,`" `+ `-``H`"0!;`$\`<@.!I`&\`;@.!0`'(`90!$`$T`,0!/
M`&8`9@.!E`'(`20!$`%T`( !;`&D`;@.!T`%T`( !.`%4`3 !,`" `+ `-``H`
M"0!;`$\`<@.!I`&\`;@.!0`&\`<P!T`$0`30`Q`$\`9@.!F`&4`< @.!)`$0`70`@.
M`%L`:0!N`'0`70`@.`$X`50!,`$P`( `L``T`"@.`)`%L`4P!A`&P`90!S`%(`
M90!S`' `;P!N`',`:0!B`&P`90!!`' `< !5`',`90!R`$D`1 !=`" `6P!I
M`&X`= !=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!!`&0`9 !I`'0`:0!O`&X`
M80!L`$D`;@.!F`&\`<@.!M`&$`= !I`&\`;@.!=`" `6P!V`&$`<@.!C`&@.`80!R
M`%T`( `H`#@.`, `P`# `*0`@.`$,`3P!,`$P`00!4`$4`( !&`&D`;@.!N`&D`
M<P!H`%\`4P!W`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L
M``T`"@.`)`%L`20!N`',`= !A`&P`; !A`'0`:0!O`&X`20!N`&8`;P!R`&T`
M80!T`&D`;P!N`%T`( !;`'8`80!R`&,`: !A`'(`70`@.`"@.`. `P`# `, `I
M`" `0P!/`$P`3 !!`%0`10`@.`$8`:0!N`&X`:0!S`&@.`7P!3`'<`90!D`&D`
M<P!H`%\`0P!)`%\`00!3`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!)`&X`=@.!O
M`&D`8P!E`%,`= !R`&4`90!T`%T`( !;`'8`80!R`&,`: !A`'(`70`@.`"@.`
M,0`P`# `*0`@.`$,`3P!,`$P`00!4`$4`( !&`&D`;@.!N`&D`<P!H`%\`4P!W
M`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L``T`"@.`)`%L`
M20!N`'8`;P!I`&,`90!3`'0`<@.!E`&4`= `R`%T`( !;`'8`80!R`&,`: !A
M`'(`70`@.`"@.`,0`P`# `*0`@.`$,`3P!,`$P`00!4`$4`( !&`&D`;@.!N`&D`
M<P!H`%\`4P!W`&4`9 !I`',`: !?`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L
M``T`"@.`)`%L`20!N`'8`;P!I`&,`90!:`&D`< !#`&\`9 !E`%T`( !;`'8`
M80!R`&,`: !A`'(`70`@.`"@.`,0`P`"D`( !#`$\`3 !,`$$`5 !%`" `1@.!I
M`&X`;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.`%4`
M3 !,`" `+ `-``H`"0!;`$D`;@.!V`&\`:0!C`&4`0P!I`'0`>0!=`" `6P!V
M`&$`<@.!C`&@.`80!R`%T`( `H`#$`, `P`"D`( !#`$\`3 !,`$$`5 !%`" `
M1@.!I`&X`;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.
M`%4`3 !,`" `+ `-``H`"0!;`$,`=0!R`'(`90!N`'0`20!3`% `3@.!A`&T`
M90!=`" `6P!V`&$`<@.!C`&@.`80!R`%T`( `H`#$`, `P`"D`( !#`$\`3 !,
M`$$`5 !%`" `1@.!I`&X`;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`7P!#`$D`
M7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`$,`=0!R`'(`90!N`'0`20!3
M`% `4P!P`&4`90!D`%T`( !;`&8`; !O`&$`= !=`" `3@.!5`$P`3 `@.`"P`
M#0`*``D`6P!#`'4`<@.!R`&4`;@.!T`$D`4P!0`%,`90!R`'8`: 0!C`&4`3@.!A
M`&T`90!=`" `6P!V`&$`<@.!C`&@.`80!R`%T`( `H`#$`, `P`"D`( !#`$\`
M3 !,`$$`5 !%`" `1@.!I`&X`;@.!I`',`: !?`%,`=P!E`&0`:0!S`&@.`7P!#
M`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`$,`=0!R`'(`90!N`'0`
M20!3`% `3@.!O`$\`9@.!)`% `00!D`&0`<@.!E`',`<P!E`',`70`@.`%L`:0!N
M`'0`70`@.`$X`50!,`$P`( `L``T`"@.`)`%L`0P!U`'(`<@.!E`&X`= !)`%,`
M4 !-`&\`;@.!T`&@.`; !Y`$8`90!E`%T`( !;`&D`;@.!T`%T`( !.`%4`3 !,
M`" `+ `-``H`"0!;`$,`=0!R`'(`90!N`'0`20!3`% `00!G`'(`90!E`&T`
M90!N`'0`10!N`&0`1 !A`'0`90!=`" `6P!D`&$`= !E`'0`:0!M`&4`70`@.
M`$X`50!,`$P`( `L``T`"@.`)`%L`20!S`$$`8P!T`&D`=@.!E`%T`( !;`&D`
M;@.!T`%T`( !.`%4`3 !,`" `+ `-``H`"0!;`$,`<@.!E`&$`= !E`&0`70`@.
M`%L`9 !A`'0`90!T`&D`;0!E`%T`( !.`%4`3 !,`" `+ `-``H`"0!;`%4`
M< !D`&$`= !E`&0`70`@.`%L`9 !A`'0`90!T`&D`;0!E`%T`( !.`%4`3 !,
M`" `#0`*`"D`( !/`$X`( !;`% `4@.!)`$T`00!2`%D`70`-``H`1P!/``T`
M"@.`-``H`0P!2`$4`00!4`$4`( !4`$$`0@.!,`$4`( !;`&0`8@.!O`%T`+@.!;
M`%,`80!L`&4`<P!0`'(`;P!J`&4`8P!T`%0`>0!P`&4`70`@.` "@.`#0`*``D`
M6P!3`&$`; !E`',`4 !R`&\`:@.!E`&,`= !4`'D`< !E`$D`1 !=`" `6P!I
M`&X`= !=`" `3@.!/`%0`( !.`%4`3 !,`" `+ `-``H`"0!;`%,`80!L`&4`
M<P!0`'(`;P!J`&4`8P!T`%0`>0!P`&4`3@.!A`&T`90!=`" `6P!V`&$`<@.!C
M`&@.`80!R`%T`( `H`#4`, `I`" `0P!/`$P`3 !!`%0`10`@.`$8`:0!N`&X`
M:0!S`&@.`7P!3`'<`90!D`&D`<P!H`%\`0P!)`%\`00!3`" `3@.!5`$P`3 `@.
M`"P`#0`*``D`6P!3`&$`; !E`',`4 !R`&\`:@.!E`&,`= !4`'D`< !E`$0`
M90!S`&,`<@.!I`' `= !I`&\`;@.!=`" `6P!V`&$`<@.!C`&@.`80!R`%T`( `H
M`#$`, `P`"D`( !#`$\`3 !,`$$`5 !%`" `1@.!I`&X`;@.!I`',`: !?`%,`
M=P!E`&0`:0!S`&@.`7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;
M`$(`80!S`&4`5 !Y`' `90!=`" `6P!I`&X`= !=`" `3@.!/`%0`( !.`%4`
M3 !,`" `+ `-``H`"0!;`%,`;P!R`'0`3P!R`&0`90!R`%T`( !;`&D`;@.!T
M`%T`( !.`%4`3 !,`" `#0`*`"D`( !/`$X`( !;`% `4@.!)`$T`00!2`%D`
270`-``H`1P!/``T`"@.`-``H`
`
end
|||can you post this in the microsoft.public.sqlserver.programming newsgroup
They will be better able to help you there. Your question does not appear to
be related to SQL FTS.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Henke" <henke_nord@.hotmail.com> wrote in message
news:%23IapG6W%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Hi, and thanks for your answer! Here is the query and a script that I hope
> can generate the parts of our database that is involved.
> SELECT TOP 20 dbo.SalesProject.SalesProjectID AS SPV_SalesProjectID,
> dbo.SalesProject.SalesProjectNumber AS SPV_SalesProjectNumber,
> dbo.SalesProject.SalesProjectName AS SPV_SalesProjectName,
> dbo.SalesProject.CustomerID AS SPV_CustomerID,
> dbo.SalesProject.SalesProjectTypeID AS SPV_SalesProjectTypeID,
> dbo.SalesProject.PhaseID AS SPV_PhaseID, dbo.Customer.CustomerID AS
> CV_CustomerID, dbo.Customer.CustomerNumber AS CV_CustomerNumber,
> dbo.Customer.CustomerName AS CV_CustomerName,
> dbo.Customer.CustomerBusinessGroupID AS CV_CustomerBusinessGroupID,
> dbo.Customer.OrganisationNumber AS CV_OrganisationNumber,
> dbo.Customer.Street AS CV_Street, dbo.Customer.ZipCode AS CV_ZipCode,
> dbo.Customer.City AS CV_City
> FROM dbo.Customer LEFT OUTER JOIN
> dbo.SalesProject ON dbo.Customer.CustomerID = dbo.SalesProject.CustomerID
> WHERE (dbo.SalesProject.SalesProjectID IN
> (SELECT SalesprojectID
> FROM RealEstate
> WHERE (RealEstateID IN
> (SELECT Building.RealestateID
> FROM Building
> WHERE BuildingID IN
> (SELECT BuildingID
> FROM InstallationAddress
> WHERE InstallationAddress.Street LIKE 'drottning%' AND
> Replace(InstallationAddress.ZipCode, ' ', '') LIKE '65224%' AND
> InstallationAddress.City LIKE 'karlstad%')))))
> OR(dbo.SalesProject.SalesProjectID IN
> (SELECT SalesProjectID
> FROM ConnectionAddress
> WHERE ConnectionAddress.Street LIKE 'drottning%' AND
> Replace(ConnectionAddress.ZipCode, ' ', '') LIKE '65224%' AND
> ConnectionAddress.City LIKE 'karlstad%'))
> /Henke
> "Hilary Cotter" <hilary.cotter@.gmail.com> skrev i meddelandet
> news:uBC7hnW%23EHA.2112@.TK2MSFTNGP14.phx.gbl...
>
>
|||Henke,
Could you post the output of the following SQL script as an attached .txt or
..rpt file as to understand pure T-SQL query performance issues that use
T-SQL LIKE (with no preceding wildcard in the search string), more
information is necessary to understand the SQL Server query optimizer's
selections. Note, the attached SQL table scripts do not indicate what
indexes are on each table:
use <your_database_name_here>
go
select @.@.version
select @.@.language
go
Set statistics profile on
Set statistics IO on
Set statistics time on
Go
-- your query here...
Set statistics profile off
Set statistics IO off
Set statistics time off
Go
SET SHOWPLAN_TEXT ON
go
-- your query here...
go
SET SHOWPLAN_TEXT OFF
GO
exec sp_help Customer
exec sp_help RealEstate
exec sp_help Building
exec sp_help InstallationAddress
exec sp_help ConnectionAddress
go
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Henke" <henke_nord@.hotmail.com> wrote in message
news:#IapG6W#EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Hi, and thanks for your answer! Here is the query and a script that I hope
> can generate the parts of our database that is involved.
> SELECT TOP 20 dbo.SalesProject.SalesProjectID AS SPV_SalesProjectID,
> dbo.SalesProject.SalesProjectNumber AS SPV_SalesProjectNumber,
> dbo.SalesProject.SalesProjectName AS SPV_SalesProjectName,
> dbo.SalesProject.CustomerID AS SPV_CustomerID,
> dbo.SalesProject.SalesProjectTypeID AS SPV_SalesProjectTypeID,
> dbo.SalesProject.PhaseID AS SPV_PhaseID, dbo.Customer.CustomerID AS
> CV_CustomerID, dbo.Customer.CustomerNumber AS CV_CustomerNumber,
> dbo.Customer.CustomerName AS CV_CustomerName,
> dbo.Customer.CustomerBusinessGroupID AS CV_CustomerBusinessGroupID,
> dbo.Customer.OrganisationNumber AS CV_OrganisationNumber,
> dbo.Customer.Street AS CV_Street, dbo.Customer.ZipCode AS CV_ZipCode,
> dbo.Customer.City AS CV_City
> FROM dbo.Customer LEFT OUTER JOIN
> dbo.SalesProject ON dbo.Customer.CustomerID = dbo.SalesProject.CustomerID
> WHERE (dbo.SalesProject.SalesProjectID IN
> (SELECT SalesprojectID
> FROM RealEstate
> WHERE (RealEstateID IN
> (SELECT Building.RealestateID
> FROM Building
> WHERE BuildingID IN
> (SELECT BuildingID
> FROM InstallationAddress
> WHERE InstallationAddress.Street LIKE 'drottning%' AND
> Replace(InstallationAddress.ZipCode, ' ', '') LIKE '65224%' AND
> InstallationAddress.City LIKE 'karlstad%')))))
> OR(dbo.SalesProject.SalesProjectID IN
> (SELECT SalesProjectID
> FROM ConnectionAddress
> WHERE ConnectionAddress.Street LIKE 'drottning%' AND
> Replace(ConnectionAddress.ZipCode, ' ', '') LIKE '65224%' AND
> ConnectionAddress.City LIKE 'karlstad%'))
> /Henke
> "Hilary Cotter" <hilary.cotter@.gmail.com> skrev i meddelandet
> news:uBC7hnW%23EHA.2112@.TK2MSFTNGP14.phx.gbl...
>
>

No comments:

Post a Comment