Showing posts with label number. Show all posts
Showing posts with label number. Show all posts

Friday, March 30, 2012

Problems with Timeout expired

Hi

I have a SQL Server database which has a number of tables and views. Using SQL Server Management Studio Express I can open most of the views without a problem. However, some of the views cause an SQL Connection Error but not every time I open them.

Error Source: Net SqlClient Data Provider

Error Message: Timeout expired. The timeout period expired ....

I have looked at the help given for this error but have come to the conclusion that none of the suggested causes are relevant as most views open without a problem. It would appear that I need to increase the timeout value but I can't find where I do that.

It must be simple..

I have just checked that the Execution Time-out in the SSMSE options is set to 0.

Monday, March 26, 2012

Problems with services not starting

We have a number of 6.5 servers on Windows NT and recently the AT jobs used
to start the services simply fail to run; they simply don't kick-in.
It is as if the internal Windows scheduler isn't running and as such the job
s don't run. It would be similar to the SQLExecutive (or SQLServer Agent ) s
ervice not being started which would mean that any tasks / jobs not being ru
n.
There is nothing in the Event logs or anywhere else.
something that I don't believe is a coincidence: we are currently in the pro
cess of a domain migration to Windows 2000 and we are in a situation where s
ome of our 6.5 servers have not been migrated to the new domain and are on t
he old Windows NT domain. T
wo 6.5 server that have been migrated to the new Windows 2000 domain do not
exhibit these problems.
Any ideas as to were I could look for this would be greatly appreciated.
Peter ApostolakopoulosPeter,
I thing you have better chance to get good suggestion in a NT/Windows forum
for this. It is probably something
with the scheduler service, possibly related to the service account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter Apostolakopoulos" <apostolp@.britannic.co.uk> wrote in message
news:6C55044B-35C1-40A5-86C1-B11698950444@.microsoft.com...
> We have a number of 6.5 servers on Windows NT and recently the AT jobs used to sta
rt the services simply
fail to run; they simply don't kick-in.
> It is as if the internal Windows scheduler isn't running and as such the jobs don'
t run. It would be similar
to the SQLExecutive (or SQLServer Agent ) service not being started which wo
uld mean that any tasks / jobs not
being run.
> There is nothing in the Event logs or anywhere else.
> something that I don't believe is a coincidence: we are currently in the process o
f a domain migration to
Windows 2000 and we are in a situation where some of our 6.5 servers have no
t been migrated to the new domain
and are on the old Windows NT domain. Two 6.5 server that have been migrated
to the new Windows 2000 domain do
not exhibit these problems.
> Any ideas as to were I could look for this would be greatly appreciated.
> Peter Apostolakopoulos|||Good idea Tibor.
Thanks,
Peter Apostolakopoulos

Problems with services not starting

We have a number of 6.5 servers on Windows NT and recently the AT jobs used to start the services simply fail to run; they simply don't kick-in
It is as if the internal Windows scheduler isn't running and as such the jobs don't run. It would be similar to the SQLExecutive (or SQLServer Agent ) service not being started which would mean that any tasks / jobs not being run
There is nothing in the Event logs or anywhere else
something that I don't believe is a coincidence: we are currently in the process of a domain migration to Windows 2000 and we are in a situation where some of our 6.5 servers have not been migrated to the new domain and are on the old Windows NT domain. Two 6.5 server that have been migrated to the new Windows 2000 domain do not exhibit these problems
Any ideas as to were I could look for this would be greatly appreciated
Peter ApostolakopoulosPeter,
I thing you have better chance to get good suggestion in a NT/Windows forum for this. It is probably something
with the scheduler service, possibly related to the service account.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter Apostolakopoulos" <apostolp@.britannic.co.uk> wrote in message
news:6C55044B-35C1-40A5-86C1-B11698950444@.microsoft.com...
> We have a number of 6.5 servers on Windows NT and recently the AT jobs used to start the services simply
fail to run; they simply don't kick-in.
> It is as if the internal Windows scheduler isn't running and as such the jobs don't run. It would be similar
to the SQLExecutive (or SQLServer Agent ) service not being started which would mean that any tasks / jobs not
being run.
> There is nothing in the Event logs or anywhere else.
> something that I don't believe is a coincidence: we are currently in the process of a domain migration to
Windows 2000 and we are in a situation where some of our 6.5 servers have not been migrated to the new domain
and are on the old Windows NT domain. Two 6.5 server that have been migrated to the new Windows 2000 domain do
not exhibit these problems.
> Any ideas as to were I could look for this would be greatly appreciated.
> Peter Apostolakopoulos|||Good idea Tibor
Thanks
Peter Apostolakopoulos

Problems with services not starting

We have a number of 6.5 servers on Windows NT and recently the AT jobs used to start the services simply fail to run; they simply don't kick-in.
It is as if the internal Windows scheduler isn't running and as such the jobs don't run. It would be similar to the SQLExecutive (or SQLServer Agent ) service not being started which would mean that any tasks / jobs not being run.
There is nothing in the Event logs or anywhere else.
something that I don't believe is a coincidence: we are currently in the process of a domain migration to Windows 2000 and we are in a situation where some of our 6.5 servers have not been migrated to the new domain and are on the old Windows NT domain. T
wo 6.5 server that have been migrated to the new Windows 2000 domain do not exhibit these problems.
Any ideas as to were I could look for this would be greatly appreciated.
Peter Apostolakopoulos
Peter,
I thing you have better chance to get good suggestion in a NT/Windows forum for this. It is probably something
with the scheduler service, possibly related to the service account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter Apostolakopoulos" <apostolp@.britannic.co.uk> wrote in message
news:6C55044B-35C1-40A5-86C1-B11698950444@.microsoft.com...
> We have a number of 6.5 servers on Windows NT and recently the AT jobs used to start the services simply
fail to run; they simply don't kick-in.
> It is as if the internal Windows scheduler isn't running and as such the jobs don't run. It would be similar
to the SQLExecutive (or SQLServer Agent ) service not being started which would mean that any tasks / jobs not
being run.
> There is nothing in the Event logs or anywhere else.
> something that I don't believe is a coincidence: we are currently in the process of a domain migration to
Windows 2000 and we are in a situation where some of our 6.5 servers have not been migrated to the new domain
and are on the old Windows NT domain. Two 6.5 server that have been migrated to the new Windows 2000 domain do
not exhibit these problems.
> Any ideas as to were I could look for this would be greatly appreciated.
> Peter Apostolakopoulos
|||Good idea Tibor.
Thanks,
Peter Apostolakopoulos
sql

Monday, March 12, 2012

Problems with joins

I'm having trouble with joins...

TableA includes the fields name, order_number and value1.
Tableb includes the fields order number and value2

I'm joining on Order Number.
I want to return Name, TableA.order_number, TableB.order_number, value1
and value2.

I want to return all order_numbers from TableA and any from TableB that
are in TableA.

My script currently has TableA LEFT OUTER JOIN TableB On
TableA.order_number = TableB.order_number

I know it is incorrect because the sum of TableA.Value1 is 100, but
after my left outer join with TableB the sum of Value1 is 50.

Any ideas?

Regards,
CiarnOn 12 Apr 2005 09:38:44 -0700, chudson007@.hotmail.com wrote:

>I'm having trouble with joins...
>TableA includes the fields name, order_number and value1.
>Tableb includes the fields order number and value2
>I'm joining on Order Number.
>I want to return Name, TableA.order_number, TableB.order_number, value1
>and value2.
>I want to return all order_numbers from TableA and any from TableB that
>are in TableA.
>My script currently has TableA LEFT OUTER JOIN TableB On
>TableA.order_number = TableB.order_number
>I know it is incorrect because the sum of TableA.Value1 is 100, but
>after my left outer join with TableB the sum of Value1 is 50.
>Any ideas?
>Regards,
>Ciarn

Hi Ciarn,

Can you post the complete query, please? Even better would be if you
include the DDL (CREATE TABLE statements) for the tables as well,
preferably including some sample data (posted as INSERT statements).

That will allow us to review your code, run some tests and come up with
a suggestion.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)|||Here is the script

The sum of Shpt_Leg_List_CLC changes between Script1 and Script2 and
the only change I think I have made is the join to TableB

Script1
SELECT Customer_Number AS Customer_Number, ID_Code AS ID_Code,
LEFT(Ship_Day, 4) AS Ship_Month, SUM(Shpt_Leg_List_CLC) AS
Shpt_Leg_List_CLC,
SUM(Shpt_Leg_Net_CLC) AS Shpt_Leg_Net_CLC,
SUM(Shpt_Leg_List_LC) AS Shpt_Leg_List_LC, SUM(Shpt_Leg_Net_LC) AS
Shpt_Leg_Net_LC,
SUM(Shpt_Leg_Ref_List) AS Shpt_Leg_Ref_List,
SUM(Shpt_Leg_Ref_Net) AS Shpt_Leg_Ref_Net, SUM(Shpt_Leg_Prod_Units) AS
Shpt_Leg_Prod_Units,
SUM(Shpt_Leg_Optn_Units) AS Shpt_Leg_Optn_Units,
SUM(Shpt_Leg_Supt_Units) AS Shpt_Leg_Supt_Units,
Shpt_Leg_MCC_Units AS Shpt_Leg_MCC_Units,
Department, Misc_Charge_Code AS TableA_DataV1, Order_Section
INTO TableA_DataV2
FROM TableA
GROUP BY Customer_Number, ID_Code, LEFT(Ship_Day, 4),
Shpt_Leg_MCC_Units, Department, Misc_Charge_Code, Order_Section
ORDER BY LEFT(Ship_Day, 4), Customer_Number, ID_Code, Department,
Shpt_Leg_MCC_Units, Misc_Charge_Code

Script2
SELECT TableA.Customer_Number AS Customer_Number, TableA.ID_Code AS
ID_Code,
LEFT(TableA.Ship_Day, 4) AS Ship_Month,
SUM(TableA.Shpt_Leg_List_CLC) AS Shpt_Leg_List_CLC,
SUM(TableA.Shpt_Leg_Net_CLC) AS Shpt_Leg_Net_CLC,
SUM(TableA.Shpt_Leg_List_LC)
AS Shpt_Leg_List_LC, SUM(TableA.Shpt_Leg_Net_LC)
AS Shpt_Leg_Net_LC,
SUM(TableA.Shpt_Leg_Ref_List) AS
Shpt_Leg_Ref_List, SUM(TableA.Shpt_Leg_Ref_Net)
AS Shpt_Leg_Ref_Net,
SUM(TableA.Shpt_Leg_Prod_Units) AS Shpt_Leg_Prod_Units,
SUM(TableA.Shpt_Leg_Optn_Units) AS
Shpt_Leg_Optn_Units, SUM(TableA.Shpt_Leg_Supt_Units)
AS Shpt_Leg_Supt_Units, TableA.Shpt_Leg_MCC_Units
AS Shpt_Leg_MCC_Units, TableA.Department,
TableA.Misc_Charge_Code AS TableA_DataV1,
TableA.Order_Section,
TableB.Sales_Order_Number
INTO TableA_DataV2
FROM TableA LEFT OUTER JOIN
TableB ON TableA.Order_Section =
TableB.Sales_Order_Number
GROUP BY TableA.Customer_Number, TableA.ID_Code, LEFT(TableA.Ship_Day,
4),
TableA.Shpt_Leg_MCC_Units, TableA.Department,
TableA.Misc_Charge_Code, TableA.Order_Section,
TableB.Sales_Order_Number
ORDER BY LEFT(TableA.Ship_Day, 4), TableA.Customer_Number,
TableA.ID_Code,
TableA.Department, TableA.Shpt_Leg_MCC_Units,
TableA.Misc_Charge_Code|||On 13 Apr 2005 01:37:09 -0700, chudson007@.hotmail.com wrote:

>Here is the script
>
>The sum of Shpt_Leg_List_CLC changes between Script1 and Script2 and
>the only change I think I have made is the join to TableB
(snip)

Hi Ciarn,

Does only the sum of Shpt_Leg_List_CLC change, or do all the other sums
change as well?

Did you factor in that the total from one group in query 1 may be
divided over several groups in query 2, due to the extra column in the
GROUP BY clause (TableB.Sales_Order_Number)?

Are you sure that the total from query 1 is HIGHER than the total from
query 2? I could explain a LOWER total, not a HIGHER total!

I see no obvious problems with the code you posted. If you want me to
investigate this further, you'll really have to poste CREATE TABLE and
INSERT statements as well, so that I can reproduce the problem on my
computer.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

Problems with groupings on Reporting Services 2005

Dear people,
I have a problem with a report where users want to see transacctions grouped by Account number and type(e.g: incomes and payments).

And so I use a table object where I put 2 groups:
1) Group by Account Number: Field!Account.Value
2) Group by Transaction Type: Field!Type.Value
I put in the detaill row group by: Field!Type.Value and Field!Account.Value.

When I execute the report only show the first row per transaction type, but the dataset has some rows per transaction type.

Please help me with this problem, thanks...

Sounds like you don't need a detail row group.

Friday, March 9, 2012

Problems with droping and creating tables

Hi
The case:
User execute a bat file that executes a sql script. This script drops a
number of tables, generate new tables and fills the new tables with data.
The problem:
The new tables that's created is created with the user executing the scripts
as owner, not dbo. Initially dbo was owner of the tables that where dropped.
The user is member of a a.d security group that is granted as a login on the
SQL server, and is dbo on the database in question.
If we run the script from a user that is member of the local admin group on
the server, SQL server sysadmin and dbo on the database, dbo is owner of the
new tables.
How can I resolve this issue? When the script is executed by the user I want
dbo to be owner of the table, specially since the user is member of a group
that is dbo on the specific database.
/A.What version of SQL Server?
If 2005, then specify the desired schema for the user in question.
If 2000, then make sure that your users specify the apropriate owner when they create the table, as
in:
CREATE TABLE dbo.myTable(...)
Also, just fyi (a remark about terminology):
> The user is member of a a.d security group that is granted as a login on the SQL server, and is
> dbo on the database in question.
Only one login can be the dbo. Other logins can have users who in the database have the db_owner
role, whcih gives the same permission as dbo has.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Andy.I" <Andy.I@.community.nospam> wrote in message
news:44DA00F1-BEA7-49CE-B7A5-E23D79077293@.microsoft.com...
> Hi
> The case:
> User execute a bat file that executes a sql script. This script drops a number of tables, generate
> new tables and fills the new tables with data.
> The problem:
> The new tables that's created is created with the user executing the scripts as owner, not dbo.
> Initially dbo was owner of the tables that where dropped.
> The user is member of a a.d security group that is granted as a login on the SQL server, and is
> dbo on the database in question.
> If we run the script from a user that is member of the local admin group on the server, SQL server
> sysadmin and dbo on the database, dbo is owner of the new tables.
> How can I resolve this issue? When the script is executed by the user I want dbo to be owner of
> the table, specially since the user is member of a group that is dbo on the specific database.
> /A.|||Thanks
I'll give it a try.
/A
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OMYDKMLEIHA.3548@.TK2MSFTNGP06.phx.gbl...
> What version of SQL Server?
> If 2005, then specify the desired schema for the user in question.
> If 2000, then make sure that your users specify the apropriate owner when
> they create the table, as in:
> CREATE TABLE dbo.myTable(...)
>
> Also, just fyi (a remark about terminology):
>> The user is member of a a.d security group that is granted as a login on
>> the SQL server, and is dbo on the database in question.
> Only one login can be the dbo. Other logins can have users who in the
> database have the db_owner role, whcih gives the same permission as dbo
> has.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Andy.I" <Andy.I@.community.nospam> wrote in message
> news:44DA00F1-BEA7-49CE-B7A5-E23D79077293@.microsoft.com...
>> Hi
>> The case:
>> User execute a bat file that executes a sql script. This script drops a
>> number of tables, generate new tables and fills the new tables with data.
>> The problem:
>> The new tables that's created is created with the user executing the
>> scripts as owner, not dbo. Initially dbo was owner of the tables that
>> where dropped.
>> The user is member of a a.d security group that is granted as a login on
>> the SQL server, and is dbo on the database in question.
>> If we run the script from a user that is member of the local admin group
>> on the server, SQL server sysadmin and dbo on the database, dbo is owner
>> of the new tables.
>> How can I resolve this issue? When the script is executed by the user I
>> want dbo to be owner of the table, specially since the user is member of
>> a group that is dbo on the specific database.
>> /A.
>

Wednesday, March 7, 2012

Problems with cursor and update where current of

I'm having a problem ... obviously or I wouldn't be here. Anyway ... There is a table containing a line number field (called ln_num) that needs to be renumbered based on the order of other certain fields for certain accounts. The table in question is called parcel_rel and here are the fields:

strap varchar(13); ln_num int; tp varchar(2); rel_strap varchar(13)

PKey is on strap, ln_num

I load into a "temp" table the accounts that need renumbering (called renum_parcel_rel_table) and on this particular run, I have only one: strap = 0935310000111, which has two records (one with tp=TB and another with tp=PA. Here is the code that I am using. It ran PERFECTLY on SQL2000, but since we upgraded to SQL2005, it gets caught in a loop -- thus the reason for me posting this question.

set nocount on

declare @.strap varchar (13) ,
@.old_strap varchar (13) ,
@.ln_num int ,
@.c_ln_num int ,
@.tp varchar (10) ,
@.rel_strap varchar (13)

declare cRecords__parcel_rel cursor for
select r.strap, ln_num, tp, rel_strap
from r_2006..parcel_rel r
join h_2006..renum_parcel_rel_table h
on r.strap = h.strap
order by r.strap, tp, rel_strap
for update of ln_num

set @.old_strap = ''

open cRecords__parcel_rel
fetch next from cRecords__parcel_rel into @.strap, @.c_ln_num, @.tp, @.rel_strap

while (@.@.FETCH_STATUS = 0) begin

print 'pre-update: @.strap = ' + @.strap + ' @.c_ln_num = ' + cast(@.c_ln_num as varchar(10)) + ' @.tp = ' + @.tp + ' @.rel_strap = ' + @.rel_strap
if @.strap = @.old_strap begin
set @.ln_num = @.ln_num + 1
end else begin
set @.ln_num = 1
set @.old_strap = @.strap
end
update r_2006..parcel_rel
set ln_num = @.ln_num
where current of cRecords__parcel_rel -- key to it all!!!!!

print 'updated ln_num to: @.ln_num = ' + cast(@.ln_num as varchar(10))
fetch next from cRecords__parcel_rel into @.strap, @.c_ln_num, @.tp, @.rel_strap
print '@.@.FETCH_STATUS = ' + cast(@.@.FETCH_STATUS as varchar(10))
end

close cRecords__parcel_rel
deallocate cRecords__parcel_rel

set nocount off

The problem is that I get output like this and the loop never dies (@.@.fetch_status bolded for reference):

pre-update: @.strap = 0935310000111 @.c_ln_num = 1661 @.tp = PA @.rel_strap = 0935310000110
updated ln_num to: @.ln_num = 1
@.@.FETCH_STATUS = 0
pre-update: @.strap = 0935310000111 @.c_ln_num = 1662 @.tp = TB @.rel_strap = 0935310000110
updated ln_num to: @.ln_num = 2
@.@.FETCH_STATUS = 0
pre-update: @.strap = 0935310000111 @.c_ln_num = 1 @.tp = PA @.rel_strap = 0935310000110
updated ln_num to: @.ln_num = 3
@.@.FETCH_STATUS = 0
pre-update: @.strap = 0935310000111 @.c_ln_num = 2 @.tp = TB @.rel_strap = 0935310000110
updated ln_num to: @.ln_num = 4
@.@.FETCH_STATUS = 0
pre-update: @.strap = 0935310000111 @.c_ln_num = 3 @.tp = PA @.rel_strap = 0935310000110
updated ln_num to: @.ln_num = 5
@.@.FETCH_STATUS = 0
pre-update: @.strap = 0935310000111 @.c_ln_num = 4 @.tp = TB @.rel_strap = 0935310000110
updated ln_num to: @.ln_num = 6
@.@.FETCH_STATUS = 0
.... etc

As you can see, even though this account has only two entries in the parcel_rel table (one tp=PA and one tp=TB) the cursor keeps getting a @.@.fetch_status = 0 even after the last (second) record is passed.

Interestingly enough, if I remove (comment out) the update...where current of portion of the code, look:

pre-update: @.strap = 0935310000111 @.c_ln_num = 1883 @.tp = PA @.rel_strap = 0935310000110
updated ln_num to: @.ln_num = 1
@.@.FETCH_STATUS = 0
pre-update: @.strap = 0935310000111 @.c_ln_num = 1884 @.tp = TB @.rel_strap = 0935310000110
updated ln_num to: @.ln_num = 2
@.@.FETCH_STATUS = -1

Notice that after the second record is read in and processed, and the following fetch next is executed, @.@.FETCH_STATUS correctly returns a -1. Is the update...where current of causing the cursor to revert back to the first record, or causing the following fetch next to function like a fetch first? I'm puzzled that this functionality would so greatly change between SQL2000 and SQL2005.

Any comments would be greatly appreciated. And if you could also email replies or notification of replies to bscrivener@.hcad.org I would greatly appreciate that, too.

Thanks in advance!

Your cursor problem (other than using a cursor :)) is probably due to the cursor not being static. I think changing to a fast_forward or static cursor will fix your problem. However, it would be far easier to use the new row_number function to do the reorder. Here is a sample:

create table orderMe
(
orderMeId int primary key,
groupName varchar(10),
value varchar(20),
orderBy int,
unique(groupName, value)
)
insert into orderMe
select 1,'beatles','john',10
union all
select 2,'beatles','paul',12
union all
select 3,'beatles','george',12
union all
select 4,'beatles','ringo',12
union all
select 5,'rat pack','frank',1
union all
select 6,'rat pack','sam',50
union all
select 7,'rat pack','dean',1
go
update orderMe
set orderBy = orderUs.newOrderMeId
from orderMe
join (select orderMeId,
row_number() over (partition by groupName order by value) as newOrderMeId
from orderMe) as orderUs
on orderMe.orderMeId = orderUs.orderMeId
go
select *
from orderMe

Now the orderBy column is order by their name... Much easier than a cursor (and likely a lot faster)

orderMeId groupName value orderBy
-- - -- --
1 beatles john 2
2 beatles paul 3
3 beatles george 1
4 beatles ringo 4
5 rat pack frank 2
6 rat pack sam 3
7 rat pack dean 1

|||

You can simplify the UPDATE statement by using a CTE like:

with o
as
(
select orderBy, row_number() over (partition by groupName order by value) as newOrderMeId
from orderMe
)
update o
set orderBy =newOrderMeId;

|||You gotta admire the work. Nice.|||Oooh, cool. Very nice...

Saturday, February 25, 2012

Problems with Aggregate Expressions using Scope

Hi, I'm having the following problem when creating a matrix report. I'm trying to get the number of companies contacted per person to display in each cell. I have 3 group rows,

The first group, grpPerson =Fields!PersonID.Value
The second, grpCompany =Fields!CompanyID.Value with parent group = grpPerson
The thrid, grpOffice =Fields!OfficeID.Value with parent group = grpCompany

I have spent numerous hours trying different combinations of adding row groups, adding column groups, tried every possible combenation of aggregate functions, and scops, each give me different results, neither of them are what I am expecting.
Below is an example output of the following expression that I have in my data cell:
=Count(Fields!PersonID.Value, ("grpCompany")

My expected result is the number of rows per person, for the company for each month. i.e person1 called company1 5 times in the month of Feb. So each office should show the same some in the Month of Feb06. I will use this sum later to get the percentage of offices that the person called each month, and this count will alow me to do that.

However, the result below is what's being displayed. It appears the show, in the top row for each company, the number of companies the person called, not filtered by month. Then for the other rows of the company, it's showing the total number of rows returned from the whole dataset. I have tried just about every aggregate function possible. Any help to solve this problem would be great! Thanks!

Feb06 | Mar06 | Apr06 | Total
person1 | company1 | office1 20 20 20 500
| office2 500 500 500 500
| office3 500 500 500 500
person2 | company1 | office1 15 15 15 500
| office2 500 500 500 500
| office3 500 500 500 500

I’m also trying to do this using one dataset without using an aggregate within the SQL query that returns the number of times a person contacted a company each month because it significantly slows it down. I'm trying to do this all within reporting services. Any help to solve this problem would be great! Thanks!
Have you tried just =Count(Fields!PersonID.Value)? When you specify a explicit scope in the aggregate, e.g. grpCompany, it will return the sum for that group, regardless of the month in this case.|||Yes, I have tried Count(Fields!PersonID.Value), and it will give me the correct sum for the specific office of the company for the month, not the company count as a whole for the month. Is this even possible?
|||In that case, you can add a subtotal to the Office row group (right click on the row group and select subtotal). Then in the cells under the subtotal row, you should get the company count for the month.|||Thanks for your help so far, but that will give me the total number of office rows in the query. I'm looking to retrieve the number of rows the query returned per person. ie. person1 had 5 companies, person2 had 15 companies ect.

In addition I would like each cell for the person to be able to display the total value. Once I can do that I will be able to divide the total number of person calls by the number of times a person called an office,

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...
>
>

Monday, February 20, 2012

Problems using TOP and User Functions

Hi! I'm trying to create an User Defined function that gives me the top rows
of a table. I must be able to define wich is the top number of rows to be r
eturned. I assume I could do this:
CREATE FUNCTION ListTopRegions (@.reg_id int, @.num int)
RETURNS @.table table ([TerritoryID] [nvarchar] (20), [TerritoryDescription] [nchar] (50))
AS
begin
if exists (select 1 from Region where RegionID = @.reg_id)
begin
insert into @.table select top @.num TerritoryID, TerritoryDescription from Te
rritories
where RegionID=@.reg_id
end
return
end
but it keeps saying : Incorrect syntax near '@.num'. Any idea what I'm doing
wrong? I'm using the Northwing DB, and I intend to get the first 5 entries,
for instance.You have to use a hard-coded value in a TOP clause in SQL Server 2000.
You'll be able to use expressions in SQL Server 2005. You didn't say what
determines the order. For example, is it the TOP (n) sorted by TerritoryID?
In that case, try:
select
o.TerritoryID
, o.TerritoryDescription
from
Territories o
join
Territories i on i.TerritoryID <= o.TerritoryID
and i.RegionID = o.RegionID
where
o.RegionID = @.reg_id
group by
o.TerritoryID
, o.TerritoryDescription
having
count (*) <= @.num
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"TechnoSpike" <TechnoSpike.1mdf1a@.mail.webservertalk.com> wrote in message
news:TechnoSpike.1mdf1a@.mail.webservertalk.com...
Hi! I'm trying to create an User Defined function that gives me the top
rows of a table. I must be able to define wich is the top number of
rows to be returned. I assume I could do this:
CREATE FUNCTION ListTopRegions (@.reg_id int, @.num int)
RETURNS @.table table ([TerritoryID] [nvarchar] (20),
[TerritoryDescription] [nchar] (50))
AS
begin
if exists (select 1 from Region where RegionID = @.reg_id)
begin
insert into @.table select top @.num TerritoryID, TerritoryDescription
from Territories
where RegionID=@.reg_id
end
return
end
but it keeps saying : Incorrect syntax near '@.num'. Any idea what I'm
doing wrong? I'm using the Northwing DB, and I intend to get the first
5 entries, for instance.
TechnoSpike
---
Posted via http://www.webservertalk.com
---
View this thread: http://www.webservertalk.com/message967438.html|||You could use the SET ROWCOUNT command. This will limit the number of rows
returned from the query similar to the TOP function.
"TechnoSpike" wrote:

> Hi! I'm trying to create an User Defined function that gives me the top
> rows of a table. I must be able to define wich is the top number of
> rows to be returned. I assume I could do this:
> CREATE FUNCTION ListTopRegions (@.reg_id int, @.num int)
> RETURNS @.table table ([TerritoryID] [nvarchar] (20),
> [TerritoryDescription] [nchar] (50))
> AS
> begin
> if exists (select 1 from Region where RegionID = @.reg_id)
> begin
> insert into @.table select top @.num TerritoryID, TerritoryDescription
> from Territories
> where RegionID=@.reg_id
> end
> return
> end
> but it keeps saying : Incorrect syntax near '@.num'. Any idea what I'm
> doing wrong? I'm using the Northwing DB, and I intend to get the first
> 5 entries, for instance.
>
> --
> TechnoSpike
> ---
> Posted via http://www.webservertalk.com
> ---
> View this thread: http://www.webservertalk.com/message967438.html
>

Problems using TOP and User Functions

Hi! I'm trying to create an User Defined function that gives me the top
rows of a table. I must be able to define wich is the top number of
rows to be returned. I assume I could do this:
CREATE FUNCTION ListTopRegions (@.reg_id int, @.num int)
RETURNS @.table table ([TerritoryID] [nvarchar] (20),
[TerritoryDescription] [nchar] (50))
AS
begin
if exists (select 1 from Region where RegionID = @.reg_id)
begin
insert into @.table select top @.num TerritoryID, TerritoryDescription
from Territories
where RegionID=@.reg_id
end
return
end
but it keeps saying : Incorrect syntax near '@.num'. Any idea what I'm
doing wrong? I'm using the Northwing DB, and I intend to get the first
5 entries, for instance.
--
TechnoSpike
---
Posted via http://www.webservertalk.com
---
View this thread: http://www.webservertalk.com/message967438.htmlYou have to use a hard-coded value in a TOP clause in SQL Server 2000.
You'll be able to use expressions in SQL Server 2005. You didn't say what
determines the order. For example, is it the TOP (n) sorted by TerritoryID?
In that case, try:
select
o.TerritoryID
, o.TerritoryDescription
from
Territories o
join
Territories i on i.TerritoryID <= o.TerritoryID
and i.RegionID = o.RegionID
where
o.RegionID = @.reg_id
group by
o.TerritoryID
, o.TerritoryDescription
having
count (*) <= @.num
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"TechnoSpike" <TechnoSpike.1mdf1a@.mail.webservertalk.com> wrote in message
news:TechnoSpike.1mdf1a@.mail.webservertalk.com...
Hi! I'm trying to create an User Defined function that gives me the top
rows of a table. I must be able to define wich is the top number of
rows to be returned. I assume I could do this:
CREATE FUNCTION ListTopRegions (@.reg_id int, @.num int)
RETURNS @.table table ([TerritoryID] [nvarchar] (20),
[TerritoryDescription] [nchar] (50))
AS
begin
if exists (select 1 from Region where RegionID = @.reg_id)
begin
insert into @.table select top @.num TerritoryID, TerritoryDescription
from Territories
where RegionID=@.reg_id
end
return
end
but it keeps saying : Incorrect syntax near '@.num'. Any idea what I'm
doing wrong? I'm using the Northwing DB, and I intend to get the first
5 entries, for instance.
TechnoSpike
---
Posted via http://www.webservertalk.com
---
View this thread: http://www.webservertalk.com/message967438.html|||You could use the SET ROWCOUNT command. This will limit the number of rows
returned from the query similar to the TOP function.
"TechnoSpike" wrote:
> Hi! I'm trying to create an User Defined function that gives me the top
> rows of a table. I must be able to define wich is the top number of
> rows to be returned. I assume I could do this:
> CREATE FUNCTION ListTopRegions (@.reg_id int, @.num int)
> RETURNS @.table table ([TerritoryID] [nvarchar] (20),
> [TerritoryDescription] [nchar] (50))
> AS
> begin
> if exists (select 1 from Region where RegionID = @.reg_id)
> begin
> insert into @.table select top @.num TerritoryID, TerritoryDescription
> from Territories
> where RegionID=@.reg_id
> end
> return
> end
> but it keeps saying : Incorrect syntax near '@.num'. Any idea what I'm
> doing wrong? I'm using the Northwing DB, and I intend to get the first
> 5 entries, for instance.
>
> --
> TechnoSpike
> ---
> Posted via http://www.webservertalk.com
> ---
> View this thread: http://www.webservertalk.com/message967438.html
>

Problems using TOP and User Functions

Hi! I'm trying to create an User Defined function that gives me the top
rows of a table. I must be able to define wich is the top number of
rows to be returned. I assume I could do this:
CREATE FUNCTION ListTopRegions (@.reg_id int, @.num int)
RETURNS @.table table ([TerritoryID] [nvarchar] (20),
[TerritoryDescription] [nchar] (50))
AS
begin
if exists (select 1 from Region where RegionID = @.reg_id)
begin
insert into @.table select top @.num TerritoryID, TerritoryDescription
from Territories
where RegionID=@.reg_id
end
return
end
but it keeps saying : Incorrect syntax near '@.num'. Any idea what I'm
doing wrong? I'm using the Northwing DB, and I intend to get the first
5 entries, for instance.
TechnoSpike
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message967438.html
You have to use a hard-coded value in a TOP clause in SQL Server 2000.
You'll be able to use expressions in SQL Server 2005. You didn't say what
determines the order. For example, is it the TOP (n) sorted by TerritoryID?
In that case, try:
select
o.TerritoryID
, o.TerritoryDescription
from
Territories o
join
Territories i on i.TerritoryID <= o.TerritoryID
and i.RegionID = o.RegionID
where
o.RegionID = @.reg_id
group by
o.TerritoryID
, o.TerritoryDescription
having
count (*) <= @.num
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"TechnoSpike" <TechnoSpike.1mdf1a@.mail.webservertalk.com> wrote in message
news:TechnoSpike.1mdf1a@.mail.webservertalk.com...
Hi! I'm trying to create an User Defined function that gives me the top
rows of a table. I must be able to define wich is the top number of
rows to be returned. I assume I could do this:
CREATE FUNCTION ListTopRegions (@.reg_id int, @.num int)
RETURNS @.table table ([TerritoryID] [nvarchar] (20),
[TerritoryDescription] [nchar] (50))
AS
begin
if exists (select 1 from Region where RegionID = @.reg_id)
begin
insert into @.table select top @.num TerritoryID, TerritoryDescription
from Territories
where RegionID=@.reg_id
end
return
end
but it keeps saying : Incorrect syntax near '@.num'. Any idea what I'm
doing wrong? I'm using the Northwing DB, and I intend to get the first
5 entries, for instance.
TechnoSpike
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message967438.html
|||You could use the SET ROWCOUNT command. This will limit the number of rows
returned from the query similar to the TOP function.
"TechnoSpike" wrote:

> Hi! I'm trying to create an User Defined function that gives me the top
> rows of a table. I must be able to define wich is the top number of
> rows to be returned. I assume I could do this:
> CREATE FUNCTION ListTopRegions (@.reg_id int, @.num int)
> RETURNS @.table table ([TerritoryID] [nvarchar] (20),
> [TerritoryDescription] [nchar] (50))
> AS
> begin
> if exists (select 1 from Region where RegionID = @.reg_id)
> begin
> insert into @.table select top @.num TerritoryID, TerritoryDescription
> from Territories
> where RegionID=@.reg_id
> end
> return
> end
> but it keeps saying : Incorrect syntax near '@.num'. Any idea what I'm
> doing wrong? I'm using the Northwing DB, and I intend to get the first
> 5 entries, for instance.
>
> --
> TechnoSpike
> Posted via http://www.webservertalk.com
> View this thread: http://www.webservertalk.com/message967438.html
>