Showing posts with label hii. Show all posts
Showing posts with label hii. 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.

Friday, March 23, 2012

Problems with regard to connection string

hi!

I have 2 questions that needs to be clarified.

I have Sub packges being executed from the main package. I am executin the Main Package with the Conn string set through the C# UI like

string connect = @."TahoeDB;Data Source=SE413695\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security=SSPI;";

jobCommand = new SqlCommand("xp_cmdshell 'dtexec /f \"" + path + "\" /Conn \"" + connect + "\" /Set \\package.Variables[User::ArchivePackageName].Properties[Value];\"" + name + "\" /Set \\package.Variables[User::ArchiveFileType].Properties[Value];\"" + type + "\" /Set \\package.Variables[User::ArchiveFlatFileConnectSt].Properties[Value];\"" + xlspath + "\"'", cconn);

Works fine. but In my Integration services package which has connection string for each packge separately. Which i need to set as same as the main package conn string.

Which is the best way of doing it.

2 problem is that i have 2 connection string in my main package. how to i set them as i have shown in the above code.

Do i need to set the / Conn twice . But how will it interpret two connection s that is set. how can i deal with this problem

Thanks,

Jas

How about a "Parent package variable" configuration?

For a brief discussion of this topic see the section titled "Passing Values to Child Packages" in Books Online-

Execute Package Task
(http://msdn2.microsoft.com/en-us/library/042d4ec0-0668-401c-bb3a-a25fe2602eac.aspx)

In answer to first question, you should only need to pass the connection string into the package once, but passing it into a variable rather than setting the connection isetlf would be better for reuse. The connection in the parent can use an expression to set itself from the variable. The child can use one of the methods covered in the BOL section.

|||

This worked fine. i am setting value to variables including the conn string in the main package .Using Parent Package variable i set the values to variable through expression.

thanks a lot,

Jas

Wednesday, March 21, 2012

Problems with partition view because it is evaluation version?

Hi
I am trying to get a partition view to work. The
partition view is made up of tables that as far as I can
tell qualify for having a partion column. Each tables is
identical except for the check constraint.
If I try to update a row I get an error that partioning
column was not found.
Updateable partition views only work on the enterprise
edition as I understand it. I am trying this out on the
evaluation edition. Could this be the problem or is it
more likely to be in my view construction?
Sql is:
CREATE TABLE [dbo].[bb_chat_200309] (
[chatID] [numeric](18, 0) IDENTITY (1, 1) NOT
NULL ,
[yearMonth] [varchar] (6) NOT NULL ,
[originatedBy] [varchar] (12) NULL ,
[originatedDate] [datetime] NULL ,
[terminatedBy] [varchar] (12) NULL ,
[terminatedDate] [datetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[bb_chat_200310] (
[chatID] [numeric](18, 0) IDENTITY (1, 1) NOT
NULL ,
[yearMonth] [varchar] (6) NOT NULL ,
[originatedBy] [varchar] (12) NULL ,
[originatedDate] [datetime] NULL ,
[terminatedBy] [varchar] (12) NULL ,
[terminatedDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[bb_chat_200309] WITH NOCHECK ADD
CONSTRAINT [pk_bb_chat_200309] PRIMARY KEY
CLUSTERED
(
[chatID],
[yearMonth]
) ON [PRIMARY] ,
CHECK ([yearMonth] = 200309)
GO
ALTER TABLE [dbo].[bb_chat_200310] WITH NOCHECK ADD
CONSTRAINT [pk_bb_chat_200310] PRIMARY KEY
CLUSTERED
(
[chatID],
[yearMonth]
) ON [PRIMARY] ,
CHECK ([yearMonth] = 200310)
GO
create view dbo.bb_chat as
select
chatID
, yearMonth
, originatedBy
, originatedDate
, terminatedBy
, terminatedDate
from bb_chat_200405
union all
select
chatID
, yearMonth
, originatedBy
, originatedDate
, terminatedBy
, terminatedDate
from bb_chat_200404
Thanks for any help
GlynTry specifying the check constraint as part of the CREATE TABLE. For
example:
CREATE TABLE [dbo].[bb_chat_200309] (
[chatID] [numeric](18, 0) IDENTITY (1, 1) NOT
NULL ,
[yearMonth] [varchar] (6) NOT NULL
CONSTRAINT CK_bb_chat_200309_yearmonth CHECK ([yearMonth] = '200309') ,
[originatedBy] [varchar] (12) NULL ,
[originatedDate] [datetime] NULL ,
[terminatedBy] [varchar] (12) NULL ,
[terminatedDate] [datetime] NULL
) ON [PRIMARY]
GO
Hope this helps.
Dan Guzman
SQL Server MVP
"Glyn Walters" <glyn_walters@.hotmail.com> wrote in message
news:f9b601c43e65$9cba4a90$a601280a@.phx.gbl...
> Hi
> I am trying to get a partition view to work. The
> partition view is made up of tables that as far as I can
> tell qualify for having a partion column. Each tables is
> identical except for the check constraint.
> If I try to update a row I get an error that partioning
> column was not found.
> Updateable partition views only work on the enterprise
> edition as I understand it. I am trying this out on the
> evaluation edition. Could this be the problem or is it
> more likely to be in my view construction?
> Sql is:
> CREATE TABLE [dbo].[bb_chat_200309] (
> [chatID] [numeric](18, 0) IDENTITY (1, 1) NOT
> NULL ,
> [yearMonth] [varchar] (6) NOT NULL ,
> [originatedBy] [varchar] (12) NULL ,
> [originatedDate] [datetime] NULL ,
> [terminatedBy] [varchar] (12) NULL ,
> [terminatedDate] [datetime] NULL
> ) ON [PRIMARY]
> GO
> CREATE TABLE [dbo].[bb_chat_200310] (
> [chatID] [numeric](18, 0) IDENTITY (1, 1) NOT
> NULL ,
> [yearMonth] [varchar] (6) NOT NULL ,
> [originatedBy] [varchar] (12) NULL ,
> [originatedDate] [datetime] NULL ,
> [terminatedBy] [varchar] (12) NULL ,
> [terminatedDate] [datetime] NULL
> ) ON [PRIMARY]
> GO
> ALTER TABLE [dbo].[bb_chat_200309] WITH NOCHECK ADD
> CONSTRAINT [pk_bb_chat_200309] PRIMARY KEY
> CLUSTERED
> (
> [chatID],
> [yearMonth]
> ) ON [PRIMARY] ,
> CHECK ([yearMonth] = 200309)
> GO
> ALTER TABLE [dbo].[bb_chat_200310] WITH NOCHECK ADD
> CONSTRAINT [pk_bb_chat_200310] PRIMARY KEY
> CLUSTERED
> (
> [chatID],
> [yearMonth]
> ) ON [PRIMARY] ,
> CHECK ([yearMonth] = 200310)
> GO
> create view dbo.bb_chat as
> select
> chatID
> , yearMonth
> , originatedBy
> , originatedDate
> , terminatedBy
> , terminatedDate
> from bb_chat_200405
> union all
> select
> chatID
> , yearMonth
> , originatedBy
> , originatedDate
> , terminatedBy
> , terminatedDate
> from bb_chat_200404
> Thanks for any help
> Glyn|||Hi. Thanks for the advice. Howvere I do create the tables
like that. The output above was from exporting sql. I
create the tables using this script:
set @.sql = 'create table dbo.bb_chatUser_' + @.YYYYMM + '(
chatID numeric(18, 0) not null
, yearMonth varchar(6) not null constraint
ck_bb_chatUser_' + @.YYYYMM + '_yearmonth check (yearMonth
= ' + @.YYYYMM + ')
, invitedBy varchar (12) not null
, invitedDate datetime not null
, guestID varchar(12) not null
, answeredDate datetime null
, leftDate datetime
)'
exec(@.sql);
I think my tables and view qualify as yearMonth has a non-
overlapping check constraint and is part of the primary
key. Are there any other things I need to do to make the
view updateable?|||drop and re-create the constraints, there is an article by MS
http://support.microsoft.com/defaul...kb;en-us;270013|||Thanks for the advice. If was my mistake in the end the
check constraints were yearMonth = 200310 rather
than '200310'.

Problems with partition view because it is evaluation version?

Hi
I am trying to get a partition view to work. The
partition view is made up of tables that as far as I can
tell qualify for having a partion column. Each tables is
identical except for the check constraint.
If I try to update a row I get an error that partioning
column was not found.
Updateable partition views only work on the enterprise
edition as I understand it. I am trying this out on the
evaluation edition. Could this be the problem or is it
more likely to be in my view construction?
Sql is:
CREATE TABLE [dbo].[bb_chat_200309] (
[chatID] [numeric](18, 0) IDENTITY (1, 1) NOT
NULL ,
[yearMonth] [varchar] (6) NOT NULL ,
[originatedBy] [varchar] (12) NULL ,
[originatedDate] [datetime] NULL ,
[terminatedBy] [varchar] (12) NULL ,
[terminatedDate] [datetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[bb_chat_200310] (
[chatID] [numeric](18, 0) IDENTITY (1, 1) NOT
NULL ,
[yearMonth] [varchar] (6) NOT NULL ,
[originatedBy] [varchar] (12) NULL ,
[originatedDate] [datetime] NULL ,
[terminatedBy] [varchar] (12) NULL ,
[terminatedDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[bb_chat_200309] WITH NOCHECK ADD
CONSTRAINT [pk_bb_chat_200309] PRIMARY KEY
CLUSTERED
(
[chatID],
[yearMonth]
) ON [PRIMARY] ,
CHECK ([yearMonth] = 200309)
GO
ALTER TABLE [dbo].[bb_chat_200310] WITH NOCHECK ADD
CONSTRAINT [pk_bb_chat_200310] PRIMARY KEY
CLUSTERED
(
[chatID],
[yearMonth]
) ON [PRIMARY] ,
CHECK ([yearMonth] = 200310)
GO
create view dbo.bb_chat as
select
chatID
,yearMonth
,originatedBy
,originatedDate
,terminatedBy
,terminatedDate
from bb_chat_200405
union all
select
chatID
,yearMonth
,originatedBy
,originatedDate
,terminatedBy
,terminatedDate
from bb_chat_200404
Thanks for any help
Glyn
Try specifying the check constraint as part of the CREATE TABLE. For
example:
CREATE TABLE [dbo].[bb_chat_200309] (
[chatID] [numeric](18, 0) IDENTITY (1, 1) NOT
NULL ,
[yearMonth] [varchar] (6) NOT NULL
CONSTRAINT CK_bb_chat_200309_yearmonth CHECK ([yearMonth] = '200309') ,
[originatedBy] [varchar] (12) NULL ,
[originatedDate] [datetime] NULL ,
[terminatedBy] [varchar] (12) NULL ,
[terminatedDate] [datetime] NULL
) ON [PRIMARY]
GO
Hope this helps.
Dan Guzman
SQL Server MVP
"Glyn Walters" <glyn_walters@.hotmail.com> wrote in message
news:f9b601c43e65$9cba4a90$a601280a@.phx.gbl...
> Hi
> I am trying to get a partition view to work. The
> partition view is made up of tables that as far as I can
> tell qualify for having a partion column. Each tables is
> identical except for the check constraint.
> If I try to update a row I get an error that partioning
> column was not found.
> Updateable partition views only work on the enterprise
> edition as I understand it. I am trying this out on the
> evaluation edition. Could this be the problem or is it
> more likely to be in my view construction?
> Sql is:
> CREATE TABLE [dbo].[bb_chat_200309] (
> [chatID] [numeric](18, 0) IDENTITY (1, 1) NOT
> NULL ,
> [yearMonth] [varchar] (6) NOT NULL ,
> [originatedBy] [varchar] (12) NULL ,
> [originatedDate] [datetime] NULL ,
> [terminatedBy] [varchar] (12) NULL ,
> [terminatedDate] [datetime] NULL
> ) ON [PRIMARY]
> GO
> CREATE TABLE [dbo].[bb_chat_200310] (
> [chatID] [numeric](18, 0) IDENTITY (1, 1) NOT
> NULL ,
> [yearMonth] [varchar] (6) NOT NULL ,
> [originatedBy] [varchar] (12) NULL ,
> [originatedDate] [datetime] NULL ,
> [terminatedBy] [varchar] (12) NULL ,
> [terminatedDate] [datetime] NULL
> ) ON [PRIMARY]
> GO
> ALTER TABLE [dbo].[bb_chat_200309] WITH NOCHECK ADD
> CONSTRAINT [pk_bb_chat_200309] PRIMARY KEY
> CLUSTERED
> (
> [chatID],
> [yearMonth]
> ) ON [PRIMARY] ,
> CHECK ([yearMonth] = 200309)
> GO
> ALTER TABLE [dbo].[bb_chat_200310] WITH NOCHECK ADD
> CONSTRAINT [pk_bb_chat_200310] PRIMARY KEY
> CLUSTERED
> (
> [chatID],
> [yearMonth]
> ) ON [PRIMARY] ,
> CHECK ([yearMonth] = 200310)
> GO
> create view dbo.bb_chat as
> select
> chatID
> , yearMonth
> , originatedBy
> , originatedDate
> , terminatedBy
> , terminatedDate
> from bb_chat_200405
> union all
> select
> chatID
> , yearMonth
> , originatedBy
> , originatedDate
> , terminatedBy
> , terminatedDate
> from bb_chat_200404
> Thanks for any help
> Glyn
|||Hi. Thanks for the advice. Howvere I do create the tables
like that. The output above was from exporting sql. I
create the tables using this script:
set @.sql = 'create table dbo.bb_chatUser_' + @.YYYYMM + '(
chatID numeric(18, 0) not null
,yearMonth varchar(6) not null constraint
ck_bb_chatUser_' + @.YYYYMM + '_yearmonth check (yearMonth
= ' + @.YYYYMM + ')
,invitedBy varchar (12) not null
,invitedDate datetime not null
,guestID varchar(12) not null
,answeredDate datetime null
,leftDate datetime
)'
exec(@.sql);
I think my tables and view qualify as yearMonth has a non-
overlapping check constraint and is part of the primary
key. Are there any other things I need to do to make the
view updateable?
|||drop and re-create the constraints, there is an article by MS
http://support.microsoft.com/default...b;en-us;270013
|||Thanks for the advice. If was my mistake in the end the
check constraints were yearMonth = 200310 rather
than '200310'.

Monday, March 12, 2012

problems with getElementById and Select Box

Hi
I have a problem with a javascript function. I have a select box in my
form called "sale_status" this has two options "pending" and "sold".
When "sold" is selected it should automatically show the "sale_date"
field. The function checkStatus is called onChange().
Problem: my show and hide functions work fine, but when I alert
status.value I get "undefined". can anybody tell me what I'm doing
wrong (the id is definitely correct). I'm sure it's just something
stupid that I've done.
here's my function:
function checkStatus(id){
status = document.getElementById(id);
alert(status.value);
if(status.value=="sold"){
alert('h');
show("sale_date_field");
}
else{
hide("sale_date_field");
}
}
Many Thanks
Benoops, sorry, wrong group.

problems with getElementById and Select Box

Hi
I have a problem with a javascript function. I have a select box in my
form called "sale_status" this has two options "pending" and "sold".
When "sold" is selected it should automatically show the "sale_date"
field. The function checkStatus is called onChange().
Problem: my show and hide functions work fine, but when I alert
status.value I get "undefined". can anybody tell me what I'm doing
wrong (the id is definitely correct). I'm sure it's just something
stupid that I've done.
here's my function:
function checkStatus(id){
status = document.getElementById(id);
alert(status.value);
if(status.value=="sold"){
alert('h');
show("sale_date_field");
}
else{
hide("sale_date_field");
}
}
Many Thanks
Ben
oops, sorry, wrong group.

Wednesday, March 7, 2012

Problems with casting in query

Hi
I have this query
SELECT hour, rootnode, parentnode, childnode, besvaret, optaget, opgivet,
ubesvaret, total FROM (
SELECT rootnode, parentnode, childnode,
COUNT(*) AS total,
COUNT (CASE WHEN durationofconversation > 0 THEN 1 END) AS
besvaret,
COUNT(CASE WHEN durationofconversation = 0 AND
releasecause = 'OC' THEN 1 END) AS optaget,
COUNT(CASE WHEN durationofconversation = 0 AND
releasecause = 'RL' AND durationofcall < 40 THEN 1 END) AS opgivet,
COUNT(CASE WHEN durationofconversation = 0 AND
durationofcall >= 40 THEN 1 END) AS ubesvaret,
tcv2.dbo. fn_getdatetimeperhour(DATECALLINITIATED)
as hour
FROM V2tickets
INNER JOIN (
SELECT s.serie, a.nodename as rootnode, cs.nodename as
parentnode, c.nodename as childnode
FROM areas a, centers cs, center c, teams t, series s
WHERE (a.nodeid=1) and a.nodeid=cs.parentid and
cs.nodeid=c.parentid and c.nodeid=t.parentid and t.nodeid=s.parentid) AS H
ON V2tickets.digits = H.serie
WHERE siteid=1 AND calltype='E' AND LEN(digits) = 4 and
(cast(convert(char, DATECALLINITIATED, 1) as datetime)
between '01/09/03' and '01/12/05' ) and
(cast(convert(char, DATECALLINITIATED, 8) as datetime)
between '00:00:22' and '23:59:22' )
GROUP BY tcv2.dbo. fn_getdatetimeperhour(DATECALLINITIATED)
, rootnode,
parentnode, childnode) AS D ORDER BY 3, 4
Query is using this function to group by the hour
CREATE FUNCTION fn_getdatetimeperhour (@.DATE datetime)
RETURNS smalldatetime
AS
BEGIN
declare @.mydatetime smalldatetime
set @.mydatetime = cast(DATEPART (day, @.DATE ) as varchar(2))+'-'+
cast(DATEPART (month, @.DATE ) as varchar(2))+'-'+
cast(DATEPART (year, @.DATE ) as varchar(4))+' '+
right('0' + ltrim(DATEPART ( hour, @.DATE )), 2 )+':00:00'
RETURN(@.mydatetime)
END
I get this error when executing the query.
Server: Msg 296, Level 16, State 3, Procedure fn_getdatetimeperhour, Line 6
The conversion of char data type to smalldatetime data type resulted in an
out-of-range smalldatetime value.
Does anyone have any suggestions on what I'm doing wrong? Basically the
query works if I leave out the between part from the query
(cast(convert(char, DATECALLINITIATED, 1) as datetime) between '01/09/03'
and '01/12/05' ) and
(cast(convert(char, DATECALLINITIATED, 8) as datetime)
between '00:00:22' and '23:59:22' )
regards
HenryThere exists one or more rows in your data where the value of
DATECALLINITIATED is outside the range of valid values for a smalldatetime,
(1 Jan 1900 through 6 June 2079)
But if all you want to do is group data by each hour, try using this
expression
Select Convert(VarChar(15), DATECALLINITIATED , 113) + '00'
as the group by expression, instead of the UDF. UDFs are recompiled each
time they are run, and in your query, the UDF is being run twice fpr each ro
w
in the database table. If you use the actual expression, inline in your
query, you will avoid the errror as well as substantially improve the
performance.
"Henry" wrote:

> Hi
> I have this query
> SELECT hour, rootnode, parentnode, childnode, besvaret, optaget, opgivet,
> ubesvaret, total FROM (
> SELECT rootnode, parentnode, childnode,
> COUNT(*) AS total,
> COUNT (CASE WHEN durationofconversation > 0 THEN 1 END)
AS
> besvaret,
> COUNT(CASE WHEN durationofconversation = 0 AND
> releasecause = 'OC' THEN 1 END) AS optaget,
> COUNT(CASE WHEN durationofconversation = 0 AND
> releasecause = 'RL' AND durationofcall < 40 THEN 1 END) AS opgivet,
> COUNT(CASE WHEN durationofconversation = 0 AND
> durationofcall >= 40 THEN 1 END) AS ubesvaret,
> tcv2.dbo. fn_getdatetimeperhour(DATECALLINITIATED)
as ho
ur
> FROM V2tickets
> INNER JOIN (
> SELECT s.serie, a.nodename as rootnode, cs.nodename a
s
> parentnode, c.nodename as childnode
> FROM areas a, centers cs, center c, teams t, series s
> WHERE (a.nodeid=1) and a.nodeid=cs.parentid and
> cs.nodeid=c.parentid and c.nodeid=t.parentid and t.nodeid=s.parentid) AS H
> ON V2tickets.digits = H.serie
> WHERE siteid=1 AND calltype='E' AND LEN(digits) = 4 and
> (cast(convert(char, DATECALLINITIATED, 1) as datetime)
> between '01/09/03' and '01/12/05' ) and
> (cast(convert(char, DATECALLINITIATED, 8) as datetime)
> between '00:00:22' and '23:59:22' )
> GROUP BY tcv2.dbo. fn_getdatetimeperhour(DATECALLINITIATED)
, rootnode,
> parentnode, childnode) AS D ORDER BY 3, 4
>
> Query is using this function to group by the hour
> CREATE FUNCTION fn_getdatetimeperhour (@.DATE datetime)
> RETURNS smalldatetime
> AS
> BEGIN
> declare @.mydatetime smalldatetime
> set @.mydatetime = cast(DATEPART (day, @.DATE ) as varchar(2))+'-'+
> cast(DATEPART (month, @.DATE ) as varchar(2))+'-'+
> cast(DATEPART (year, @.DATE ) as varchar(4))+' '+
> right('0' + ltrim(DATEPART ( hour, @.DATE )), 2 )+':00:00'
> RETURN(@.mydatetime)
> END
>
> I get this error when executing the query.
> Server: Msg 296, Level 16, State 3, Procedure fn_getdatetimeperhour, Line
6
> The conversion of char data type to smalldatetime data type resulted in an
> out-of-range smalldatetime value.
>
> Does anyone have any suggestions on what I'm doing wrong? Basically the
> query works if I leave out the between part from the query
> (cast(convert(char, DATECALLINITIATED, 1) as datetime) between '01/09/03'
> and '01/12/05' ) and
> (cast(convert(char, DATECALLINITIATED, 8) as datetime)
> between '00:00:22' and '23:59:22' )
>
> regards
> Henry
>
>|||Henry,
What is
(cast(convert(char, DATECALLINITIATED, 1) as datetime) between
'01/09/03' and '01/12/05' )
supposed to do? It casts DATECALLINITIATED, which I hope is
of type datetime, into a string according to a specific format, then
back to a datetime with no format specified (so the outer cast is
depending on system and session settings). Then it compares that
datetime (if the conversion succeeds) with two strings in an ambiguous
date format. Something like this is more likely what you want:
DATECALLINITIATED between convert(smalldatetime, '01/09/03', 1)
and convert(smalldatetime, '01/12/05' ,1)
I didn't look at anything else in the query.
Steve Kass
Drew University
Henry wrote:

>Hi
>I have this query
>SELECT hour, rootnode, parentnode, childnode, besvaret, optaget, opgivet,
>ubesvaret, total FROM (
> SELECT rootnode, parentnode, childnode,
> COUNT(*) AS total,
> COUNT (CASE WHEN durationofconversation > 0 THEN 1 END) A
S
>besvaret,
> COUNT(CASE WHEN durationofconversation = 0 AND
>releasecause = 'OC' THEN 1 END) AS optaget,
> COUNT(CASE WHEN durationofconversation = 0 AND
>releasecause = 'RL' AND durationofcall < 40 THEN 1 END) AS opgivet,
> COUNT(CASE WHEN durationofconversation = 0 AND
>durationofcall >= 40 THEN 1 END) AS ubesvaret,
> tcv2.dbo. fn_getdatetimeperhour(DATECALLINITIATED)
as hou
r
> FROM V2tickets
> INNER JOIN (
> SELECT s.serie, a.nodename as rootnode, cs.nodename as
>parentnode, c.nodename as childnode
> FROM areas a, centers cs, center c, teams t, series s
> WHERE (a.nodeid=1) and a.nodeid=cs.parentid and
>cs.nodeid=c.parentid and c.nodeid=t.parentid and t.nodeid=s.parentid) AS H
> ON V2tickets.digits = H.serie
> WHERE siteid=1 AND calltype='E' AND LEN(digits) = 4 and
> (cast(convert(char, DATECALLINITIATED, 1) as datetime)
>between '01/09/03' and '01/12/05' ) and
> (cast(convert(char, DATECALLINITIATED, 8) as datetime)
>between '00:00:22' and '23:59:22' )
> GROUP BY tcv2.dbo. fn_getdatetimeperhour(DATECALLINITIATED)
, rootnode,
>parentnode, childnode) AS D ORDER BY 3, 4
>
>Query is using this function to group by the hour
>CREATE FUNCTION fn_getdatetimeperhour (@.DATE datetime)
>RETURNS smalldatetime
>AS
>BEGIN
> declare @.mydatetime smalldatetime
> set @.mydatetime = cast(DATEPART (day, @.DATE ) as varchar(2))+'-'+
> cast(DATEPART (month, @.DATE ) as varchar(2))+'-'+
> cast(DATEPART (year, @.DATE ) as varchar(4))+' '+
> right('0' + ltrim(DATEPART ( hour, @.DATE )), 2 )+':00:00'
> RETURN(@.mydatetime)
>END
>
>I get this error when executing the query.
>Server: Msg 296, Level 16, State 3, Procedure fn_getdatetimeperhour, Line 6
>The conversion of char data type to smalldatetime data type resulted in an
>out-of-range smalldatetime value.
>
>Does anyone have any suggestions on what I'm doing wrong? Basically the
>query works if I leave out the between part from the query
>(cast(convert(char, DATECALLINITIATED, 1) as datetime) between '01/09/03'
>and '01/12/05' ) and
> (cast(convert(char, DATECALLINITIATED, 8) as datetime)
>between '00:00:22' and '23:59:22' )
>
>regards
>Henry
>
>|||> What is
> (cast(convert(char, DATECALLINITIATED, 1) as datetime) between '01/09/03'
> and '01/12/05' )
> supposed to do? It casts DATECALLINITIATED, which I hope is
> of type datetime, into a string according to a specific format, then
> back to a datetime with no format specified (so the outer cast is
> depending on system and session settings). Then it compares that
> datetime (if the conversion succeeds) with two strings in an ambiguous
> date format. Something like this is more likely what you want:
> DATECALLINITIATED between convert(smalldatetime, '01/09/03', 1)
> and convert(smalldatetime, '01/12/05' ,1)
>
Hi Steve
Thanks for your answer.
Well thats the only way I could get it to work :-o
I have tried you siggestion which doesn't give any result, not even an error
;o)
When I do a select in the query analyser on the field the format looks like
this "27-08-2003 00:02:09" which is the standard danish date and time
format, but does that mean that datetime fields are stored as strings rather
than a real (float)? Or is the presentation in the query analyser depending
on the regional settings?
I thought that your suggestion above would compare float to float values?
Excuse me, I'm still a novice in this SQL world.
regards
Henry|||> There exists one or more rows in your data where the value of
> DATECALLINITIATED is outside the range of valid values for a
> smalldatetime,
> (1 Jan 1900 through 6 June 2079)
> But if all you want to do is group data by each hour, try using this
> expression
> Select Convert(VarChar(15), DATECALLINITIATED , 113) + '00'
> as the group by expression, instead of the UDF. UDFs are recompiled each
> time they are run, and in your query, the UDF is being run twice fpr each
> row
> in the database table. If you use the actual expression, inline in your
> query, you will avoid the errror as well as substantially improve the
> performance.
Hi
Thanks for your reply.
It's seems that you are right ;o) I'll do some more testing on this.
regards
Henry|||Hi Steve
This is spooking me (we are talking about the datetime conversion and
casting)
This one here works (my old method)
SELECT hour, rootnode, parentnode, childnode, besvaret, optaget, opgivet,
ubesvaret, total FROM( SELECT rootnode, parentnode, childnode, COUNT(*) AS
total, COUNT(CASE WHEN durationofconversation > 0 THEN 1 END) AS besvaret,
COUNT(CASE WHEN durationofconversation = 0 AND releasecause = 'OC' THEN 1
END) AS optaget, COUNT(CASE WHEN durationofconversation = 0 AND releasecause
= 'RL' AND durationofcall < 40 THEN 1 END) AS opgivet, COUNT(CASE WHEN
durationofconversation = 0 AND durationofcall >= 40 THEN 1 END) AS
ubesvaret, cast(convert(VarChar(15), DATECALLINITIATED , 113) + '00' as
datetime) as hour FROM V2tickets INNER JOIN (SELECT s.serie, a.nodename as
rootnode, cs.nodename as parentnode, c.nodename as childnode FROM areas a,
centers cs, center c, teams t, series s WHERE (a.nodeid=1) and
a.nodeid=cs.parentid and cs.nodeid=c.parentid and c.nodeid=t.parentid and
t.nodeid=s.parentid) AS H ON V2tickets.digits = H.serie WHERE siteid=1 AND
calltype='E' AND LEN(digits) = 4 and (cast(convert(char, DATECALLINITIATED,
1) as datetime) between '01/09/03' and '09/12/08' ) and (cast(convert(char,
DATECALLINITIATED, 8) as datetime) between '00:00:00' and '23:59:59' ) GROUP
BY cast(Convert(VarChar(15), DATECALLINITIATED , 113) + '00' as datetime),
rootnode, parentnode, childnode) AS D ORDER BY 3, 4
This one doesn't
SELECT hour, rootnode, parentnode, childnode, besvaret, optaget, opgivet,
ubesvaret, total FROM( SELECT rootnode, parentnode, childnode, COUNT(*) AS
total, COUNT(CASE WHEN durationofconversation > 0 THEN 1 END) AS besvaret,
COUNT(CASE WHEN durationofconversation = 0 AND releasecause = 'OC' THEN 1
END) AS optaget, COUNT(CASE WHEN durationofconversation = 0 AND releasecause
= 'RL' AND durationofcall < 40 THEN 1 END) AS opgivet, COUNT(CASE WHEN
durationofconversation = 0 AND durationofcall >= 40 THEN 1 END) AS
ubesvaret, cast(convert(VarChar(15), DATECALLINITIATED , 113) + '00' as
datetime) as hour FROM V2tickets INNER JOIN (SELECT s.serie, a.nodename as
rootnode, cs.nodename as parentnode, c.nodename as childnode FROM areas a,
centers cs, center c, teams t, series s WHERE (a.nodeid=1) and
a.nodeid=cs.parentid and cs.nodeid=c.parentid and c.nodeid=t.parentid and
t.nodeid=s.parentid) AS H ON V2tickets.digits = H.serie WHERE siteid=1 AND
calltype='E' AND LEN(digits) = 4 and DATECALLINITIATED between
convert(smalldatetime, '01/09/03', 1) and convert(smalldatetime, '09/12/08'
,1) and DATECALLINITIATED between convert(smalldatetime, '00:00:00', 8) and
convert(smalldatetime, '23:59:59' ,8) GROUP BY cast(Convert(VarChar(15),
DATECALLINITIATED , 113) + '00' as datetime), rootnode, parentnode,
childnode) AS D ORDER BY 3, 4
And neither does this
script SELECT hour, rootnode, parentnode, childnode, besvaret, optaget,
opgivet, ubesvaret, total FROM( SELECT rootnode, parentnode, childnode,
COUNT(*) AS total, COUNT(CASE WHEN durationofconversation > 0 THEN 1 END) AS
besvaret, COUNT(CASE WHEN durationofconversation = 0 AND releasecause = 'OC'
THEN 1 END) AS optaget, COUNT(CASE WHEN durationofconversation = 0 AND
releasecause = 'RL' AND durationofcall < 40 THEN 1 END) AS opgivet,
COUNT(CASE WHEN durationofconversation = 0 AND durationofcall >= 40 THEN 1
END) AS ubesvaret, cast(convert(VarChar(15), DATECALLINITIATED , 113) + '00'
as datetime) as hour FROM V2tickets INNER JOIN (SELECT s.serie, a.nodename
as rootnode, cs.nodename as parentnode, c.nodename as childnode FROM areas
a, centers cs, center c, teams t, series s WHERE (a.nodeid=1) and
a.nodeid=cs.parentid and cs.nodeid=c.parentid and c.nodeid=t.parentid and
t.nodeid=s.parentid) AS H ON V2tickets.digits = H.serie WHERE siteid=1 AND
calltype='E' AND LEN(digits) = 4 and DATECALLINITIATED between
convert(smalldatetime, '09-01-2003', 105) and convert(smalldatetime,
'12-09-2008' ,105) and DATECALLINITIATED between convert(smalldatetime,
'00:00:00', 8) and convert(smalldatetime, '23:59:59' ,8) GROUP BY
cast(Convert(VarChar(15), DATECALLINITIATED , 113) + '00' as datetime),
rootnode, parentnode, childnode) AS D ORDER BY 3, 4
Any ideas?
Henry|||On Mon, 28 Mar 2005 08:59:07 +0200, Henry wrote:
(snip)
>When I do a select in the query analyser on the field the format looks like
>this "27-08-2003 00:02:09" which is the standard danish date and time
>format, but does that mean that datetime fields are stored as strings rathe
r
>than a real (float)?
Hi Henry,
Neither. Datetime fields are stored in their own datetime format. (BOL
says that the internal representation uses 2 integers and I have no
reason to disbelieve BOL - but this actually only matters for space
calculations, not for anything else).

> Or is the presentation in the query analyser depending
>on the regional settings?
Yes. As is the presentation by any client. If you use Enterprise Manager
to check the same data, you'll see a different format. And an Access
front-end would probably yield yet another format.
The values are communicated between the client and the server in a
dedicated format that's used specifically for datetime values and the
client formats it.

> I thought that your suggestion above would compare float to float values?
No. It would compare datetime values to datetime values.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Hi Henry,
I forgot to include this link in my previous message:
Tibor Karaszi's ultimate guide to the datetime datatypes:
http://www.karaszi.com/SQLServer/info_datetime.asp
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||On Sun, 27 Mar 2005 18:34:52 +0200, Henry wrote:
(snip)
>Query is using this function to group by the hour
>CREATE FUNCTION fn_getdatetimeperhour (@.DATE datetime)
>RETURNS smalldatetime
>AS
>BEGIN
> declare @.mydatetime smalldatetime
> set @.mydatetime = cast(DATEPART (day, @.DATE ) as varchar(2))+'-'+
> cast(DATEPART (month, @.DATE ) as varchar(2))+'-'+
> cast(DATEPART (year, @.DATE ) as varchar(4))+' '+
> right('0' + ltrim(DATEPART ( hour, @.DATE )), 2 )+':00:00'
> RETURN(@.mydatetime)
>END
>
>I get this error when executing the query.
>Server: Msg 296, Level 16, State 3, Procedure fn_getdatetimeperhour, Line 6
>The conversion of char data type to smalldatetime data type resulted in an
>out-of-range smalldatetime value.
Hi Henry,
The expression in the SET statement builds a string in this format:
dd-mm-yyyy hh:00:00
Since this is assigned to a smalldatetime variable, it has to be
converted. But the format you used is not "safe" - the interpretation
depends on regional settings. The error message suggests that SQL Server
"thinks" that you used the mm-dd-yyyy format.
These formats are always safe:
yyyymmdd - for date only (note: no dashes!)
yyyy-mm-ddThh:mm:ss.ttt - for date and time (note: the T is a literal
uppercase T; the dashes and colons are required and .ttt is an part for
milliseconds)
For truncating to the last hour, an easier and quicker expression would
be
SET @.mydatetime = SELECT DATEADD(hour,
DATEDIFF(hour, '20000101', @.DATE),
'20000101')

>Does anyone have any suggestions on what I'm doing wrong? Basically the
>query works if I leave out the between part from the query
>(cast(convert(char, DATECALLINITIATED, 1) as datetime) between '01/09/03'
>and '01/12/05' ) and
> (cast(convert(char, DATECALLINITIATED, 8) as datetime)
>between '00:00:22' and '23:59:22' )
Apart from the remarks Steva alrady made about this expression, you'd
also be well advise to use an unambiguous format for the datetime
constant. The suggestion made by Steve can be simplified further if you
do, since there's no need to force the correct interpretion on
conversion:
DATECALLINITIATED >= '20030901'
AND DATECALLINITIATED < '20051202'
or (depending on which interpretation of 01/09/03 and 01/12/05 you
intended):
DATECALLINITIATED >= '20030109'
AND DATECALLINITIATED < '20050113'
Another thing: I'm not sure if this expression does what you want (since
you didn't describe what you want). You'll get each datecallinitiated
from the starting date (somewhere in 2003) to the ending date (somewhere
in 2005), but ALL rows that were initiated between 38 seconds before
midnight and 22 seconds after midnight, on any day in the date range,
will be excluded!! Could it be that you actually wanted
DATECALLINITIATED >= '2003-09-01T00:00:22'
AND DATECALLINITIATED <= '2005-12-01T23:59:22'
or
DATECALLINITIATED >= '2003-01-09T00:00:22'
AND DATECALLINITIATED <= '2005-01-12T23:59:22'
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Hi Hugo

> These formats are always safe:
> yyyymmdd - for date only (note: no dashes!)
> yyyy-mm-ddThh:mm:ss.ttt - for date and time (note: the T is a literal
> uppercase T; the dashes and colons are required and .ttt is an part for
> milliseconds)
I think I'll try the one without seperators ;o)

> For truncating to the last hour, an easier and quicker expression would
> be
> SET @.mydatetime = SELECT DATEADD(hour, DATEDIFF(hour, '20000101', @.DATE),
> '20000101')
Don't really get this one

> Apart from the remarks Steva alrady made about this expression, you'd
> also be well advise to use an unambiguous format for the datetime
> constant. The suggestion made by Steve can be simplified further if you
> do, since there's no need to force the correct interpretion on
> conversion:
The problem with the out of range have been solved using Steves suggestions.

> DATECALLINITIATED >= '20030901'
> AND DATECALLINITIATED < '20051202'
> or (depending on which interpretation of 01/09/03 and 01/12/05 you
> intended):
> DATECALLINITIATED >= '20030109'
> AND DATECALLINITIATED < '20050113'
> Another thing: I'm not sure if this expression does what you want (since
> you didn't describe what you want). You'll get each datecallinitiated
> from the starting date (somewhere in 2003) to the ending date (somewhere
> in 2005), but ALL rows that were initiated between 38 seconds before
> midnight and 22 seconds after midnight, on any day in the date range,
> will be excluded!! Could it be that you actually wanted
> DATECALLINITIATED >= '2003-09-01T00:00:22'
> AND DATECALLINITIATED <= '2005-12-01T23:59:22'
> or
> DATECALLINITIATED >= '2003-01-09T00:00:22'
> AND DATECALLINITIATED <= '2005-01-12T23:59:22'
>
Yes, that's exactly what I want, since I want to "window/zoom" a periond of
the day(s) in the date range, but thanks for notifying me on this - it could
have been a mistake.

Problems with carating Stored Procedure from ADO

Hi
I try to create SP from ADO. Open connection and excecute queries.
con.Execute "SET QUOTED_IDENTIFIER OFF "
con.Execute "SET ansinull ON"
con.Execute TextProc
TextProc content
"
create procedure BISSGetDllName (
@.ID_MESS numeric(10) = 0,
@.SwiftOperType int = 0,
@.IsAction int=1
) as
Begin
declare
@.ret int,
@.MessageType int,
@.AccBalance1 int,
@.urgency varchar(1)
select
@.MessageType = MessageType
from BISSHead
where ID_MESS = @.ID_MESS
select @.urgency='s'
from BISSMess
where
ID_MESS=@.ID_MESS and
NumOfField='203B' and
convert(int,ContextOfField)=1
if @.MessageType= 202
begin
if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
NumOfField ='58E')
select '_trbis202.dll','TrBIS2202'+@.urgency+'NR'
else
select '_trbis202.dll','TrBIS2202'+@.urgency
return 1
end
else if @.MessageType= 103
begin
declare @.IsTax int
exec @.ret=BISSIsTax @.ID_MESS, @.IsTax output
if @.ret<>1
return @.ret
if @.IsTax=1
begin
select '_trbistax.dll','TrBISTax'+@.urgency
return 1
end
/*select @.AccBalance1 = convert(int,substring(KorrAccount,1,4))
from BISSMessAddition
where ID_MESS = @.ID_MESS
*/
/*if exists(select 1
from ReportSetup
where
Code = 29 and
Amount1=0 and
AccBalance1<>@.AccBalance1
) */
begin
if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
NumOfField ='57E')
select '_trbiss100.dll','TrBIS100'+@.urgency+'NR'
else
select '_trbiss100.dll','TrBIS100'+@.urgency
return 1
end
end
return -1221
end
"
ADO sad [SYBASE][OLE DB Sybase provider]Value has not been specified for
parameter 1.
May bee ADO find parametrs in Create query.. and want values for parametrs.
How could execute this query...
You need to bind to the return parameter.
Michael
"Dmitry" <Savtchin@.st.by> wrote in message
news:OhPrMFaxEHA.3976@.TK2MSFTNGP09.phx.gbl...
> Hi
> I try to create SP from ADO. Open connection and excecute queries.
> con.Execute "SET QUOTED_IDENTIFIER OFF "
> con.Execute "SET ansinull ON"
> con.Execute TextProc
> TextProc content
> "
> create procedure BISSGetDllName (
> @.ID_MESS numeric(10) = 0,
> @.SwiftOperType int = 0,
> @.IsAction int=1
> ) as
> Begin
> declare
> @.ret int,
> @.MessageType int,
> @.AccBalance1 int,
> @.urgency varchar(1)
> select
> @.MessageType = MessageType
> from BISSHead
> where ID_MESS = @.ID_MESS
> select @.urgency='s'
> from BISSMess
> where
> ID_MESS=@.ID_MESS and
> NumOfField='203B' and
> convert(int,ContextOfField)=1
> if @.MessageType= 202
> begin
> if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
> NumOfField ='58E')
> select '_trbis202.dll','TrBIS2202'+@.urgency+'NR'
> else
> select '_trbis202.dll','TrBIS2202'+@.urgency
> return 1
> end
> else if @.MessageType= 103
> begin
> declare @.IsTax int
> exec @.ret=BISSIsTax @.ID_MESS, @.IsTax output
> if @.ret<>1
> return @.ret
> if @.IsTax=1
> begin
> select '_trbistax.dll','TrBISTax'+@.urgency
> return 1
> end
> /*select @.AccBalance1 = convert(int,substring(KorrAccount,1,4))
> from BISSMessAddition
> where ID_MESS = @.ID_MESS
> */
> /*if exists(select 1
> from ReportSetup
> where
> Code = 29 and
> Amount1=0 and
> AccBalance1<>@.AccBalance1
> ) */
> begin
> if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
> NumOfField ='57E')
> select '_trbiss100.dll','TrBIS100'+@.urgency+'NR'
> else
> select '_trbiss100.dll','TrBIS100'+@.urgency
> return 1
> end
>
> end
> return -1221
> end
> "
> ADO sad [SYBASE][OLE DB Sybase provider]Value has not been specified for
> parameter 1.
> May bee ADO find parametrs in Create query.. and want values for
parametrs.
> How could execute this query...
>
>

Problems with carating Stored Procedure from ADO

Hi
I try to create SP from ADO. Open connection and excecute queries.
con.Execute "SET QUOTED_IDENTIFIER OFF "
con.Execute "SET ansinull ON"
con.Execute TextProc
TextProc content
"
create procedure BISSGetDllName (
@.ID_MESS numeric(10) = 0,
@.SwiftOperType int = 0,
@.IsAction int=1
) as
Begin
declare
@.ret int,
@.MessageType int,
@.AccBalance1 int,
@.urgency varchar(1)
select
@.MessageType = MessageType
from BISSHead
where ID_MESS = @.ID_MESS
select @.urgency='s'
from BISSMess
where
ID_MESS=@.ID_MESS and
NumOfField='203B' and
convert(int,ContextOfField)=1
if @.MessageType= 202
begin
if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
NumOfField ='58E')
select '_trbis202.dll','TrBIS2202'+@.urgency+'NR'
else
select '_trbis202.dll','TrBIS2202'+@.urgency
return 1
end
else if @.MessageType= 103
begin
declare @.IsTax int
exec @.ret=BISSIsTax @.ID_MESS, @.IsTax output
if @.ret<>1
return @.ret
if @.IsTax=1
begin
select '_trbistax.dll','TrBISTax'+@.urgency
return 1
end
/*select @.AccBalance1 = convert(int,substring(KorrAccount,1,4))
from BISSMessAddition
where ID_MESS = @.ID_MESS
*/
/*if exists(select 1
from ReportSetup
where
Code = 29 and
Amount1=0 and
AccBalance1<>@.AccBalance1
) */
begin
if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
NumOfField ='57E')
select '_trbiss100.dll','TrBIS100'+@.urgency+'NR'
else
select '_trbiss100.dll','TrBIS100'+@.urgency
return 1
end
end
return -1221
end
"
ADO sad [SYBASE][OLE DB Sybase provider]Value has not been specified
for
parameter 1.
May bee ADO find parametrs in Create query.. and want values for parametrs.
How could execute this query...You need to bind to the return parameter.
Michael
"Dmitry" <Savtchin@.st.by> wrote in message
news:OhPrMFaxEHA.3976@.TK2MSFTNGP09.phx.gbl...
> Hi
> I try to create SP from ADO. Open connection and excecute queries.
> con.Execute "SET QUOTED_IDENTIFIER OFF "
> con.Execute "SET ansinull ON"
> con.Execute TextProc
> TextProc content
> "
> create procedure BISSGetDllName (
> @.ID_MESS numeric(10) = 0,
> @.SwiftOperType int = 0,
> @.IsAction int=1
> ) as
> Begin
> declare
> @.ret int,
> @.MessageType int,
> @.AccBalance1 int,
> @.urgency varchar(1)
> select
> @.MessageType = MessageType
> from BISSHead
> where ID_MESS = @.ID_MESS
> select @.urgency='s'
> from BISSMess
> where
> ID_MESS=@.ID_MESS and
> NumOfField='203B' and
> convert(int,ContextOfField)=1
> if @.MessageType= 202
> begin
> if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
> NumOfField ='58E')
> select '_trbis202.dll','TrBIS2202'+@.urgency+'NR'
> else
> select '_trbis202.dll','TrBIS2202'+@.urgency
> return 1
> end
> else if @.MessageType= 103
> begin
> declare @.IsTax int
> exec @.ret=BISSIsTax @.ID_MESS, @.IsTax output
> if @.ret<>1
> return @.ret
> if @.IsTax=1
> begin
> select '_trbistax.dll','TrBISTax'+@.urgency
> return 1
> end
> /*select @.AccBalance1 = convert(int,substring(KorrAccount,1,4))
> from BISSMessAddition
> where ID_MESS = @.ID_MESS
> */
> /*if exists(select 1
> from ReportSetup
> where
> Code = 29 and
> Amount1=0 and
> AccBalance1<>@.AccBalance1
> ) */
> begin
> if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
> NumOfField ='57E')
> select '_trbiss100.dll','TrBIS100'+@.urgency+'NR'
> else
> select '_trbiss100.dll','TrBIS100'+@.urgency
> return 1
> end
>
> end
> return -1221
> end
> "
> ADO sad [SYBASE][OLE DB Sybase provider]Value has not been specifi
ed for
> parameter 1.
> May bee ADO find parametrs in Create query.. and want values for
parametrs.
> How could execute this query...
>
>

Problems with carating Stored Procedure from ADO

Hi
I try to create SP from ADO. Open connection and excecute queries.
con.Execute "SET QUOTED_IDENTIFIER OFF "
con.Execute "SET ansinull ON"
con.Execute TextProc
TextProc content
"
create procedure BISSGetDllName (
@.ID_MESS numeric(10) = 0,
@.SwiftOperType int = 0,
@.IsAction int=1
) as
Begin
/************************************************** ********
@.ID_MESS - message
@.SwiftOperType - operation
@.IsAction - action or rollback?
************************************************** *******/
declare
@.ret int,
@.MessageType int,
@.AccBalance1 int,
@.urgency varchar(1)
select
@.MessageType = MessageType
from BISSHead
where ID_MESS = @.ID_MESS
select @.urgency='s'
from BISSMess
where
ID_MESS=@.ID_MESS and
NumOfField='203B' and
convert(int,ContextOfField)=1
/*BIS aaieianeee */
if @.MessageType= 202
begin
if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
NumOfField ='58E')
select '_trbis202.dll','TrBIS2202'+@.urgency+'NR'
else
select '_trbis202.dll','TrBIS2202'+@.urgency
return 1
end
else if @.MessageType= 103
begin
/*BIS iaeiae*/
declare @.IsTax int
exec @.ret=BISSIsTax @.ID_MESS, @.IsTax output
if @.ret<>1
return @.ret
if @.IsTax=1
begin
select '_trbistax.dll','TrBISTax'+@.urgency
return 1
end
/*select @.AccBalance1 = convert(int,substring(KorrAccount,1,4))
from BISSMessAddition
where ID_MESS = @.ID_MESS
*/
/*BIS eeeaioneee*/
/*if exists(select 1
from ReportSetup
where
Code = 29 and
Amount1=0 and
AccBalance1<>@.AccBalance1
) */
begin
if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
NumOfField ='57E')
select '_trbiss100.dll','TrBIS100'+@.urgency+'NR'
else
select '_trbiss100.dll','TrBIS100'+@.urgency
return 1
end
end
return -1221
end
"
ADO sad [SYBASE][OLE DB Sybase provider]Value has not been specified for
parameter 1.
May bee ADO find parametrs in Create query.. and want values for parametrs.
How could execute this query...
Please don't multi-post. And stop using a Sybase provider if you're
connecting to SQL Server! http://www.aspfaq.com/2126
"Dmitry" <Savtchin@.st.by> wrote in message
news:u2irvPaxEHA.3096@.TK2MSFTNGP14.phx.gbl...
> Hi
> I try to create SP from ADO. Open connection and excecute queries.
> con.Execute "SET QUOTED_IDENTIFIER OFF "
> con.Execute "SET ansinull ON"
> con.Execute TextProc
> TextProc content
> "
> create procedure BISSGetDllName (
> @.ID_MESS numeric(10) = 0,
> @.SwiftOperType int = 0,
> @.IsAction int=1
> ) as
> Begin
> /************************************************** ********
> @.ID_MESS - message
> @.SwiftOperType - operation
> @.IsAction - action or rollback?
>
> ************************************************** *******/
> declare
> @.ret int,
> @.MessageType int,
> @.AccBalance1 int,
> @.urgency varchar(1)
> select
> @.MessageType = MessageType
> from BISSHead
> where ID_MESS = @.ID_MESS
> select @.urgency='s'
> from BISSMess
> where
> ID_MESS=@.ID_MESS and
> NumOfField='203B' and
> convert(int,ContextOfField)=1
> /*BIS aaieianeee */
> if @.MessageType= 202
> begin
> if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
> NumOfField ='58E')
> select '_trbis202.dll','TrBIS2202'+@.urgency+'NR'
> else
> select '_trbis202.dll','TrBIS2202'+@.urgency
> return 1
> end
> else if @.MessageType= 103
> begin
> /*BIS iaeiae*/
> declare @.IsTax int
> exec @.ret=BISSIsTax @.ID_MESS, @.IsTax output
> if @.ret<>1
> return @.ret
> if @.IsTax=1
> begin
> select '_trbistax.dll','TrBISTax'+@.urgency
> return 1
> end
> /*select @.AccBalance1 = convert(int,substring(KorrAccount,1,4))
> from BISSMessAddition
> where ID_MESS = @.ID_MESS
> */
> /*BIS eeeaioneee*/
> /*if exists(select 1
> from ReportSetup
> where
> Code = 29 and
> Amount1=0 and
> AccBalance1<>@.AccBalance1
> ) */
> begin
> if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
> NumOfField ='57E')
> select '_trbiss100.dll','TrBIS100'+@.urgency+'NR'
> else
> select '_trbiss100.dll','TrBIS100'+@.urgency
> return 1
> end
>
> end
> return -1221
> end
> "
> ADO sad [SYBASE][OLE DB Sybase provider]Value has not been specified for
> parameter 1.
> May bee ADO find parametrs in Create query.. and want values for
parametrs.
> How could execute this query...
>

Problems with carating Stored Procedure from ADO

Hi
I try to create SP from ADO. Open connection and excecute queries.
con.Execute "SET QUOTED_IDENTIFIER OFF "
con.Execute "SET ansinull ON"
con.Execute TextProc
TextProc content
"
create procedure BISSGetDllName (
@.ID_MESS numeric(10) = 0,
@.SwiftOperType int = 0,
@.IsAction int=1
) as
Begin
/ ****************************************
******************
@.ID_MESS - message
@.SwiftOperType - operation
@.IsAction - action or rollback?
****************************************
*****************/
declare
@.ret int,
@.MessageType int,
@.AccBalance1 int,
@.urgency varchar(1)
select
@.MessageType = MessageType
from BISSHead
where ID_MESS = @.ID_MESS
select @.urgency='s'
from BISSMess
where
ID_MESS=@.ID_MESS and
NumOfField='203B' and
convert(int,ContextOfField)=1
/*BIS aaieianeee */
if @.MessageType= 202
begin
if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
NumOfField ='58E')
select '_trbis202.dll','TrBIS2202'+@.urgency+'NR'
else
select '_trbis202.dll','TrBIS2202'+@.urgency
return 1
end
else if @.MessageType= 103
begin
/*BIS iaeiae*/
declare @.IsTax int
exec @.ret=BISSIsTax @.ID_MESS, @.IsTax output
if @.ret<>1
return @.ret
if @.IsTax=1
begin
select '_trbistax.dll','TrBISTax'+@.urgency
return 1
end
/*select @.AccBalance1 = convert(int,substring(KorrAccount,1,4))
from BISSMessAddition
where ID_MESS = @.ID_MESS
*/
/*BIS eeeaioneee*/
/*if exists(select 1
from ReportSetup
where
Code = 29 and
Amount1=0 and
AccBalance1<>@.AccBalance1
) */
begin
if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
NumOfField ='57E')
select '_trbiss100.dll','TrBIS100'+@.urgency+'NR'
else
select '_trbiss100.dll','TrBIS100'+@.urgency
return 1
end
end
return -1221
end
"
ADO sad [SYBASE][OLE DB Sybase provider]Value has not been specified
for
parameter 1.
May bee ADO find parametrs in Create query.. and want values for parametrs.
How could execute this query...Please don't multi-post. And stop using a Sybase provider if you're
connecting to SQL Server! http://www.aspfaq.com/2126
"Dmitry" <Savtchin@.st.by> wrote in message
news:u2irvPaxEHA.3096@.TK2MSFTNGP14.phx.gbl...
> Hi
> I try to create SP from ADO. Open connection and excecute queries.
> con.Execute "SET QUOTED_IDENTIFIER OFF "
> con.Execute "SET ansinull ON"
> con.Execute TextProc
> TextProc content
> "
> create procedure BISSGetDllName (
> @.ID_MESS numeric(10) = 0,
> @.SwiftOperType int = 0,
> @.IsAction int=1
> ) as
> Begin
> / ****************************************
******************
> @.ID_MESS - message
> @.SwiftOperType - operation
> @.IsAction - action or rollback?
>
> ****************************************
*****************/
> declare
> @.ret int,
> @.MessageType int,
> @.AccBalance1 int,
> @.urgency varchar(1)
> select
> @.MessageType = MessageType
> from BISSHead
> where ID_MESS = @.ID_MESS
> select @.urgency='s'
> from BISSMess
> where
> ID_MESS=@.ID_MESS and
> NumOfField='203B' and
> convert(int,ContextOfField)=1
> /*BIS aaieianeee */
> if @.MessageType= 202
> begin
> if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
> NumOfField ='58E')
> select '_trbis202.dll','TrBIS2202'+@.urgency+'NR'
> else
> select '_trbis202.dll','TrBIS2202'+@.urgency
> return 1
> end
> else if @.MessageType= 103
> begin
> /*BIS iaeiae*/
> declare @.IsTax int
> exec @.ret=BISSIsTax @.ID_MESS, @.IsTax output
> if @.ret<>1
> return @.ret
> if @.IsTax=1
> begin
> select '_trbistax.dll','TrBISTax'+@.urgency
> return 1
> end
> /*select @.AccBalance1 = convert(int,substring(KorrAccount,1,4))
> from BISSMessAddition
> where ID_MESS = @.ID_MESS
> */
> /*BIS eeeaioneee*/
> /*if exists(select 1
> from ReportSetup
> where
> Code = 29 and
> Amount1=0 and
> AccBalance1<>@.AccBalance1
> ) */
> begin
> if exists(select 1 from BISSMess where ID_MESS=@.ID_MESS and
> NumOfField ='57E')
> select '_trbiss100.dll','TrBIS100'+@.urgency+'NR'
> else
> select '_trbiss100.dll','TrBIS100'+@.urgency
> return 1
> end
>
> end
> return -1221
> end
> "
> ADO sad [SYBASE][OLE DB Sybase provider]Value has not been specifi
ed for
> parameter 1.
> May bee ADO find parametrs in Create query.. and want values for
parametrs.
> How could execute this query...
>

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