hi,
i am using instead of trigger in sqlserver 2005, my trigger looks like
create trigger [dbo].[docsUpdate]
on [dbo].[Docs]
instead of update
as
IF (Update(MetaInfo))
BEGIN
bla bla
bla bla
[Some operation]
end
my table looks lke this
Dirname LeafName TimeLastModified Extension Metainfo
-- -- -- -- --
if any data in metainfo column updated then my trigger will get fired
and do respective operation, but when dirname , leafname or any if
other column get modified other them metainfo then how these modified
data will get affected in to my docs table.
Since changes done on table will not get affected due to instead of
trigger, how can i update other column values.
please help me.
thanks
sathya narayanan
narayanan@.gsdindia.comhttp://www.microsoft.com/communitie...c7-cdfb17b609f8
AMB
"sathya" wrote:
> hi,
>
> i am using instead of trigger in sqlserver 2005, my trigger looks like
>
> create trigger [dbo].[docsUpdate]
> on [dbo].[Docs]
> instead of update
> as
> IF (Update(MetaInfo))
> BEGIN
> bla bla
> bla bla
> [Some operation]
> end
> my table looks lke this
>
> Dirname LeafName TimeLastModified Extension Metainfo
> -- -- -- -- --
>
> if any data in metainfo column updated then my trigger will get fired
> and do respective operation, but when dirname , leafname or any if
> other column get modified other them metainfo then how these modified
> data will get affected in to my docs table.
> Since changes done on table will not get affected due to instead of
> trigger, how can i update other column values.
> please help me.
>
> thanks
> sathya narayanan
> narayanan@.gsdindia.com
>sql
Friday, March 30, 2012
problem in instead of Trigger
hi,
i am using trigger as below:
alter TRIGGER Docsdelete
ON Docs
INSTEAD OF DELETE
AS
Declare @.DeletedDocLibRowId int
declare @.Dirname nvarchar(256)
declare @.LeafName nvarchar(128)
set @.Dirname = (SELECT dirname FROM DELETED)
set @.LeafName = (SELECT leafname FROM DELETED)
set @.DeletedDocLibRowId = (SELECT doclibrowid FROM DELETED)
if(@.DeletedDocLibRowId IS NULL)
BEGIN
DELETE docs from deleted where docs.dirname = @.Dirname and
docs.leafname = @.LeafName
END
my problem is that i want to delete row in instead of trigger method,
but when i use this method, i cannot delete my row , the row seems to
be still in table even when i apply my trigger.
please anyone help me in this regard.
sathya naryanan v
narayanan@.gsdindia.comThat a often misunderstanding of triggers.
Trigers are fired per DML Operation rather than per row, so the statement
> DELETE docs from deleted where docs.dirname = @.Dirname and
> docs.leafname = @.LeafName
wont work because if you delete more than one row it will Rollback end with
an error.
> alter TRIGGER Docsdelete
> ON Docs
> INSTEAD OF DELETE
> AS
> Declare @.DeletedDocLibRowId int
> declare @.Dirname nvarchar(256)
> declare @.LeafName nvarchar(128)
> set @.Dirname = (SELECT dirname FROM DELETED)
> set @.LeafName = (SELECT leafname FROM DELETED)
> set @.DeletedDocLibRowId = (SELECT doclibrowid FROM DELETED)
> if (Select COUNT(*) from deleted where DeletedDocLibRowId IS NOT NULL) > 0
> BEGIN
Delete From sometable s--That table you want to delete from
inner join deleted d
on
s.dirname = d.dirname AND
d.leafname = d.leafname
> END
HTH, Jens Suessmeyer.
"sathya" <sathyanarayananit@.gmail.com> wrote in message
news:1122111997.898569.102710@.g43g2000cwa.googlegroups.com...
> hi,
> i am using trigger as below:
> alter TRIGGER Docsdelete
> ON Docs
> INSTEAD OF DELETE
> AS
> Declare @.DeletedDocLibRowId int
> declare @.Dirname nvarchar(256)
> declare @.LeafName nvarchar(128)
> set @.Dirname = (SELECT dirname FROM DELETED)
> set @.LeafName = (SELECT leafname FROM DELETED)
> set @.DeletedDocLibRowId = (SELECT doclibrowid FROM DELETED)
> if(@.DeletedDocLibRowId IS NULL)
> BEGIN
> DELETE docs from deleted where docs.dirname = @.Dirname and
> docs.leafname = @.LeafName
> END
> my problem is that i want to delete row in instead of trigger method,
> but when i use this method, i cannot delete my row , the row seems to
> be still in table even when i apply my trigger.
> please anyone help me in this regard.
>
> sathya naryanan v
> narayanan@.gsdindia.com
>|||On 23 Jul 2005 02:46:37 -0700, sathya wrote:
>hi,
>i am using trigger as below:
>alter TRIGGER Docsdelete
>ON Docs
>INSTEAD OF DELETE
>AS
>Declare @.DeletedDocLibRowId int
>declare @.Dirname nvarchar(256)
>declare @.LeafName nvarchar(128)
>set @.Dirname = (SELECT dirname FROM DELETED)
>set @.LeafName = (SELECT leafname FROM DELETED)
>set @.DeletedDocLibRowId = (SELECT doclibrowid FROM DELETED)
>if(@.DeletedDocLibRowId IS NULL)
>BEGIN
>DELETE docs from deleted where docs.dirname = @.Dirname and
>docs.leafname = @.LeafName
>END
>my problem is that i want to delete row in instead of trigger method,
>but when i use this method, i cannot delete my row , the row seems to
>be still in table even when i apply my trigger.
>please anyone help me in this regard.
Hi sathya,
Jens is correct that this trigger will only work for single-row deletes.
However, if you tested it with single-row deletes, I see no reason why
it would not work. Visual review of the code leads me to believe that
the row will actually be deleted if doclibrowid in the row is NULL, and
it will not be deleted if doclibrowid is anything but NULL.
That being said, it is unneeded to use the "from deleted" in the final
DELETE statement. Remove it, to save SQL Server some extra work.
And when you're busy changing things, why not go ahead and make it
multi-row proof as well. I believe that Jens missed the requirement for
doclibrowid to be NULL, so I'll show you another version. It differs
from Jens' version in two regards: it tests for doclibrowid to be NULL,
and it uses the more standard ANSI-standard DELETE FROM syntax instead
of the proprietary Transact-SQL DELETE FROM FROM syntax.
ALTER TRIGGER Docsdelete
ON docs
INSTEAD OF DELETE
AS
DELETE FROM docs
WHERE EXISTS (SELECT *
FROM deleted
WHERE deleted.dirname = docs.dirname
AND deleted.leafname = docs.leafname
AND deleted.doclibrowid IS NULL)
(untested)
If this still doesn't work, then consider:
a) using an AFTER trigger to rollback unwanted changes instead of using
an INSTEAD OF trigger to execute only the wanted changes - in my
experience, AFTER triggers often prove easier to understand and to
handle.
or
b) post a script that includes CREATE TABLE statements and INSERT
statements so that we can reproduce what you are experiencing. Add the
expected output to your script. See www.aspfaq.com/5006 for more
details.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
i am using trigger as below:
alter TRIGGER Docsdelete
ON Docs
INSTEAD OF DELETE
AS
Declare @.DeletedDocLibRowId int
declare @.Dirname nvarchar(256)
declare @.LeafName nvarchar(128)
set @.Dirname = (SELECT dirname FROM DELETED)
set @.LeafName = (SELECT leafname FROM DELETED)
set @.DeletedDocLibRowId = (SELECT doclibrowid FROM DELETED)
if(@.DeletedDocLibRowId IS NULL)
BEGIN
DELETE docs from deleted where docs.dirname = @.Dirname and
docs.leafname = @.LeafName
END
my problem is that i want to delete row in instead of trigger method,
but when i use this method, i cannot delete my row , the row seems to
be still in table even when i apply my trigger.
please anyone help me in this regard.
sathya naryanan v
narayanan@.gsdindia.comThat a often misunderstanding of triggers.
Trigers are fired per DML Operation rather than per row, so the statement
> DELETE docs from deleted where docs.dirname = @.Dirname and
> docs.leafname = @.LeafName
wont work because if you delete more than one row it will Rollback end with
an error.
> alter TRIGGER Docsdelete
> ON Docs
> INSTEAD OF DELETE
> AS
> Declare @.DeletedDocLibRowId int
> declare @.Dirname nvarchar(256)
> declare @.LeafName nvarchar(128)
> set @.Dirname = (SELECT dirname FROM DELETED)
> set @.LeafName = (SELECT leafname FROM DELETED)
> set @.DeletedDocLibRowId = (SELECT doclibrowid FROM DELETED)
> if (Select COUNT(*) from deleted where DeletedDocLibRowId IS NOT NULL) > 0
> BEGIN
Delete From sometable s--That table you want to delete from
inner join deleted d
on
s.dirname = d.dirname AND
d.leafname = d.leafname
> END
HTH, Jens Suessmeyer.
"sathya" <sathyanarayananit@.gmail.com> wrote in message
news:1122111997.898569.102710@.g43g2000cwa.googlegroups.com...
> hi,
> i am using trigger as below:
> alter TRIGGER Docsdelete
> ON Docs
> INSTEAD OF DELETE
> AS
> Declare @.DeletedDocLibRowId int
> declare @.Dirname nvarchar(256)
> declare @.LeafName nvarchar(128)
> set @.Dirname = (SELECT dirname FROM DELETED)
> set @.LeafName = (SELECT leafname FROM DELETED)
> set @.DeletedDocLibRowId = (SELECT doclibrowid FROM DELETED)
> if(@.DeletedDocLibRowId IS NULL)
> BEGIN
> DELETE docs from deleted where docs.dirname = @.Dirname and
> docs.leafname = @.LeafName
> END
> my problem is that i want to delete row in instead of trigger method,
> but when i use this method, i cannot delete my row , the row seems to
> be still in table even when i apply my trigger.
> please anyone help me in this regard.
>
> sathya naryanan v
> narayanan@.gsdindia.com
>|||On 23 Jul 2005 02:46:37 -0700, sathya wrote:
>hi,
>i am using trigger as below:
>alter TRIGGER Docsdelete
>ON Docs
>INSTEAD OF DELETE
>AS
>Declare @.DeletedDocLibRowId int
>declare @.Dirname nvarchar(256)
>declare @.LeafName nvarchar(128)
>set @.Dirname = (SELECT dirname FROM DELETED)
>set @.LeafName = (SELECT leafname FROM DELETED)
>set @.DeletedDocLibRowId = (SELECT doclibrowid FROM DELETED)
>if(@.DeletedDocLibRowId IS NULL)
>BEGIN
>DELETE docs from deleted where docs.dirname = @.Dirname and
>docs.leafname = @.LeafName
>END
>my problem is that i want to delete row in instead of trigger method,
>but when i use this method, i cannot delete my row , the row seems to
>be still in table even when i apply my trigger.
>please anyone help me in this regard.
Hi sathya,
Jens is correct that this trigger will only work for single-row deletes.
However, if you tested it with single-row deletes, I see no reason why
it would not work. Visual review of the code leads me to believe that
the row will actually be deleted if doclibrowid in the row is NULL, and
it will not be deleted if doclibrowid is anything but NULL.
That being said, it is unneeded to use the "from deleted" in the final
DELETE statement. Remove it, to save SQL Server some extra work.
And when you're busy changing things, why not go ahead and make it
multi-row proof as well. I believe that Jens missed the requirement for
doclibrowid to be NULL, so I'll show you another version. It differs
from Jens' version in two regards: it tests for doclibrowid to be NULL,
and it uses the more standard ANSI-standard DELETE FROM syntax instead
of the proprietary Transact-SQL DELETE FROM FROM syntax.
ALTER TRIGGER Docsdelete
ON docs
INSTEAD OF DELETE
AS
DELETE FROM docs
WHERE EXISTS (SELECT *
FROM deleted
WHERE deleted.dirname = docs.dirname
AND deleted.leafname = docs.leafname
AND deleted.doclibrowid IS NULL)
(untested)
If this still doesn't work, then consider:
a) using an AFTER trigger to rollback unwanted changes instead of using
an INSTEAD OF trigger to execute only the wanted changes - in my
experience, AFTER triggers often prove easier to understand and to
handle.
or
b) post a script that includes CREATE TABLE statements and INSERT
statements so that we can reproduce what you are experiencing. Add the
expected output to your script. See www.aspfaq.com/5006 for more
details.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Problem in instead of trigger
hi,
i am using instead of trigger in sqlserver 2005, my trigger looks like
create trigger [dbo].[docsUpdate]
on [dbo].[Docs]
instead of update
as
IF (Update(MetaInfo))
BEGIN
bla bla
bla bla
[Some operation]
end
my table looks lke this
Dirname LeafName TimeLastModified Extension Metainfo
-- -- -- -- --
if any data in metainfo column updated then my trigger will get fired
and do respective operation, but when dirname , leafname or any if
other column get modified other them metainfo then how these modified
data will get affected in to my docs table.
Since changes done on table will not get affected due to instead of
trigger, how can i update other column values.
please help me.
thanks
sathya narayanan
narayanan@.gsdindia.com
http://www.microsoft.com/communities...7-cdfb17b609f8
AMB
"sathya" wrote:
> hi,
>
> i am using instead of trigger in sqlserver 2005, my trigger looks like
>
> create trigger [dbo].[docsUpdate]
> on [dbo].[Docs]
> instead of update
> as
> IF (Update(MetaInfo))
> BEGIN
> bla bla
> bla bla
> [Some operation]
> end
> my table looks lke this
>
> Dirname LeafName TimeLastModified Extension Metainfo
> -- -- -- -- --
>
> if any data in metainfo column updated then my trigger will get fired
> and do respective operation, but when dirname , leafname or any if
> other column get modified other them metainfo then how these modified
> data will get affected in to my docs table.
> Since changes done on table will not get affected due to instead of
> trigger, how can i update other column values.
> please help me.
>
> thanks
> sathya narayanan
> narayanan@.gsdindia.com
>
i am using instead of trigger in sqlserver 2005, my trigger looks like
create trigger [dbo].[docsUpdate]
on [dbo].[Docs]
instead of update
as
IF (Update(MetaInfo))
BEGIN
bla bla
bla bla
[Some operation]
end
my table looks lke this
Dirname LeafName TimeLastModified Extension Metainfo
-- -- -- -- --
if any data in metainfo column updated then my trigger will get fired
and do respective operation, but when dirname , leafname or any if
other column get modified other them metainfo then how these modified
data will get affected in to my docs table.
Since changes done on table will not get affected due to instead of
trigger, how can i update other column values.
please help me.
thanks
sathya narayanan
narayanan@.gsdindia.com
http://www.microsoft.com/communities...7-cdfb17b609f8
AMB
"sathya" wrote:
> hi,
>
> i am using instead of trigger in sqlserver 2005, my trigger looks like
>
> create trigger [dbo].[docsUpdate]
> on [dbo].[Docs]
> instead of update
> as
> IF (Update(MetaInfo))
> BEGIN
> bla bla
> bla bla
> [Some operation]
> end
> my table looks lke this
>
> Dirname LeafName TimeLastModified Extension Metainfo
> -- -- -- -- --
>
> if any data in metainfo column updated then my trigger will get fired
> and do respective operation, but when dirname , leafname or any if
> other column get modified other them metainfo then how these modified
> data will get affected in to my docs table.
> Since changes done on table will not get affected due to instead of
> trigger, how can i update other column values.
> please help me.
>
> thanks
> sathya narayanan
> narayanan@.gsdindia.com
>
Problem in instead of trigger
hi,
i am using instead of trigger in sqlserver 2005, my trigger looks like
create trigger [dbo].[docsUpdate]
on [dbo].[Docs]
instead of update
as
IF (Update(MetaInfo))
BEGIN
bla bla
bla bla
[Some operation]
end
my table looks lke this
Dirname LeafName TimeLastModified Extension Metainfo
-- -- -- -- --
if any data in metainfo column updated then my trigger will get fired
and do respective operation, but when dirname , leafname or any if
other column get modified other them metainfo then how these modified
data will get affected in to my docs table.
Since changes done on table will not get affected due to instead of
trigger, how can i update other column values.
please help me.
thanks
sathya narayanan
narayanan@.gsdindia.comhttp://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.programming&mid=2144dbff-77b7-4327-b3c7-cdfb17b609f8
AMB
"sathya" wrote:
> hi,
>
> i am using instead of trigger in sqlserver 2005, my trigger looks like
>
> create trigger [dbo].[docsUpdate]
> on [dbo].[Docs]
> instead of update
> as
> IF (Update(MetaInfo))
> BEGIN
> bla bla
> bla bla
> [Some operation]
> end
> my table looks lke this
>
> Dirname LeafName TimeLastModified Extension Metainfo
> -- -- -- -- --
>
> if any data in metainfo column updated then my trigger will get fired
> and do respective operation, but when dirname , leafname or any if
> other column get modified other them metainfo then how these modified
> data will get affected in to my docs table.
> Since changes done on table will not get affected due to instead of
> trigger, how can i update other column values.
> please help me.
>
> thanks
> sathya narayanan
> narayanan@.gsdindia.com
>
i am using instead of trigger in sqlserver 2005, my trigger looks like
create trigger [dbo].[docsUpdate]
on [dbo].[Docs]
instead of update
as
IF (Update(MetaInfo))
BEGIN
bla bla
bla bla
[Some operation]
end
my table looks lke this
Dirname LeafName TimeLastModified Extension Metainfo
-- -- -- -- --
if any data in metainfo column updated then my trigger will get fired
and do respective operation, but when dirname , leafname or any if
other column get modified other them metainfo then how these modified
data will get affected in to my docs table.
Since changes done on table will not get affected due to instead of
trigger, how can i update other column values.
please help me.
thanks
sathya narayanan
narayanan@.gsdindia.comhttp://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.programming&mid=2144dbff-77b7-4327-b3c7-cdfb17b609f8
AMB
"sathya" wrote:
> hi,
>
> i am using instead of trigger in sqlserver 2005, my trigger looks like
>
> create trigger [dbo].[docsUpdate]
> on [dbo].[Docs]
> instead of update
> as
> IF (Update(MetaInfo))
> BEGIN
> bla bla
> bla bla
> [Some operation]
> end
> my table looks lke this
>
> Dirname LeafName TimeLastModified Extension Metainfo
> -- -- -- -- --
>
> if any data in metainfo column updated then my trigger will get fired
> and do respective operation, but when dirname , leafname or any if
> other column get modified other them metainfo then how these modified
> data will get affected in to my docs table.
> Since changes done on table will not get affected due to instead of
> trigger, how can i update other column values.
> please help me.
>
> thanks
> sathya narayanan
> narayanan@.gsdindia.com
>
Problem in Instead of Delete Trigger
Hi,
I have Instead of Delete Trigger in my Table. When i delete any row
from the table it shows the No of Rows affected ex:- 1 Row affected
But when i look into the table the Deleted Row is still Present.
My Question is If there is Instead of Delete Trigger then is it not
possible to delete row from Original table. and if i want to delete the
row using Instead of trigger what i have to do?
If anybody knows the solution Please let me know?
Thanks,
Vinoth
It really depends on what are you doing in the instead of delete trigger. Do
you actually delete the row in the trigger? Please post sample code from the
trigger if you need more help (desired result and sample data/table would be
helpful...)
MC
<vinoth@.gsdindia.com> wrote in message
news:1132308519.761801.276040@.g49g2000cwa.googlegr oups.com...
> Hi,
> I have Instead of Delete Trigger in my Table. When i delete any row
> from the table it shows the No of Rows affected ex:- 1 Row affected
> But when i look into the table the Deleted Row is still Present.
> My Question is If there is Instead of Delete Trigger then is it not
> possible to delete row from Original table. and if i want to delete the
> row using Instead of trigger what i have to do?
> If anybody knows the solution Please let me know?
>
> Thanks,
> Vinoth
>
|||Hi,
if I understand you correct you're deleteing a record and your trigger is
firing reporting the number of rows affected ? So far so good. If this
was
a normal "After" trigger the record would be deleted in the table. An
instead of trigger is different. The delete actually take place in the
table. You have to do that by yourself.
So in your trigger code you could do something like this :
Delete from table where id=(Select id from deleted)
But why are you using an instead of trigger and not an after trigger ?
Normally you use instead of triggers when you want to handle the dml
action
yourself for instance in partitioned views.
Regards
Bobby Henningsen
"MC" <marko_culo#@.#yahoo#.#com#> wrote in message
news:eHrFsqC7FHA.476@.TK2MSFTNGP15.phx.gbl...
> It really depends on what are you doing in the instead of delete
trigger.
> Do you actually delete the row in the trigger? Please post sample code
> from the trigger if you need more help (desired result and sample
> data/table would be helpful...)
>
> MC
>
> <vinoth@.gsdindia.com> wrote in message
> news:1132308519.761801.276040@.g49g2000cwa.googlegr oups.com...
>
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f? 711 spam-mails.
Betalende brugere f?r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk
I have Instead of Delete Trigger in my Table. When i delete any row
from the table it shows the No of Rows affected ex:- 1 Row affected
But when i look into the table the Deleted Row is still Present.
My Question is If there is Instead of Delete Trigger then is it not
possible to delete row from Original table. and if i want to delete the
row using Instead of trigger what i have to do?
If anybody knows the solution Please let me know?
Thanks,
Vinoth
It really depends on what are you doing in the instead of delete trigger. Do
you actually delete the row in the trigger? Please post sample code from the
trigger if you need more help (desired result and sample data/table would be
helpful...)
MC
<vinoth@.gsdindia.com> wrote in message
news:1132308519.761801.276040@.g49g2000cwa.googlegr oups.com...
> Hi,
> I have Instead of Delete Trigger in my Table. When i delete any row
> from the table it shows the No of Rows affected ex:- 1 Row affected
> But when i look into the table the Deleted Row is still Present.
> My Question is If there is Instead of Delete Trigger then is it not
> possible to delete row from Original table. and if i want to delete the
> row using Instead of trigger what i have to do?
> If anybody knows the solution Please let me know?
>
> Thanks,
> Vinoth
>
|||Hi,
if I understand you correct you're deleteing a record and your trigger is
firing reporting the number of rows affected ? So far so good. If this
was
a normal "After" trigger the record would be deleted in the table. An
instead of trigger is different. The delete actually take place in the
table. You have to do that by yourself.
So in your trigger code you could do something like this :
Delete from table where id=(Select id from deleted)
But why are you using an instead of trigger and not an after trigger ?
Normally you use instead of triggers when you want to handle the dml
action
yourself for instance in partitioned views.
Regards
Bobby Henningsen
"MC" <marko_culo#@.#yahoo#.#com#> wrote in message
news:eHrFsqC7FHA.476@.TK2MSFTNGP15.phx.gbl...
> It really depends on what are you doing in the instead of delete
trigger.
> Do you actually delete the row in the trigger? Please post sample code
> from the trigger if you need more help (desired result and sample
> data/table would be helpful...)
>
> MC
>
> <vinoth@.gsdindia.com> wrote in message
> news:1132308519.761801.276040@.g49g2000cwa.googlegr oups.com...
>
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f? 711 spam-mails.
Betalende brugere f?r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk
Problem in Instead of Delete Trigger
Hi,
I have Instead of Delete Trigger in my Table. When i delete any row
from the table it shows the No of Rows affected ex:- 1 Row affected
But when i look into the table the Deleted Row is still Present.
My Question is If there is Instead of Delete Trigger then is it not
possible to delete row from Original table. and if i want to delete the
row using Instead of trigger what i have to do?
If anybody knows the solution Please let me know?
Thanks,
VinothIt really depends on what are you doing in the instead of delete trigger. Do
you actually delete the row in the trigger? Please post sample code from the
trigger if you need more help (desired result and sample data/table would be
helpful...)
MC
<vinoth@.gsdindia.com> wrote in message
news:1132308519.761801.276040@.g49g2000cwa.googlegroups.com...
> Hi,
> I have Instead of Delete Trigger in my Table. When i delete any row
> from the table it shows the No of Rows affected ex:- 1 Row affected
> But when i look into the table the Deleted Row is still Present.
> My Question is If there is Instead of Delete Trigger then is it not
> possible to delete row from Original table. and if i want to delete the
> row using Instead of trigger what i have to do?
> If anybody knows the solution Please let me know?
>
> Thanks,
> Vinoth
>|||Hi,
if I understand you correct you're deleteing a record and your trigger is
firing reporting the number of rows affected ' So far so good. If this
was
a normal "After" trigger the record would be deleted in the table. An
instead of trigger is different. The delete actually take place in the
table. You have to do that by yourself.
So in your trigger code you could do something like this :
Delete from table where id=(Select id from deleted)
But why are you using an instead of trigger and not an after trigger ?
Normally you use instead of triggers when you want to handle the dml
action
yourself for instance in partitioned views.
Regards :)
Bobby Henningsen
"MC" <marko_culo#@.#yahoo#.#com#> wrote in message
news:eHrFsqC7FHA.476@.TK2MSFTNGP15.phx.gbl...
> It really depends on what are you doing in the instead of delete
trigger.
> Do you actually delete the row in the trigger? Please post sample code
> from the trigger if you need more help (desired result and sample
> data/table would be helpful...)
>
> MC
>
> <vinoth@.gsdindia.com> wrote in message
> news:1132308519.761801.276040@.g49g2000cwa.googlegroups.com...
>> Hi,
>> I have Instead of Delete Trigger in my Table. When i delete any row
>> from the table it shows the No of Rows affected ex:- 1 Row affected
>> But when i look into the table the Deleted Row is still Present.
>> My Question is If there is Instead of Delete Trigger then is it not
>> possible to delete row from Original table. and if i want to delete the
>> row using Instead of trigger what i have to do?
>> If anybody knows the solution Please let me know?
>>
>> Thanks,
>> Vinoth
>
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at få 711 spam-mails.
Betalende brugere får ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dksql
I have Instead of Delete Trigger in my Table. When i delete any row
from the table it shows the No of Rows affected ex:- 1 Row affected
But when i look into the table the Deleted Row is still Present.
My Question is If there is Instead of Delete Trigger then is it not
possible to delete row from Original table. and if i want to delete the
row using Instead of trigger what i have to do?
If anybody knows the solution Please let me know?
Thanks,
VinothIt really depends on what are you doing in the instead of delete trigger. Do
you actually delete the row in the trigger? Please post sample code from the
trigger if you need more help (desired result and sample data/table would be
helpful...)
MC
<vinoth@.gsdindia.com> wrote in message
news:1132308519.761801.276040@.g49g2000cwa.googlegroups.com...
> Hi,
> I have Instead of Delete Trigger in my Table. When i delete any row
> from the table it shows the No of Rows affected ex:- 1 Row affected
> But when i look into the table the Deleted Row is still Present.
> My Question is If there is Instead of Delete Trigger then is it not
> possible to delete row from Original table. and if i want to delete the
> row using Instead of trigger what i have to do?
> If anybody knows the solution Please let me know?
>
> Thanks,
> Vinoth
>|||Hi,
if I understand you correct you're deleteing a record and your trigger is
firing reporting the number of rows affected ' So far so good. If this
was
a normal "After" trigger the record would be deleted in the table. An
instead of trigger is different. The delete actually take place in the
table. You have to do that by yourself.
So in your trigger code you could do something like this :
Delete from table where id=(Select id from deleted)
But why are you using an instead of trigger and not an after trigger ?
Normally you use instead of triggers when you want to handle the dml
action
yourself for instance in partitioned views.
Regards :)
Bobby Henningsen
"MC" <marko_culo#@.#yahoo#.#com#> wrote in message
news:eHrFsqC7FHA.476@.TK2MSFTNGP15.phx.gbl...
> It really depends on what are you doing in the instead of delete
trigger.
> Do you actually delete the row in the trigger? Please post sample code
> from the trigger if you need more help (desired result and sample
> data/table would be helpful...)
>
> MC
>
> <vinoth@.gsdindia.com> wrote in message
> news:1132308519.761801.276040@.g49g2000cwa.googlegroups.com...
>> Hi,
>> I have Instead of Delete Trigger in my Table. When i delete any row
>> from the table it shows the No of Rows affected ex:- 1 Row affected
>> But when i look into the table the Deleted Row is still Present.
>> My Question is If there is Instead of Delete Trigger then is it not
>> possible to delete row from Original table. and if i want to delete the
>> row using Instead of trigger what i have to do?
>> If anybody knows the solution Please let me know?
>>
>> Thanks,
>> Vinoth
>
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at få 711 spam-mails.
Betalende brugere får ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dksql
Problem in Instead of Delete Trigger
Hi,
I have Instead of Delete Trigger in my Table. When i delete any row
from the table it shows the No of Rows affected ex:- 1 Row affected
But when i look into the table the Deleted Row is still Present.
My Question is If there is Instead of Delete Trigger then is it not
possible to delete row from Original table. and if i want to delete the
row using Instead of trigger what i have to do?
If anybody knows the solution Please let me know?
Thanks,
VinothHi ,
You cannot delete rows from a table which has a instead of delete trigger
configured.
Though, We can put delete statement for the table inside instead of trigger
but we need to keep RECURSIVE_TRIGGERS database option set correctly. This D
B
option will not cause trigger to fire again.
But still I am not sure why do you want to delete row from a trigger which
has instead of delete trigger configured.
--
Vishal Khajuria
9886170165
IBM Bangalore
"vinoth@.gsdindia.com" wrote:
> Hi,
> I have Instead of Delete Trigger in my Table. When i delete any row
> from the table it shows the No of Rows affected ex:- 1 Row affected
> But when i look into the table the Deleted Row is still Present.
> My Question is If there is Instead of Delete Trigger then is it not
> possible to delete row from Original table. and if i want to delete the
> row using Instead of trigger what i have to do?
> If anybody knows the solution Please let me know?
>
> Thanks,
> Vinoth
>
I have Instead of Delete Trigger in my Table. When i delete any row
from the table it shows the No of Rows affected ex:- 1 Row affected
But when i look into the table the Deleted Row is still Present.
My Question is If there is Instead of Delete Trigger then is it not
possible to delete row from Original table. and if i want to delete the
row using Instead of trigger what i have to do?
If anybody knows the solution Please let me know?
Thanks,
VinothHi ,
You cannot delete rows from a table which has a instead of delete trigger
configured.
Though, We can put delete statement for the table inside instead of trigger
but we need to keep RECURSIVE_TRIGGERS database option set correctly. This D
B
option will not cause trigger to fire again.
But still I am not sure why do you want to delete row from a trigger which
has instead of delete trigger configured.
--
Vishal Khajuria
9886170165
IBM Bangalore
"vinoth@.gsdindia.com" wrote:
> Hi,
> I have Instead of Delete Trigger in my Table. When i delete any row
> from the table it shows the No of Rows affected ex:- 1 Row affected
> But when i look into the table the Deleted Row is still Present.
> My Question is If there is Instead of Delete Trigger then is it not
> possible to delete row from Original table. and if i want to delete the
> row using Instead of trigger what i have to do?
> If anybody knows the solution Please let me know?
>
> Thanks,
> Vinoth
>
Problem in Instead of Delete Trigger
Hi,
I have Instead of Delete Trigger in my Table. When i delete any row
from the table it shows the No of Rows affected ex:- 1 Row affected
But when i look into the table the Deleted Row is still Present.
My Question is If there is Instead of Delete Trigger then is it not
possible to delete row from Original table. and if i want to delete the
row using Instead of trigger what i have to do?
If anybody knows the solution Please let me know?
Thanks,
VinothIt really depends on what are you doing in the instead of delete trigger. Do
you actually delete the row in the trigger? Please post sample code from the
trigger if you need more help (desired result and sample data/table would be
helpful...)
MC
<vinoth@.gsdindia.com> wrote in message
news:1132308519.761801.276040@.g49g2000cwa.googlegroups.com...
> Hi,
> I have Instead of Delete Trigger in my Table. When i delete any row
> from the table it shows the No of Rows affected ex:- 1 Row affected
> But when i look into the table the Deleted Row is still Present.
> My Question is If there is Instead of Delete Trigger then is it not
> possible to delete row from Original table. and if i want to delete the
> row using Instead of trigger what i have to do?
> If anybody knows the solution Please let me know?
>
> Thanks,
> Vinoth
>|||Hi,
if I understand you correct you're deleteing a record and your trigger is
firing reporting the number of rows affected ' So far so good. If this
was
a normal "After" trigger the record would be deleted in the table. An
instead of trigger is different. The delete actually take place in the
table. You have to do that by yourself.
So in your trigger code you could do something like this :
Delete from table where id=(Select id from deleted)
But why are you using an instead of trigger and not an after trigger ?
Normally you use instead of triggers when you want to handle the dml
action
yourself for instance in partitioned views.
Regards
Bobby Henningsen
"MC" <marko_culo#@.#yahoo#.#com#> wrote in message
news:eHrFsqC7FHA.476@.TK2MSFTNGP15.phx.gbl...
> It really depends on what are you doing in the instead of delete
trigger.
> Do you actually delete the row in the trigger? Please post sample code
> from the trigger if you need more help (desired result and sample
> data/table would be helpful...)
>
> MC
>
> <vinoth@.gsdindia.com> wrote in message
> news:1132308519.761801.276040@.g49g2000cwa.googlegroups.com...
>
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f? 711 spam-mails.
Betalende brugere f?r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk
I have Instead of Delete Trigger in my Table. When i delete any row
from the table it shows the No of Rows affected ex:- 1 Row affected
But when i look into the table the Deleted Row is still Present.
My Question is If there is Instead of Delete Trigger then is it not
possible to delete row from Original table. and if i want to delete the
row using Instead of trigger what i have to do?
If anybody knows the solution Please let me know?
Thanks,
VinothIt really depends on what are you doing in the instead of delete trigger. Do
you actually delete the row in the trigger? Please post sample code from the
trigger if you need more help (desired result and sample data/table would be
helpful...)
MC
<vinoth@.gsdindia.com> wrote in message
news:1132308519.761801.276040@.g49g2000cwa.googlegroups.com...
> Hi,
> I have Instead of Delete Trigger in my Table. When i delete any row
> from the table it shows the No of Rows affected ex:- 1 Row affected
> But when i look into the table the Deleted Row is still Present.
> My Question is If there is Instead of Delete Trigger then is it not
> possible to delete row from Original table. and if i want to delete the
> row using Instead of trigger what i have to do?
> If anybody knows the solution Please let me know?
>
> Thanks,
> Vinoth
>|||Hi,
if I understand you correct you're deleteing a record and your trigger is
firing reporting the number of rows affected ' So far so good. If this
was
a normal "After" trigger the record would be deleted in the table. An
instead of trigger is different. The delete actually take place in the
table. You have to do that by yourself.
So in your trigger code you could do something like this :
Delete from table where id=(Select id from deleted)
But why are you using an instead of trigger and not an after trigger ?
Normally you use instead of triggers when you want to handle the dml
action
yourself for instance in partitioned views.
Regards
Bobby Henningsen
"MC" <marko_culo#@.#yahoo#.#com#> wrote in message
news:eHrFsqC7FHA.476@.TK2MSFTNGP15.phx.gbl...
> It really depends on what are you doing in the instead of delete
trigger.
> Do you actually delete the row in the trigger? Please post sample code
> from the trigger if you need more help (desired result and sample
> data/table would be helpful...)
>
> MC
>
> <vinoth@.gsdindia.com> wrote in message
> news:1132308519.761801.276040@.g49g2000cwa.googlegroups.com...
>
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f? 711 spam-mails.
Betalende brugere f?r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk
Problem in installing SQLSERVER2000 Developer Edition
Dear friends,
I tried to install my SQLServer2000 Developer
Edition in my server machine, which is running on the OS
Windows Server 2000.
I am getting the following errors
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
driver={sql server};server=CSPL\CSPL2K;UID=sa;PWD=;database=ma ster
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
driver={sql server};server=CSPL\CSPL2K;UID=sa;PWD=;database=ma ster
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
SQL Server configuration failed.
What is the problem?
Also, i herewith attached the error log file.
Kindly give me the solution and it is very urgent.
with regards,
T.Thirumalairajan B.E
begin 666 sqlstp.log
M,3@.Z,#0Z-# @.0F5G:6X@.4V5T=7 -"C$X.C T.C0P(#@.N,# N,3DT#0HQ.#HP
M-#HT,"!-;V1E(#T@.3F]R;6%L#0HQ.#HP-#HT,"!-;V1E5'EP92 ]($Y/4DU!
M3 T*,3@.Z,#0Z-# @.1V5T1&5F:6YI=&EO;D5X(')E='5R;F5D.B P+"!%>'1E
M;F1E9#H@.,'AF,# P,# -"C$X.C T.C0P(%9A;'5E1E13(')E='5R;F5D.B Q
M#0HQ.#HP-#HT,"!686QU95!)1"!R971U<FYE9#H@.,0T*,3@.Z,#0Z-# @.5F%L
M=65,:6,@.<F5T=7)N960Z(# -"C$X.C T.C0P(%-Y<W1E;3H@.5VEN9&]W<R!.
M5"!497)M:6YA;"!397)V97(-"C$X.C T.C0P(%-13"!397)V97(@.4')O9'5C
M=%1Y<&4Z($1E=F5L;W!E<B!%9&ET:6]N(%LP>#-=#0HQ.#HP-#HT,"!"96=I
M;B!!8W1I;VXZ(%-E='5P26YI=&EA;&EZ92 -"C$X.C T.C0P($5N9"!!8W1I
M;VX@.4V5T=7!);FET:6%L:7IE#0HQ.#HP-#HT,"!"96=I;B!!8W1I;VXZ("!3
M971U<$EN<W1A;&P-"C$X.C T.C0P(%)E861I;F<@.4V]F='=A<F5<36EC<F]S
M;V9T7%=I;F1O=W-<0W5R<F5N=%9E<G-I;VY<0V]M;6]N1FEL97-$:7(@.+BXN
M#0HQ.#HP-#HT,"!#;VUM;VY&:6QE<T1I<CU#.EQ0<F]G<F%M($9I;&5S7$-O
M;6UO;B!&:6QE<PT*,3@.Z,#0Z-# @.5VEN9&]W<R!$:7)E8W1O<GD]0SI<5TE.
M3E1<#0HQ.#HP-#HT,"!0<F]G<F%M($9I;&5S/4,Z7%!R;V=R86T@.1FEL97-<
M#0HQ.#HP-#HT,"!414U01$E2/4,Z7$1/0U5-17XQ7$%$34E.27XQ7$Q/0T%,
M4WXQ7%1E;7!<#0HQ.#HP-#HT,"!"96=I;B!!8W1I;VXZ("!3971U<$EN<W1A
M;&P-"C$X.C T.C0P(&1I9W!I9"!S:7IE(#H@.,C4V#0HQ.#HP-#HT,"!D:6=P
M:60@.<VEZ92 Z(#$V- T*,3@.Z,#0Z-# @.0F5G:6X@.06-T:6]N.B @.0VAE8VM&
M:7AE9%)E<75I<F5M96YT<PT*,3@.Z,#0Z-# @.4&QA=&9O<FT@.240Z(#!X9C P
M#0HQ.#HP-#HT,"!697)S:6]N.B U+C N,C$Y-0T*,3@.Z,#0Z-# @.1FEL92!6
M97)S:6]N("T@.0SI<5TE.3E1<<WES=&5M,S)<<VAD;V-V=RYD;&PZ(#4N,"XS
M-3(V+C@.P, T*,3@.Z,#0Z-# @.16YD($%C=&EO;CH@.($-H96-K1FEX961297%U
M:7)E;65N=',-"C$X.C T.C0P($)E9VEN($%C=&EO;CH@.(%-H;W=$:6%L;V=S
M#0HQ.#HP-#HT,"!);FET:6%L($1I86QO9R!-87-K.B P>#@.S,# P9C<L($1I
M<V%B;&4@.0F%C:STP>#$-"C$X.C T.C0Q($)E9VEN($%C=&EO;B!3:&]W1&EA
M;&]G<TAL<'(Z(#!X,0T*,3@.Z,#0Z-#$@.0F5G:6X@.06-T:6]N.B @.1&EA;&]G
M4VAO=U-D5V5L8V]M90T*,3@.Z,#0Z-#(@.16YD($%C=&EO;B @.1&EA;&]G4VAO
M=U-D5V5L8V]M90T*,3@.Z,#0Z-#(@.1&EA;&]G(#!X,2!R971U<FYE9#H@.,0T*
M,3@.Z,#0Z-#(@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$X.C T.C0R
M(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP>#(L
M:6YD97@.],0T*,3@.Z,#0Z-#(@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP
M<CH@.,'@.R#0HQ.#HP-#HT,B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1-
M86-H:6YE3F%M90T*,3@.Z,#0Z-#0@.4VAO=T1L9TUA8VAI;F4@.<F5T=7)N960Z
M(#$-"C$X.C T.C0T($YA;64@./2!#4U!,+"!4>7!E(#T@.,'@.Q#0HQ.#HP-#HT
M-"!"96=I;B!!8W1I;VXZ("!#:&5C:U)E<75I<F5M96YT<PT*,3@. Z,#0Z-#0@.
M4')O8V5S<V]R($%R8VAI=&5C='5R93H@.>#@.V("A096YT:75M*0T*,3@.Z,#0Z
M-#0@.4V5R=FEC92!086-K.B @.-S8X#0HQ.#HP-#HT-"!#;VUP=71E<DYA;64Z
M($-34$P-"C$X.C T.C0T(%5S97(@.3F%M93H@.061M:6YI<W1R871O<@.T*,3@.Z
M,#0Z-#0@.27-!;&Q!8V-E<W-!;&QO=V5D(')E='5R;F5D.B Q#0HQ.#HP-#HT
M-"!/4R!,86YG=6%G93H@.,'@.T,#D-"C$X.C T.C0T($5N9"!!8W1I;VX@.0VAE
M8VM297%U:7)E;65N=',-"C$X.C T.C0T($-R96%T95-E='5P5&]P;VQO9WDH
M0U-03"DL($AA;F1L92 Z(#!X,3@.Y-#$T,"P@.<F5T=7)N960@..B P#0HQ.#HP
M-#HT-"!#<F5A=&53971U<%1O<&]L;V=Y(')E='5R;F5D(#H@.,"P@.2&%N9&QE
M(#H@.,'@.Q.#DT,30P#0HQ.#HP-#HT-"!4;W!O;&]G>2!4>7!E(#H@.,2P@.4F5T
M=7)N(%9A;'5E(#H@., T*,3@.Z,#0Z-#0@.4U1?1V5T4&AY<VEC86Q.;V1E(')E
M='5R;F5D(#H@.,"P@.4$Y(86YD;&4@..B P>#$X.30Q-C@.-"C$X.C T.C0T(%!.
M7T5N=6UE<F%T945X(')E='5R;F5D(#H@., T*,3@.Z,#0Z-#0@.4$Y?1V5T4U%,
M4W1A=&5S(')E='5R;F5D(#H@.,"P@.4W%L4W1A=&5S(#H@.,'@.R, C<-"C$X.C T
M.C0T(%!.7U-T87)T4V-A;B!;,'@.Q.#DT,38X72!R971U<FYE9" Z(# -"C$X
M.C T.C0T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N960@..B Q."P@.
M2&%N9&QE.B!;,'@.P70T*,3@.Z,#0Z-#0@.3F\@.;6]R92!I=&5M<R!I;B!E;G5M
M97)A=&EO;BX-"C$X.C T.C0T(%)E;&5A<V53971U<%1O<&]L;V=Y#0HQ.#HP
M-#HT-"!.86UE9"!I;G-T86YC92!L:6UI=#H@.,3 P+"!Q=6]T83H@., T*,3@.Z
M,#0Z-#0@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C$X
M.C T.C0T(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#0Z-#0@.
M;D9U;&Q-87-K(#T@.,'@.X,S P,&8W+"!N0W5R<F5N=" ](#!X,BP@.;D1I<F5C
M=&EO;B ](# -"C$X.C T.C0T(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X8F8P
M,# S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ.#HP-#HT-"!$:6%L;V<@.,'@.R
M(')E='5R;F5D.B P#0HQ.#HP-#HT-"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S
M2&QP<@.T*,3@.Z,#0Z-#0@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z
M(&Y#=7)R96YT/3!X-"QI;F1E>#TR#0HQ.#HP-#HT-"!"96=I;B!!8W1I;VX@.
M4VAO=T1I86QO9W-(;'!R.B P>#0-"C$X.C T.C0T($)E9VEN($%C=&EO;CH@.
M($1I86QO9U-H;W=39$EN<W1A;&Q-;V1E#0HQ.#HP-#HU-2!3:&]W1&QG26YS
M=&%L;$UO9&4@.<F5T=7)N960Z(#$-"C$X.C T.C4U($EN<W1A;&Q-;V1E(#H@.
M,'@.Q#0HQ.#HP-#HU-2!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V1);G-T86QL
M36]D90T*,3@.Z,#0Z-34@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ
M.#HP-#HU-2!N1G5L;$UA<VL@./2 P>&)F,# P,S<L(&Y#=7)R96YT(#T@.,'@.T
M+"!N1&ER96-T:6]N(#T@.,0T*,3@.Z,#0Z-34@.57!D871E9"!$:6%L;V<@.36%S
M:SH@.,'AB9C0P,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$X.C T.C4U($1I
M86QO9R P>#0@.<F5T=7)N960Z(#$-"C$X.C T.C4U($5N9"!!8W1I;VX@.4VAO
M=T1I86QO9W-(;'!R#0HQ.#HP-#HU-2!3:&]W1&EA;&]G<T=E=$1I86QO9R!R
M971U<FYE9#H@.;D-U<G)E;G0],'@.Q,"QI;F1E>#TT#0HQ.#HP-#HU-2!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$P#0HQ.#HP-#HU-2!"96=I
M;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,3@.Z,#0Z
M-38@.16YD($%C=&EO;B!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,3@.Z
M,#0Z-38@.1&EA;&]G(#!X,3 @.<F5T=7)N960Z(#$-"C$X.C T.C4V($5N9"!!
M8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HQ.#HP-#HU-B!3:&]W1&EA;&]G<T=E
M=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.R,"QI;F1E>#TU#0HQ.#HP
M-#HU-B!"96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#(P#0HQ.#HP
M-#HU-B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1,:6-E;G-E#0HQ.#HP
M-#HU.2!%;F0@.06-T:6]N($1I86QO9U-H;W=39$QI8V5N<V4-"C$X.C T.C4Y
M($1I86QO9R P>#(P(')E='5R;F5D.B Q#0HQ.#HP-#HU.2!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#0Z-3D@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X-# P,# L:6YD97@.],3@.-"C$X.C T
M.C4Y($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# -"C$X
M.C T.C4Y($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$-L:5-V<@.T*,3@.Z
M,#0Z-3D@.1&ES<&QA>5-Y<W1E;5!R95)E<0T*,3@.Z,#4Z,#,@.4VAO=T1L9T-L
M:65N=%-E<G9E<E-E;&5C="!R971U<FYE9#H@.,0T*,3@.Z,#4Z,#,@.5'EP92 Z
M(#!X,@.T*,3@.Z,#4Z,#,@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQI4W9R
M#0HQ.#HP-3HP,R!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$X.C U
M.C S(&Y&=6QL36%S:R ](#!X8F8T,# S-RP@.;D-U<G)E;G0@./2 P>#0P,# P
M+"!N1&ER96-T:6]N(#T@.,0T*,3@.Z,#4Z,#,@.57!D871E9"!$:6%L;V<@.36%S
M:SH@.,'AB9F,P,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$X.C U.C S($1I
M86QO9R P>#0P,# P(')E='5R;F5D.B Q#0HQ.#HP-3HP,R!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#4Z,#,@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# L:6YD97@.],3D-"C$X.C U
M.C S($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X.# P,# -"C$X
M.C U.C S($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$EN<W1A;F-E3F%M
M90T*,3@.Z,#4Z,#,@.0F5G:6X@.06-T:6]N.B!3:&]W1&QG26YS=&%N8V5.86UE
M#0HQ.#HP-3HP."!%;F0@.06-T:6]N.B!3:&]W1&QG26YS=&%N8V5.86UE#0HQ
M.#HP-3HP."!3:&]W1&QG26YS=&%N8V5.86UE(')E='5R;F5D(#H@.,0T*,3@.Z
M,#4Z,#@.@.26YS=&%N8V5.86UE(#H@.0U-03#)+#0HQ.#HP-3HP."!%;F0@.06-T
M:6]N("!$:6%L;V=3:&]W4V1);G-T86YC94YA;64-"C$X.C U.C X(&)E9VEN
M(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#4Z,#@.@.;D9U;&Q-87-K(#T@.
M,'AB9F,P,#,W+"!N0W5R<F5N=" ](#!X.# P,# L(&Y$:7)E8W1I;VX@./2 Q
M#0HQ.#HP-3HP."!5<&1A=&5D($1I86QO9R!-87-K.B P>&)F8S P,S<L($1I
M<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#4Z,#@.@.1&EA;&]G(#!X.# P,# @.<F5T
M=7)N960Z(#$-"C$X.C U.C X($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R
M#0HQ.#HP-3HP."!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U
M<G)E;G0],'@.Q,# P,# L:6YD97@.],C -"C$X.C U.C X($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# P#0HQ.#HP-3HP."!"96=I;B!!
M8W1I;VXZ("!$:6%L;V=3:&]W4V13971U<%1Y<&4-"C$X.C U.C X($)E9VEN
M($%C=&EO;CH@.4V5T=7 @.5'EP90T*,3@.Z,#4Z-3(@.4U%,('!R;V=R86T@.9F]L
M9&5R.B!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HQ
M.#HP-3HU,B!344P@.9&%T82!F;VQD97(Z($0Z7%!R;V=R86T@.1FEL97-<36EC
M<F]S;V9T(%-13"!397)V97(-"C$X.C U.C4R(%=I;F1O=W,@.<WES=&5M(&9O
M;&1E<CH@.0SI<5TE.3E1<<WES=&5M,S)<#0HQ.#HP-3HU,B!0<F]G(')E<3H@.
M,S0W.#DL($1A=&$@.<F5Q.B S-#0S,BP@.4WES(')E<3H@.,3,R,38X#0HQ.#HP
M-3HU,B!0<F]G(&%V86EL.B Q-30S.3$R+"!$871A(&%V86EL.B Q-30S.3$R
M+"!3>7,@.879A:6PZ(#4U,C<S,S8-"C$X.C U.C4R(%!R;V<@.<F5Q('9S+B!A
M=F%I;"P@.-CDR,C$L(#$U-#,Y,3(-"C$X.C U.C4R($1A=&$@.<F5Q('9S+B!A
M=F%I;"P@.,S0T,S(L(#$U-#,Y,3(-"C$X.C U.C4R(%-Y<R!R97$@.=G,N(&%V
M86EL+" Q,S(Q-C@.L(#4U,C<S,S8-"C$X.C U.C4R($1I<W!L87E3>7-T96U0
M<F5297$-"C$X.C U.C4R(%M3971U<%1Y<&5344Q=#0HQ.#HP-3HU,B!S>D1I
M<B ]($0Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T(%-13"!397)V97(-"C$X
M.C U.C4R('-Z1&ER(#T@.1#I<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,
M(%-E<G9E<@.T*,3@.Z,#4Z-3(@.4F5S=6QT(#T@.,S Q#0HQ.#HP-3HU,B!S>D1A
M=&%$:7(@./2!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R
M#0HQ.#HP-3HU,B!S>D1A=&%$:7(@./2!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R#0HQ.#HP-3HU,B!%;F0@.06-T:6]N.B!3971U<"!4
M>7!E#0HQ.#HP-3HU,B!3971U<"!4>7!E.B!4>7!I8V%L("@.S,#$I#0HQ.#HP
M-3HU,B!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V13971U<%1Y<&4-"C$X.C U
M.C4R(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#4Z-3(@.;D9U
M;&Q-87-K(#T@.,'AB9F,P,#,W+"!N0W5R<F5N=" ](#!X,3 P,# P+"!N1&ER
M96-T:6]N(#T@.,S Q#0HQ.#HP-3HU,R!5<&1A=&5D($1I86QO9R!-87-K.B P
M>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#4Z-3,@.1&EA;&]G
M(#!X,3 P,# P(')E='5R;F5D.B S,#$-"C$X.C U.C4S($5N9"!!8W1I;VX@.
M4VAO=T1I86QO9W-(;'!R#0HQ.#HP-3HU,R!3:&]W1&EA;&]G<T=E=$1I86QO
M9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.T,# P,# L:6YD97@.],C(-"C$X.C U
M.C4S($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# P#0HQ
M.#HP-3HU,R!"96=I;B!!8W1I;VXZ("!$;&=397)V:6-E<PT*,3@.Z,#8Z,#$@.
M4VAO=T1L9U-E<G9I8V5S(')E='5R;F5D.B Q#0HQ.#HP-CHP,2!;1&QG4V5R
M=FEC97-=#0HQ.#HP-CHP,2!,;V-A;"U$;VUA:6X)/2 V,38X, T*,3@.Z,#8Z
M,#$@.075T;U-T87)T"0D](#$U#0HQ.#HP-CHP,2!344Q$;VUA:6X)"3T@.0TA%
M3%-/1E0-"C$X.C V.C Q(%-13$1O;6%I;D%C8W0)/2!!9&UI;FES=')A=&]R
M#0HQ.#HP-CHP,2!344Q$;VUA:6Y0=V0-"C$X.C V.C Q($%G=$1O;6%I;@.D)
M/2!#2$5,4T]&5 T*,3@.Z,#8Z,#$@.06=T1&]M86EN06-C= D]($%D;6EN:7-T
M<F%T;W(-"C$X.C V.C Q($%G=$1O;6%I;E!W9 T*,3@.Z,#8Z,#$@.4F5S=6QT
M"3T@.,0T*,3@.Z,#8Z,#$@.16YD($%C=&EO;B!$;&=397)V:6 -E<PT*,3@.Z,#8Z
M,#$@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ.#HP-CHP,2!N1G5L
M;$UA<VL@./2 P>&)D8S P,S<L(&Y#=7)R96YT(#T@.,'@.T,# P,# L(&Y$:7)E
M8W1I;VX@./2 Q#0HQ.#HP-CHP,2!5<&1A=&5D($1I86QO9R!-87-K.B P>&)D
M8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z,#$@.1&EA;&]G(#!X
M-# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHP,2!%;F0@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<@.T*,3@.Z,#8Z,#$@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T
M=7)N960Z(&Y#=7)R96YT/3!X.# P,# P+&EN9&5X/3(S#0HQ.#HP-CHP,2!"
M96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#@.P,# P, T*,3@.Z,#8Z
M,#$@.0F5G:6X@.06-T:6]N.B @.1&QG4U%,4V5C=7)I='D-"C$X.C V.C,S(%-H
M;W=$;&=344Q396-U<FET>2!R971U<FYE9#H@.,0T*,3@.Z,#8Z,S,@.3&]G:6Y-
M;V1E(#T@.,BQS>E!W9 T*,3@.Z,#8Z,S,@.16YD($%C=&EO;B!$;&=344Q396-U
M<FET>0T*,3@.Z,#8Z,S,@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ
M.#HP-CHS,R!N1G5L;$UA<VL@./2 P>&)D8S P,S<L(&Y#=7)R96YT(#T@.,'@.X
M,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ.#HP-CHS,R!5<&1A=&5D($1I86QO
M9R!-87-K.B P>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z
M,S,@.1&EA;&]G(#!X.# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHS,R!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#8Z,S,@.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,3 P,# P,"QI;F1E>#TR
M- T*,3@.Z,#8Z,S,@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q
M,# P,# P#0HQ.#HP-CHS,R!"96=I;B!!8W1I;VXZ("!$;&=#;VQL871I;VX-
M"C$X.C V.C,S(%-H;W=$;&=#;VQL871I;VX@.<F5T=7)N960Z(#$-"C$X.C V
M.C,S(&-O;&QA=&EO;E]N86UE(#T@.4U%,7TQA=&EN,5]'96YE<F%L7T-0,5]#
M25]!4RQL;V-A;&5?;F%M92 ]($QA=&EN,5]'96YE<F%L+&QC:60@./2 P>#0P
M.2Q3;W)T260@./2 U,BQD=T-O;7!&;&%G<R ](#!X,S P,#$-"C$X.C V.C,S
M($5N9"!!8W1I;VX@.1&QG0V]L;&%T:6]N#0HQ.#HP-CHS,R!B96=I;B!3:&]W
M1&EA;&]G<U5P9&%T94UA<VL-"C$X.C V.C,S(&Y&=6QL36%S:R ](#!X8F1C
M,# S-RP@.;D-U<G)E;G0@./2 P>#$P,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ
M.#HP-CHS,R!5<&1A=&5D($1I86QO9R!-87-K.B P>&)D8S P,S<L($1I<V%B
M;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z,S,@.1&EA;&]G(#!X,3 P,# P,"!R971U
M<FYE9#H@.,0T*,3@.Z,#8Z,S,@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C$X.C V.C,S(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#(P,# P,# L:6YD97@.],C4-"C$X.C V.C,S($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# P, T*,3@.Z,#8Z,S,@.0F5G:6X@.
M06-T:6]N.B @.1&QG3F5T=V]R:PT*,3@.Z,#8Z,S,@.4VAO=T1L9TYE='=O<FL@.
M<F5T=7)N960Z(#$-"C$X.C V.C,S(%M$;&=397)V97).971W;W)K70T*,3@.Z
M,#8Z,S,@.3F5T=V]R:TQI8G,@./2 R-34-"C$X.C V.C,S(%1#4%!O<G0@./2 P
M#0HQ.#HP-CHS,R!40U!0<GAY(#T@.1&5F875L= T*,3@.Z,#8Z,S,@.3DU04&EP
M94YA;64@./2!<7"Y<<&EP95Q-4U-13"1#4U!,,DM<<W%L7'%U97)Y#0HQ.#HP
M-CHS,R!297-U;'0@./2 Q#0HQ.#HP-CHS,R!%;F0@.06-T:6]N($1L9TYE='=O
M<FL-"C$X.C V.C,S(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z
M,#8Z,S,@.;D9U;&Q-87-K(#T@.,'AB9&,P,#,W+"!N0W5R<F5N=" ](#!X,C P
M,# P,"P@.;D1I<F5C=&EO;B ](#$-"C$X.C V.C,S(%5P9&%T960@.1&EA;&]G
M($UA<VLZ(#!X8F1C,# S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ.#HP-CHS
M,R!$:6%L;V<@.,'@.R,# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHS,R!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#8Z,S,@.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# P,"QI;F1E>#TR
M-PT*,3@.Z,#8Z,S,@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.X
M,# P,# P#0HQ.#HP-CHS,R!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V13
M=&%R=$-O<'D-"C$X.C V.C,T($5N9"!!8W1I;VX@.1&EA;&]G4VAO=U-D4W1A
M<G1#;W!Y#0HQ.#HP-CHS-"!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-
M"C$X.C V.C,T(&Y&=6QL36%S:R ](#!X8F1C,# S-RP@.;D-U<G)E;G0@./2 P
M>#@.P,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ.#HP-CHS-"!5<&1A=&5D($1I
M86QO9R!-87-K.B P>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z
M,#8Z,S0@.1&EA;&]G(#!X.# P,# P,"!R971U<FYE9#H@.,0T*,3@.Z,#8Z,S0@.
M16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$X.C V.C,T(%-H;W=$:6%L
M;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP># L:6YD97@.], T*
M,3@.Z,#8Z,S0@.16YD($%C=&EO;B!3:&]W1&EA;&]G<PT*,3@.Z,#8Z,S0@.0F5G
M:6X@.06-T:6]N(%!R;V-E<W-"969O<F5$871A36]V93H-"C$X.C V.C,T($1E
M:6YS=&%L;%-T87)T(')E='5R;F5D("A$.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R7$U34U%,)$-34$PR2RDZ(# -"C$X.C V.C,T($5N
M9"!!8W1I;VX@.("!0<F]C97-S0F5F;W)E1&%T84UO=F4Z#0HQ.#HP-CHS-"!"
M96=I;B!!8W1I;VX@.4V5T5&]O;'-#;VUP;VYE;G1396QE8W1I;VXZ#0HQ.#HP
M-CHS-"!#<F5A=&53971U<%1O<&]L;V=Y*$-34$PI+"!(86YD;&4@..B P>#$X
M.30Q-# L(')E='5R;F5D(#H@., T*,3@.Z,#8Z,S0@.0W)E871E4V5T=7!4;W!O
M;&]G>2!R971U<FYE9" Z(# L($AA;F1L92 Z(#!X,3@.Y-#$T, T*,3@.Z,#8Z
M,S0@.5&]P;VQO9WD@.5'EP92 Z(#$L(%)E='5R;B!686QU92 Z(# -"C$X.C V
M.C,T(%-47T=E=%!H>7-I8V%L3F]D92!R971U<FYE9" Z(# L(%!.2&%N9&QE
M(#H@.,'@.Q.#DT,38X#0HQ.#HP-CHS-"!03E]%;G5M97)A=&5%>"!R971U<FYE
M9" Z(# -"C$X.C V.C,T(%!.7T=E=%-13%-T871E<R!R971U<FYE9" Z(# L
M(%-Q;%-T871E<R Z(#!X,C(W#0HQ.#HP-CHS-"!03E]3=&%R=%-C86X@.6S!X
M,3@.Y-#$V.%T@.<F5T=7)N960@..B P#0HQ.#HP-CHS-"!03E]'971.97AT(%LP
M>#$X.30Q-CA=(')E='5R;F5D(#H@.,"P@.2&%N9&QE.B!;,'@.Q.#DU,#@.P70T *
M,3@.Z,#8Z,S0@.4U%,25]'9714>7!E(%LP>#$X.34P.#!=(')E='5R;F5D(#H@.
M,"P@.;E1Y<&4Z(#!X,PT*,3@.Z,#8Z,S0@.4U%,25]'971);G-T86QL4&%T:"!;
M,'@.Q.#DU,#@.P72!R971U<FYE9" Z(# L(%!A=&@.@./2!$.EQ0<F]G<F%M($9I
M;&5S7$U34U%,-PT*,3@.Z,#8Z,S0@.4U%,25]'971$871A4&%T:"!;,'@.Q.#DU
M,#@.P72!R971U<FYE9" Z(# L($1A=&%0871H(#T@.1#I<4')O9W)A;2!&:6QE
M<UQ-4U-13#<-"C$X.C V.C,T(%-13$E?1V5T5F5R<VEO;B!;,'@.Q.#DU,#@.P
M72!R971U<FYE9" Z(# L(%9E<G-I;VX@./2 W+C P+C8R,PT*,3@.Z,#8Z,S0@.
M4U%,25]'971296=+97E2;V]T(%LP>#$X.34P.#!=(')E='5R;F5D(#H@.,"P@.
M4F5G2V5Y4F]O=" ](%-O9G1W87)E7$UI8W)O<V]F=%Q-4U-13%-E<G9E<@.T*
M,3@.Z,#8Z,S0@.5&]O;',@.4&%T:#H@.(" @.($0Z7%!R;V=R86T@.1FEL97-<35-3
M44PW#0HQ.#HP-CHS-"!4;V]L<R!697)S:6]N.B @.-RXP,"XV,C,-"C$X.C V
M.C,T(%1O;VQS(%)E9VES=')Y.B!3;V9T=V%R95Q-:6-R;W-O9G1<35-344Q3
M97)V97(-"C$X.C V.C,T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N
M960@..B Q."P@.2&%N9&QE.B!;,'@.P70T*,3@.Z,#8Z,S0@.1F]R8V4@.4'5R9V4-
M"C$X.C V.C,T(%!.7U-T87)T4V-A;B!;,'@.Q.#DT,38X72!R971U<FYE9" Z
M(# -"C$X.C V.C,T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N960@.
M.B P+"!(86YD;&4Z(%LP>#$X.30V9CA=#0HQ.#HP-CHS-"!344Q)7T=E=$EN
M<W1A;&Q0871H(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.4 &%T:" ]($0Z
M7%!R;V=R86T@.1FEL97-<35-344PW#0HQ.#HP-CHS-"!344Q)7T=E=$1A=&%0
M871H(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.1&%T85!A= &@.@./2!$.EQ0
M<F]G<F%M($9I;&5S7$U34U%,-PT*,3@.Z,#8Z,S0@.4U%,25]'971697)S:6]N
M(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.5F5R<VEO;B ](#<N,# N-C(S
M#0HQ.#HP-CHS-"!344Q)7T=E=%)E9TME>5)O;W0@.6S!X,3@.Y-#9F.%T@.<F5T
M=7)N960@..B P+"!296=+97E2;V]T(#T@.4V]F='=A<F5<36EC<F]S;V9T7$U3
M4U%,4V5R=F5R#0HQ.#HP-CHS-"!03E]'971.97AT(%LP>#$X.30Q-CA=(')E
M='5R;F5D(#H@.,3@.L($AA;F1L93H@.6S!X,%T-"C$X.C V.C,T(%)E;&5A<V53
M971U<%1O<&]L;V=Y#0HQ.#HP-CHS-"!%;F0@.06-T:6]N(%-E=%1O;VQS0V]M
M<&]N96YT4V5L96-T:6]N.@.T*,3@.Z,#8Z,S0@.0F5G:6X@.06-T:6]N(%!R;V-E
M<W-#;VUP;VYE;G1396QE8W1I;VXZ#0HQ.#HP-CHS-"!%;F0@.06-T:6]N(%!R
M;V-E<W-#;VUP;VYE;G1396QE8W1I;VX-"C$X.C V.C,T($)E9VEN($%C=&EO
M;B!,;V=396QE8W1E9$-O;7!O;F5N=',Z#0HQ.#HP-CHS-"!344Q0<F]G#0HQ
M.#HP-CHS-"!344Q0<F]G7%-13%-E<G9R#0HQ.#HP-CHS-"!344Q0<F]G7%-1
M3%-E<G9R7$AE;' -"C$X.C V.C,T(%-13%!R;V=<4U%,4V5R=G)<4T--1&5V
M#0HQ.#HP-CHS-"!344Q0<F]G7%-13%-E<G9R7%-#341E=EQ30TUH#0HQ.#HP
M-CHS-"!344Q0<F]G7%-13%-E<G9R7%-#341E=EQ30TU8.#9,8@.T*,3@.Z,#8Z
M,S0@.4U%,4')O9UQ344Q397)V<EQ30TU$979<4T--04QB#0HQ.#HP-CHS-"!3
M44Q0<F]G7%-13%-E<G9R7%)S,3 S,PT*,3@.Z,#8Z,S0@.4U%,4')O9UQ344Q3
M97)V<EQ2<TEN=&P-"C$X.C V.C,T(%-13%!R;V=<4U%,4V5R=G)<06-T:79E
M6 T*,3@.Z,#8Z,S0@.4U%,4')O9UQ344Q397)V<EQ3>7-T96T-"C$X.C V.C,T
M(%-13%!R;V=<4F5P;%-U<' -"C$X.C V.C,T(%-13%!R;V=<4F5P;%-U<'!<
M4F5P;$1A= T*,3@.Z,#8Z,S0@.4U%,4')O9UQ297!L4W5P<%Q297!#;VUM#0HQ
M.#HP-CHS-"!344Q0<F]G7%)E<&Q3=7!P7%)E<$YO1&L-"C$X.C V.C,T(%-1
M3%!R;V=<4F5P;%-U<'!<06-T:79E6 T*,3@.Z,#8Z,S0@.4U%,4')O9UQ);G-T
M86QL#0HQ.#HP-CHS-"!344Q0<F]G7%-Y<W1E;0T*,3@.Z,#8Z,S0@.4U%,4')O
M9UQ3=G)%>'0-"C$X.C V.C,T(%-13%!R;V=<4W9R17AT7$AE;' -"C$X.C V
M.C,T(%-13%!R;V=<4W9R17AT7%-V<D5X=%)S#0HQ.#HP-CHS-"!344Q0<F]G
M7%-V<D5X=%Q297-);G1L#0HQ.#HP-CHS-"!344Q0<F]G7$1A= T*,3@.Z,#8Z
M,S0@.4U%,4')O9UQ$8713;7!L#0HQ.#HP-CHS-"!344Q0<F]G7$)A<V53>7,-
M"C$X.C V.C,T(%-13%!R;V=<0F%S94)I;FX-"C$X.C V.C,T(%-13%!R;V=<
M35-396%R8V@.-"C$X.C V.C,T(%-13%!R;V=<35-396%R8VA<2&5L< T*,3@.Z
M,#8Z,S0@.4U%,4')O9UQ-4U-E87)C:%Q!8W1I=F58#0HQ.#HP-CHS-"!344Q0
M<F]G7$)A<V5);G-T#0HQ.#HP-CHS-"!344Q0<F]G7%-Y;6)O;',-"C$X.C V
M.C,T(%-13%!R;V=<4WEM8F]L<UQ%6$4-"C$X.C V.C,T(%-13%!R;V=<4WEM
M8F]L<UQ$3$P-"C$X.C V.C,T(%-13%!R;V=<4&5R9FUO;@.T*,3@.Z,#8Z,S0@.
M4U%,4')O9UQ097)F;6]N7%-Y<W1E;0T*,3@.Z,#8Z,S0@.4U%,4')O9UQ2;V]T
M#0HQ.#HP-CHS-"!-9W14;V]L#0HQ.#HP-CHS-"!-9W14;V]L7%-%30T*,3@.Z
M,#8Z,S0@.36=T5&]O;%Q314U<2%1-3 T*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<
M35-$.3@.-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$U31#DX4UE3#0HQ.#HP-CHS
M-"!-9W14;V]L7%-%35Q-4T0Y.%)E<PT*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<
M35-$.3A(;' -"C$X.C V.C,T($UG=%1O;VQ<4T5-7$AE;' -"C$X.C V.C,T
M($UG=%1O;VQ<4T5-7%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7%)E
M<TEN=&P-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$U31#DX4G-)#0HQ.#HP-CHS
M-"!-9W14;V]L7%-%35Q!8W1I=F58#0HQ.#HP-CHS-"!-9W14;V]L7%-%35Q!
M8W1I=F587%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$%C=&EV95A<
M4F5S26YT; T*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<4V-R:7!T<PT*,3@.Z,#8Z
M,S0@.36=T5&]O;%Q314U<3TQ%1$(-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$],
M141"7%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$],141"7%)E<TEN
M=&P-"C$X.C V.C,T($UG=%1O;VQ<4')O9FEL97(-"C$X.C V.C,T($UG=%1O
M;VQ<4')O9FEL97)<2&5L< T*,3@.Z,#8Z,S0@.36=T5&]O;%Q0<F]F:6QE<EQ2
M97,Q,#,S#0HQ.#HP-CHS-"!-9W14;V]L7%!R;V9I;&5R7%)E<TEN=&P-"C$X
M.C V.C,T($UG=%1O;VQ<47)Y86YL>@.T*,3@.Z,#8Z,S0@.36=T5&]O;%Q1<GEA
M;FQZ7$AE;' -"C$X.C V.C,T($UG=%1O;VQ<47)Y86YL>EQ297,Q,#,S#0HQ
M.#HP-CHS-"!-9W14;V]L7%%R>6%N;'I<4F5S26YT; T*,3@.Z,#8Z,S0@.36=T
M5&]O;%Q$5$-#3&D-"C$X.C V.C,T($UG=%1O;VQ<5WIC;F9L8W0-"C$X.C V
M.C,T($UG=%1O;VQ<5WIC;F9L8W1<5WIC;DAL< T*,3@.Z,#8Z,S0@.36=T5&]O
M;%Q7>F-N9FQC=%Q7>F-N,3 S,PT*,3@.Z,#8Z,S0@.36=T5&]O;%Q7>F-N9FQC
M=%Q7>F-N3W1H<@.T*,3@.Z,#8Z,S0@.36=T5&]O;%Q7>F-N9FQC=%Q7>F-N0VUN
M#0HQ.#HP-CHS-"!-9W14;V]L7%5T:6Q3>7,-"C$X.C V.C,T($UG=%1O;VQ<
M571I;$)I;FX-"C$X.C V.C,T($-O;FYE8W0-"C$X.C V.C,T($-O;FYE8W1<
M0V]N;E-Y<PT*,3@.Z,#8Z,S0@.0F]O:W,-"C$X.C V.C,T($)O;VMS7$)O;VMS
M;PT*,3@.Z,#8Z,S0@.0F]O:W-<0F]O:W-O7%5T:6QS#0HQ.#HP-CHS-"!$9794
M;V]L<PT*,3@.Z,#8Z,S0@.1&5V5&]O;'-<1&)G($EN= T*,3@.Z,#8Z,S0@.1&5V
M5&]O;'-<1&)G($EN=%Q$8F<@.26YT($-O;6UO;@.T*,3@.Z,#8Z,S0@.1&5V5&]O
M;'-<1&)G($EN=%Q%6$4-"C$X.C V.C,T($-O<F5297!L#0HQ.#HP-CHS-"!#
M;W)E4F5P;%Q297,Q,#,S#0HQ.#HP-CHS-"!#;W)E4F5P;%Q297-);G1L#0HQ
M.#HP-CHS-"!#;W)E#0HQ.#HP-CHS-"!#;W)E7%)E<S$P,S,-"C$X.C V.C,T
M($-O<F5<4F5S3W1H97(-"C$X.C V.C,T(%)E<&]S=')Y#0HQ.#HP-CHS-"!2
M97!O<W1R>5Q297!S=%-Y<PT*,3@.Z,#8Z,S0@.4F5P;W-T<GE<4F5S,3 S,PT*
M,3@.Z,#8Z,S0@.4F5P;W-T<GE<4F5S26YT; T*,3@.Z,#8Z,S0@.0V]R94UI<V,-
M"C$X.C V.C,T($-O<F5-:7-C7$%C=&EV95@.-"C$X.C V.C,T($-O<F5-:7-C
M7$%C=&EV95A<4F5S,3 S,PT*,3@.Z,#8Z,S0@.0V]R94UI<V-<06-T:79E6%Q2
M97-);G1L#0HQ.#HP-CHS-"!#;W)E36ES8UQ297,Q,#,S#0HQ.#HP-CHS-"!-
M;VYA<F-H#0HQ.#HP-CHS-"!-;VYA<F-H7$UO;G(Q,#,S#0HQ.#HP-CHS-"!-
M;VYA<F-H7$UO;G));G1L#0HQ.#HP-CHS-"!*970-"C$X.C V.C,T($-O<F5)
M;G-T#0HQ.#HP-CHS-"!#;W)E0T]-#0HQ.#HP-CHS-"!#;W)E0T]-7%)E<S$P
M,S,-"C$X.C V.C,T($-O<F5#3TU<4F5S26YT; T*,3@.Z,#8Z,S0@.0V]R951O
M;VP-"C$X.C V.C,T($-O<F54;V]L7%)E<S$P,S,-"C$X.C V.C,T($-O<F54
M;V]L7%)E<T]T:&5R#0HQ.#HP-CHS-"!$0DQI8D-L:0T*,3@.Z,#8Z,S0@.4T9%
M>'0-"C$X.C V.C,T(%-&17AT7$%C=&EV95@.-"C$X.C V.C,T(%-&17AT7$%C
M=&EV95A<4F5S,3 S,PT*,3@.Z,#8Z,S0@.4T9%>'1<06-T:79E6%Q297-);G1L
M#0HQ.#HP-CHS-"!31D5X=%Q297,Q,#,S#0HQ.#HP-CHS-"!31D5X=%Q297-)
M;G1L#0HQ.#HP-CHS-"!4<F%C90T*,3@.Z,#8Z,S0@.5')A8V5<4F5S,3 S,PT*
M,3@.Z,#8Z,S0@.5')A8V5<4F5S3W1H97(-"C$X.C V.C,T($UI<V-#;W)E#0HQ
M.#HP-CHS-"!-0PT*,3@.Z,#8Z,S0@.34-<34,Q,#,S#0HQ.#HP-CHS-"!-0UQ-
M0TEN=&P-"C$X.C V.C,T($U#7$AE;' -"C$X.C V.C,T(%-13$UG<@.T*,3@.Z
M,#8Z,S0@.4U%,36=R7%)E<S$P,S,-"C$X.C V.C,T(%-13$UG<EQ297-);G1L
M#0HQ.#HP-CHS-"!3=G)4;V]L#0HQ.#HP-CHS-"!3=G)4;V]L7%)E<S$P,S,-
M"C$X.C V.C,T(%-V<E1O;VQ<4F5S26YT; T*,3@.Z,#8Z,S0@.1%1354D-"C$X
M.C V.C,T($144U5)7%)E<S$P,S,-"C$X.C V.C,T($144U5)7%)E<TEN=&P-
M"C$X.C V.C,T($U33VQA< T*,3@.Z,#8Z,S0@.35-/;&%P7%)E<S$P,S,-"C$X
M.C V.C,T($U33VQA<%Q297-);G1L#0HQ.#HP-CHS-"!!5$P-"C$X.C V.C,T
M($%43%QW:6YN= T*,3@.Z,#8Z,S0@.051,7'=I;CEX#0HQ.#HP-CHS-"!-1D,T
M,E4-"C$X.C V.C,T(%9##0HQ.#HP-CHS-"!60@.T*,3@.Z,#8Z,S0@.4U%,061(
M;' -"C$X.C V.C,T(%-13$%D2&QP7%)E<S$P,S,-"C$X.C V.C,T(%-13$%D
M2&QP7%)E<T]T:&5R#0HQ.#HP-CHS-"![13 W1D1$0D4M-4$R,2TQ,60R+3E$
M040M,#!#,#1&-SE$-#,T?0T*,3@.Z,#8Z,S0@.>T4P-T9$1$,W+35!,C$M,3%D
M,BTY1$%$+3 P0S T1C<Y1#0S-'T-"C$X.C V.C,T('M%,#=&1$1#,"TU03(Q
M+3$Q9#(M.41!1"TP,$,P-$8W.40T,S1]#0HQ.#HP-CHS-"![13 W1D1$0D8M
M-4$R,2TQ,60R+3E$040M,#!#,#1&-SE$-#,T?0T*,3@.Z,#8Z,S0@.16YD($%C
M=&EO;B!,;V=396QE8W1E9$-O;7!O;F5N=',-"C$X.C V.C,T($)E9VEN($%C
M=&EO;B!);G-T86QL4&MG<SH-"C$X.C V.C,T($)E9VEN($%C=&EO;CH@.3&]C
M:V5D($-O;FYE8W1I=FET>2!&:6QE<R!#:&5C:PT*,3@.Z,#8Z,S8@.0V]N;F5C
M=&EV:71Y3&]C:V5D(')E='5R;F5D.B P#0HQ.#HP-CHS-B!4:&4@.;W!E<F%T
M:6]N(&-O;7!L971E9"!S=6-C97-S9G5L;'DN#0H-"C$X.C V.C,V($5N9"!!
M8W1I;VXZ($QO8VME9"!#;VYN96-T:79I='D@.1FEL97,@.0VAE8VL-"C$X.C V
M.C,V(%-E='5P(&ES(&EN<W1A;&QI;F<@.36EC<F]S;V9T($1A=&$@.06-C97-S
M($-O;7!O;F5N=',@.*$U$04,I("XN+@.T*,3@.Z,#8Z,S8@.7%Q#4U!,7 %-O9G1W
M87)E7$]T:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8.#9<3W1H97)<<W%L<F5D
M:7,N97AE("]Q.F$@.+T,Z(G-E='5P<F4N97AE(%=!4DX],2 M<R M4TU3(@.T*
M,3@.Z,#<Z,C @.17AI=$-O9&4Z(# -"C$X.C W.C(P(%-E='5P(&ES(&EN<W1A
M;&QI;F<@.36EC<F]S;V9T($1I<W1R:6)U=&5D(%1R86YS86-T:6]N($-O;W)D
M:6YA=&]R("A-4T140RD@.+BXN#0HQ.#HP-SHR," @.0SI<1$]#54U%?C%<041-
M24Y)?C%<3$]#04Q3?C%<5&5M<%Q3<6Q3971U<%Q":6Y<8VQD=&-S=' N97AE
M("U3=7!P;W)T1&ER(")#.EQ$3T-5345^,5Q!1$U)3DE^,5Q,3T-!3%-^,5Q4
M96UP7%-Q;%-E='5P7$)I;B(@.+4140U!K9R B7%Q#4U!,7%-O9G1W87)E7$]T
M:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8.#9<3W1H97)<9'1C<V5T=7 N97AE
M(B M3&]G1FEL92 B0SI<5TE.3E1<<W%L<W1P+FQO9R(-"C$X.C W.C(P(%!R
M;V-E<W,@.17AI="!#;V1E.B H,"D@.#0HQ.#HP-SHR,"!);G-T86QL35-396%R
M8V@.@.:6YS=&%N8V4Z($-34$PR2PT*,3@.Z,#<Z,C @.4V]F='=A<F5<36EC<F]S
M;V9T7%-E87)C:%Q);G-T86QL.E9E<G-I;VX@.;F]T('!R97-E;G0-"C$X.C W
M.C(P($U34V5A<F-H(#(N,"!O<B!G<F5A=&5R('9E<G-I;VX@.8VAE8VL@.<F5T
M=7)N960@.+3$-"C$X.C W.C(Q(%-E='5P(&ES(&EN<W1A;&QI;F<@.=&AE($UI
M8W)O<V]F="!&=6QL+51E>'0@.4V5A<F-H($5N9VEN92 N+BX-"C$X.C W.C(Q
M(" B7%Q#4U!,7%-O9G1W87)E7$]T:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8
M.#9<1G5L;%1E>'1<35-396%R8VA<4V5A<F-H7%-E87)C:%-T<"YE>&4B("]S
M("]A.E-13%-E<G9E<B1#4U!,,DL-"C$X.C W.C0U(%!R;V-E<W,@.17AI="!#
M;V1E.B H,"D@.#0HQ.#HP-SHT-2 @.+U$Z02 O5#I#.EQ$3T-5345^,5Q!1$U)
M3DE^,5Q,3T-!3%-^,5Q496UP7&EX<# P,2YT;7 -"C$X.C W.C0U(%-E='5P
M(&ES(&EN<W1A;&QI;F<@.2%1-3"!(96QP("XN+@.T*,3@.Z,#<Z-#8@.2%1-3"!(
M96QP(&EN<W1A;&QE<B!E>&ET(&-O9&4Z(# -"C$X.C X.C X($5N9"!!8W1I
M;VX@.26YS=&%L;%!K9W,-"C$X.C X.C X($)E9VEN($%C=&EO;B!-;W9E1FEL
M941A=&$Z#0HQ.#HP.#HP."!%;F%B;&5D(%-%3$9214=)4U1%4D)!5$-(#0HQ
M.#HP.#HP."!%;F%B;&5D($-/4D5#3TU03TY%3E1(04Y$3$E.1PT*,3@.Z,#DZ
M,# @.0F5G:6X@.06-T:6]N.B @.36]V949I;&5$871A4W!E8VEA; T*,3@.Z,#DZ
M,#$@.16YD($%C=&EO;CH@.($UO=F5&:6QE1&%T85-P96-I86P-"C$X.C Y.C Q
M($5N9"!!8W1I;VX@.("!-;W9E1FEL941A=&$-"C$X.C Y.C Q(%-E=%)E9D-O
M=6YT.B!#.EQ724Y.5%QS>7-T96TS,EQN='=D8FQI8BYD;&P@.*#4I#0HQ.#HP
M.3HP,2!"96=I;B!!8W1I;VX@.4')O8V5S<T%F=&5R1&%T84UO= F4Z#0HQ.#HP
M.3HP,2!<7$-34$Q<4V]F='=A<F5<3W1H97)S7%-13#(P,#!<1$5614Q/?C%<
M6#@.V7$)I;FY<:&AC;VPN97AE($,Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T
M(%-13"!397)V97)<.#!<5&]O;'-<0F]O:W,-"C$X.C Y.C R($5N9"!!8W1I
M;VX@.("!0<F]C97-S069T97)$871A36]V90T*,3@.Z,#DZ,#(@.0F5G:6X@.06-T
M:6]N($)U:6QD4V5R=F5R.@.T*,3@.Z,#DZ,#(@.0SI<1$]#54U%?C%<041-24Y)
M?C%<3$]#04Q3?C%<5&5M<%Q3<6Q3971U<%Q":6Y<<V-M+F5X92 @.+5-I;&5N
M=" Q("U!8W1I;VX@.-2 M17AE4&%T:" B1#I<4')O9W)A;2!&:6QE<UQ-:6-R
M;W-O9G0@.4U%,(%-E<G9E<EQ-4U-13"1#4U!,,DM<8FEN;EQS<6QS97)V<BYE
M>&4B("U397)V:6-E(")-4U-13"1#4U!,,DLB#0HQ.#HP.3HP,R!0<F]C97-S
M($5X:70@.0V]D93H@.*# I( T*,3@.Z,#DZ,#,@.0F5G:6X@.06-T:6]N.B!#<F5A
M=&5296=I<W1R>5-E=%-13 T*,3@.Z,#DZ,#,@.16YD($%C=&EO;CH@.0W)E871E
M4F5G:7-T<GE3971344P-"C$X.C Y.C S($)E9VEN($%C=&EO;CH@.4F5G5W)I
M=&53971U<$5N=')Y#0HQ.#HP.3HP,R!%;F0@.06-T:6]N.B!296=7<FET95-E
M='5P16YT<GD-"C$X.C Y.C S($)E9VEN($%C=&EO;CH@.0W)E871E4V5R#0HQ
M.#HP.3HP,R!%;F0@.06-T:6]N.B!#<F5A=&5397(-"C$X.C Y.C S($)E9VEN
M($%C=&EO;CH@.4VMU270-"C$X.C Y.C S($5N9"!!8W1I;VXZ(%-K=4ET#0HQ
M.#HP.3HP-"!3971&:6QE4V5C=7)I='E344Q!;F1!9&UI;B!F;W(@.1#I<4') O
M9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<EQ-4U-13"1#4U!,,DL@.
M<F5T=7)N960Z(# L(# -"C$X.C Y.C T(%-E=%)E9U-E8W5R:71Y4U%,06YD
M061M:6X@.9F]R(%-O9G1W87)E7$UI8W)O<V]F=%Q-:6-R;W-O9G0@.4U%,(%-E
M<G9E<EQ#4U!,,DL@.<F5T=7)N960Z(# L(# -"C$X.C Y.C T($)E9VEN($%C
M=&EO;CH@.57!D871E4WES=&5M4&%T: T*,3@.Z,#DZ,#0@.4&%T:"!S=6-C97-S
M9G5L;'D@.=7!D871E9"X-"C$X.C Y.C T("5724XS,D1-25!!5$@.E7$))3CLE
M4WES=&5M4F]O="5<<WES=&5M,S([)5-Y<W1E;5)O;W0E.R53>7-T96U2;V]T
M)5Q3>7-T96TS,EQ78F5M.T0Z7%!R;V=R86T@.1FEL97-<35-344PW7$))3DX[
M0SI<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<EPX,%Q4;V]L
M<UQ"24Y.#0HQ.#HP.3HP-"!%;F0@.06-T:6]N.B!5<&1A=&53>7-T96U0871H
M#0HQ.#HP.3HP-"!'<F%N="!2:6=H="!F;W(@.0TA%3%-/1E1<061M:6YI<W1R
M871O<B!R971U<FYE9" Z(#$L(# -"C$X.C Y.C T($=R86YT(%)I9VAT(&9O
M<B!#2$5,4T]&5%Q!9&UI;FES=')A=&]R(')E='5R;F5D(#H@.,2P@., T*,3@.Z
M,#DZ,#4@.1W)A;G0@.4FEG:'0@.9F]R($-(14Q33T947$%D;6EN:7-T<F%T;W(@.
M<F5T=7)N960@..B Q+" P#0HQ.#HP.3HP-2!'<F%N="!2:6=H="!F;W(@.0TA%
M3%-/1E1<061M:6YI<W1R871O<B!R971U<FYE9" Z(#$L(# -"C$X.C Y.C U
M($=R86YT(%)I9VAT(&9O<B!#2$5,4T]&5%Q!9&UI;FES=')A=&]R(')E='5R
M;F5D(#H@.,2P@., T*,3@.Z,#DZ,#8@.0SI<4')O9W)A;2!&:6QE<UQ-:6-R;W-O
M9G0@.4U%,(%-E<G9E<EPX,%Q4;V]L<UQ":6YN7&-N9F=S=G(N97AE(" M1B B
M0SI<5TE.3E1<<W%L<W1P+FQO9R(@.+4D@.0U-03#)+("U6(#$@.+4T@.," M42 B
M4U%,7TQA=&EN,5]'96YE<F%L7T-0,5]#25]!4R(@.+4@.@.,3DW,3(T("U5('-A
M("U0( T*(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C (R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C( R,C(PT*#0H-
M"E-T87)T:6YG(%-E<G9I8V4@.+BXN#0H-"E-13%],871I;C%?1V5N97)A;%]#
M4#%?0TE?05,-"@.T*+6T@.+5$@.+50T,#(R("U4,S8U.0T*#0I#;VYN96-T:6YG
M('1O(%-E<G9E<B N+BX-"@.T*9')I=F5R/7MS<6P@.<V5R=F5R?3MS97)V97(]
M0U-03%Q#4U!,,DL[54E$/7-A.U!71#T[9&%T86)A<V4];6%S=&5R#0H-"EM-
M:6-R;W-O9G1=6T]$0D,@.4U%,(%-E<G9E<B!$<FEV97)=6U1#4"])4"!3;V-K
M971S74=E;F5R86P@.;F5T=V]R:R!E<G)O<BX@.0VAE8VL@.>6]U<B!N971W;W)K
M(&1O8W5M96YT871I;VXN#0H-"EM-:6-R;W-O9G1=6T]$0D,@.4U%,(%-E<G9E
M<B!$<FEV97)=6U1#4"])4"!3;V-K971S74-O;FYE8W1I;VY296%D("AR96-V
M*"DI+@.T*#0ID<FEV97(]>W-Q;"!S97)V97)].W-E<G9E<CU#4U!,7$-34$PR
M2SM5240]<V$[4%=$/3MD871A8F%S93UM87-T97(-"@.T*6TUI8W)O<V]F=%U;
M3T1"0R!344P@.4V5R=F5R($1R:79E<EU;5$-0+TE0(%-O8VME='-=1V5N97)A
M;"!N971W;W)K(&5R<F]R+B!#:&5C:R!Y;W5R(&YE='=O<FL@.9&]C=6UE;G1A
M=&EO;BX-"@.T*6TUI8W)O<V]F=%U;3T1"0R!344P@.4V5R=F5R($1R:79E<EU;
M5$-0+TE0(%-O8VME='-=0V]N;F5C=&EO;E)E860@.*')E8W8H*2DN#0H-"F1R
M:79E<CU[<W%L('-E<G9E<GT[<V5R=F5R/4-34$Q<0U-03#)+.U5)1#US83M0
M5T0].V1A=&%B87-E/6UA<W1E<@.T*#0I;36EC<F]S;V9T75M/1$)#(%-13"!3
M97)V97(@.1')I=F5R75M40U O25 @.4V]C:V5T<UU'96YE<F%L(&YE='=O<FL@.
M97)R;W(N($-H96-K('EO=7(@.;F5T=V]R:R!D;V-U;65N=&%T:6]N+@.T*#0I;
M36EC<F]S;V9T75M/1$)#(%-13"!397)V97(@.1')I=F5R75M40U O25 @.4V]C
M:V5T<UU#;VYN96-T:6]N4F5A9" H<F5C=B@.I*2X-"@.T*4U%,(%-E<G9E<B!C
M;VYF:6=U<F%T:6]N(&9A:6QE9"X-"@.T*(R,C(R,C(R,C(R,C(R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C( R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(PT*#0HQ.#HP.3HS,R!0<F]C97-S($5X:70@.0V]D93H@.
M*"TQ*2 -"C$X.C$X.C(Y(%-E='5P(&9A:6QE9"!T;R!C;VYF:6=U<F4@.=&AE
M('-E<G9E<BX@.("!2969E<B!T;R!T:&4@.<V5R=F5R(&5R<F]R(&QO9W,@.86YD
M($,Z7%=)3DY47'-Q;'-T<"YL;V<@.9F]R(&UO<F4@.:6YF;W)M871I;VXN#0HQ
M.#HQ.#HR.2!!8W1I;VX@.0VQE86Y5<$EN<W1A;&PZ#0HQ.#HQ. #HR.2!#.EQ$
M3T-5345^,5Q!1$U)3DE^,5Q,3T-!3%-^,5Q496UP7%-Q;%-E='5P7$)I;EQS
M8VTN97AE(" M4VEL96YT(#$@.+4%C=&EO;B T("U397)V:6-E(%-13$%G96YT
M)$-34$PR2PT*,3@.Z,3@.Z,CD@.4')O8V5S<R!%>&ET($-O9&4Z("@.Q,#8P*2!4
M:&4@.<W!E8VEF:65D('-E<G9I8V4@.9&]E<R!N;W0@.97AI<W0@.87,@.86X@.:6YS
M=&%L;&5D('-E<G9I8V4N#0H-"C$X.C$X.C(Y($,Z7$1/0U5-17XQ7$%$34E.
M27XQ7$Q/0T%,4WXQ7%1E;7!<4W%L4V5T=7!<0FEN7'-C;2YE>&4@.("U3:6QE
M;G0@.,2 M06-T:6]N(#0@.+5-E<G9I8V4@.35-344PD0U-03#)+#0HQ.#HQ.#HR
M.2!0<F]C97-S($5X:70@.0V]D93H@.*# I( T*,3@.Z,3@.Z,CD@.4W1A='-'96YE
M<F%T92!R971U<FYE9#H@.,@.T*,3@.Z,3@.Z,CD@.4W1A='-'96YE<F%T92 H,'@.R
M,C<L,'@.Q+#!X9C P+#!X,S P+#$P,S,L,S S+#!X,"PP>#$L,"PP+# -"C$X
M.C$X.C(Y(%-T871S1V5N97)A=&4@.+3$L061M:6YI<W1R871O<BD-"C$X.C$X
:.C(Y($EN<W1A;&QA=&EO;B!&86EL960N#0H`
`
end
You have a TCP/IP alias established created on your computer. Remove it and
setup should complete successfully. Setup starts SQL Server in a mode to
accept only shared memory connections. The alias is preventing setup from
connecting.
Run cliconfg from Start - Run. Go to the ALias tab and delete the alias for
this server, You do not need it. Or should not need it. If you do then
there is another problem that needs to be addressed.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Rand!
You the man! I was about to have a heart attack when i had uninstalled
our SQL Developer server and could not install Standard edition. Your
suggestion worked like a charm! Your advice is excellent even 6 months
later.
Blackened
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message537287.html
I tried to install my SQLServer2000 Developer
Edition in my server machine, which is running on the OS
Windows Server 2000.
I am getting the following errors
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
driver={sql server};server=CSPL\CSPL2K;UID=sa;PWD=;database=ma ster
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
driver={sql server};server=CSPL\CSPL2K;UID=sa;PWD=;database=ma ster
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
SQL Server configuration failed.
What is the problem?
Also, i herewith attached the error log file.
Kindly give me the solution and it is very urgent.
with regards,
T.Thirumalairajan B.E
begin 666 sqlstp.log
M,3@.Z,#0Z-# @.0F5G:6X@.4V5T=7 -"C$X.C T.C0P(#@.N,# N,3DT#0HQ.#HP
M-#HT,"!-;V1E(#T@.3F]R;6%L#0HQ.#HP-#HT,"!-;V1E5'EP92 ]($Y/4DU!
M3 T*,3@.Z,#0Z-# @.1V5T1&5F:6YI=&EO;D5X(')E='5R;F5D.B P+"!%>'1E
M;F1E9#H@.,'AF,# P,# -"C$X.C T.C0P(%9A;'5E1E13(')E='5R;F5D.B Q
M#0HQ.#HP-#HT,"!686QU95!)1"!R971U<FYE9#H@.,0T*,3@.Z,#0Z-# @.5F%L
M=65,:6,@.<F5T=7)N960Z(# -"C$X.C T.C0P(%-Y<W1E;3H@.5VEN9&]W<R!.
M5"!497)M:6YA;"!397)V97(-"C$X.C T.C0P(%-13"!397)V97(@.4')O9'5C
M=%1Y<&4Z($1E=F5L;W!E<B!%9&ET:6]N(%LP>#-=#0HQ.#HP-#HT,"!"96=I
M;B!!8W1I;VXZ(%-E='5P26YI=&EA;&EZ92 -"C$X.C T.C0P($5N9"!!8W1I
M;VX@.4V5T=7!);FET:6%L:7IE#0HQ.#HP-#HT,"!"96=I;B!!8W1I;VXZ("!3
M971U<$EN<W1A;&P-"C$X.C T.C0P(%)E861I;F<@.4V]F='=A<F5<36EC<F]S
M;V9T7%=I;F1O=W-<0W5R<F5N=%9E<G-I;VY<0V]M;6]N1FEL97-$:7(@.+BXN
M#0HQ.#HP-#HT,"!#;VUM;VY&:6QE<T1I<CU#.EQ0<F]G<F%M($9I;&5S7$-O
M;6UO;B!&:6QE<PT*,3@.Z,#0Z-# @.5VEN9&]W<R!$:7)E8W1O<GD]0SI<5TE.
M3E1<#0HQ.#HP-#HT,"!0<F]G<F%M($9I;&5S/4,Z7%!R;V=R86T@.1FEL97-<
M#0HQ.#HP-#HT,"!414U01$E2/4,Z7$1/0U5-17XQ7$%$34E.27XQ7$Q/0T%,
M4WXQ7%1E;7!<#0HQ.#HP-#HT,"!"96=I;B!!8W1I;VXZ("!3971U<$EN<W1A
M;&P-"C$X.C T.C0P(&1I9W!I9"!S:7IE(#H@.,C4V#0HQ.#HP-#HT,"!D:6=P
M:60@.<VEZ92 Z(#$V- T*,3@.Z,#0Z-# @.0F5G:6X@.06-T:6]N.B @.0VAE8VM&
M:7AE9%)E<75I<F5M96YT<PT*,3@.Z,#0Z-# @.4&QA=&9O<FT@.240Z(#!X9C P
M#0HQ.#HP-#HT,"!697)S:6]N.B U+C N,C$Y-0T*,3@.Z,#0Z-# @.1FEL92!6
M97)S:6]N("T@.0SI<5TE.3E1<<WES=&5M,S)<<VAD;V-V=RYD;&PZ(#4N,"XS
M-3(V+C@.P, T*,3@.Z,#0Z-# @.16YD($%C=&EO;CH@.($-H96-K1FEX961297%U
M:7)E;65N=',-"C$X.C T.C0P($)E9VEN($%C=&EO;CH@.(%-H;W=$:6%L;V=S
M#0HQ.#HP-#HT,"!);FET:6%L($1I86QO9R!-87-K.B P>#@.S,# P9C<L($1I
M<V%B;&4@.0F%C:STP>#$-"C$X.C T.C0Q($)E9VEN($%C=&EO;B!3:&]W1&EA
M;&]G<TAL<'(Z(#!X,0T*,3@.Z,#0Z-#$@.0F5G:6X@.06-T:6]N.B @.1&EA;&]G
M4VAO=U-D5V5L8V]M90T*,3@.Z,#0Z-#(@.16YD($%C=&EO;B @.1&EA;&]G4VAO
M=U-D5V5L8V]M90T*,3@.Z,#0Z-#(@.1&EA;&]G(#!X,2!R971U<FYE9#H@.,0T*
M,3@.Z,#0Z-#(@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$X.C T.C0R
M(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP>#(L
M:6YD97@.],0T*,3@.Z,#0Z-#(@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP
M<CH@.,'@.R#0HQ.#HP-#HT,B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1-
M86-H:6YE3F%M90T*,3@.Z,#0Z-#0@.4VAO=T1L9TUA8VAI;F4@.<F5T=7)N960Z
M(#$-"C$X.C T.C0T($YA;64@./2!#4U!,+"!4>7!E(#T@.,'@.Q#0HQ.#HP-#HT
M-"!"96=I;B!!8W1I;VXZ("!#:&5C:U)E<75I<F5M96YT<PT*,3@. Z,#0Z-#0@.
M4')O8V5S<V]R($%R8VAI=&5C='5R93H@.>#@.V("A096YT:75M*0T*,3@.Z,#0Z
M-#0@.4V5R=FEC92!086-K.B @.-S8X#0HQ.#HP-#HT-"!#;VUP=71E<DYA;64Z
M($-34$P-"C$X.C T.C0T(%5S97(@.3F%M93H@.061M:6YI<W1R871O<@.T*,3@.Z
M,#0Z-#0@.27-!;&Q!8V-E<W-!;&QO=V5D(')E='5R;F5D.B Q#0HQ.#HP-#HT
M-"!/4R!,86YG=6%G93H@.,'@.T,#D-"C$X.C T.C0T($5N9"!!8W1I;VX@.0VAE
M8VM297%U:7)E;65N=',-"C$X.C T.C0T($-R96%T95-E='5P5&]P;VQO9WDH
M0U-03"DL($AA;F1L92 Z(#!X,3@.Y-#$T,"P@.<F5T=7)N960@..B P#0HQ.#HP
M-#HT-"!#<F5A=&53971U<%1O<&]L;V=Y(')E='5R;F5D(#H@.,"P@.2&%N9&QE
M(#H@.,'@.Q.#DT,30P#0HQ.#HP-#HT-"!4;W!O;&]G>2!4>7!E(#H@.,2P@.4F5T
M=7)N(%9A;'5E(#H@., T*,3@.Z,#0Z-#0@.4U1?1V5T4&AY<VEC86Q.;V1E(')E
M='5R;F5D(#H@.,"P@.4$Y(86YD;&4@..B P>#$X.30Q-C@.-"C$X.C T.C0T(%!.
M7T5N=6UE<F%T945X(')E='5R;F5D(#H@., T*,3@.Z,#0Z-#0@.4$Y?1V5T4U%,
M4W1A=&5S(')E='5R;F5D(#H@.,"P@.4W%L4W1A=&5S(#H@.,'@.R, C<-"C$X.C T
M.C0T(%!.7U-T87)T4V-A;B!;,'@.Q.#DT,38X72!R971U<FYE9" Z(# -"C$X
M.C T.C0T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N960@..B Q."P@.
M2&%N9&QE.B!;,'@.P70T*,3@.Z,#0Z-#0@.3F\@.;6]R92!I=&5M<R!I;B!E;G5M
M97)A=&EO;BX-"C$X.C T.C0T(%)E;&5A<V53971U<%1O<&]L;V=Y#0HQ.#HP
M-#HT-"!.86UE9"!I;G-T86YC92!L:6UI=#H@.,3 P+"!Q=6]T83H@., T*,3@.Z
M,#0Z-#0@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C$X
M.C T.C0T(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#0Z-#0@.
M;D9U;&Q-87-K(#T@.,'@.X,S P,&8W+"!N0W5R<F5N=" ](#!X,BP@.;D1I<F5C
M=&EO;B ](# -"C$X.C T.C0T(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X8F8P
M,# S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ.#HP-#HT-"!$:6%L;V<@.,'@.R
M(')E='5R;F5D.B P#0HQ.#HP-#HT-"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S
M2&QP<@.T*,3@.Z,#0Z-#0@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z
M(&Y#=7)R96YT/3!X-"QI;F1E>#TR#0HQ.#HP-#HT-"!"96=I;B!!8W1I;VX@.
M4VAO=T1I86QO9W-(;'!R.B P>#0-"C$X.C T.C0T($)E9VEN($%C=&EO;CH@.
M($1I86QO9U-H;W=39$EN<W1A;&Q-;V1E#0HQ.#HP-#HU-2!3:&]W1&QG26YS
M=&%L;$UO9&4@.<F5T=7)N960Z(#$-"C$X.C T.C4U($EN<W1A;&Q-;V1E(#H@.
M,'@.Q#0HQ.#HP-#HU-2!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V1);G-T86QL
M36]D90T*,3@.Z,#0Z-34@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ
M.#HP-#HU-2!N1G5L;$UA<VL@./2 P>&)F,# P,S<L(&Y#=7)R96YT(#T@.,'@.T
M+"!N1&ER96-T:6]N(#T@.,0T*,3@.Z,#0Z-34@.57!D871E9"!$:6%L;V<@.36%S
M:SH@.,'AB9C0P,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$X.C T.C4U($1I
M86QO9R P>#0@.<F5T=7)N960Z(#$-"C$X.C T.C4U($5N9"!!8W1I;VX@.4VAO
M=T1I86QO9W-(;'!R#0HQ.#HP-#HU-2!3:&]W1&EA;&]G<T=E=$1I86QO9R!R
M971U<FYE9#H@.;D-U<G)E;G0],'@.Q,"QI;F1E>#TT#0HQ.#HP-#HU-2!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$P#0HQ.#HP-#HU-2!"96=I
M;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,3@.Z,#0Z
M-38@.16YD($%C=&EO;B!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,3@.Z
M,#0Z-38@.1&EA;&]G(#!X,3 @.<F5T=7)N960Z(#$-"C$X.C T.C4V($5N9"!!
M8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HQ.#HP-#HU-B!3:&]W1&EA;&]G<T=E
M=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.R,"QI;F1E>#TU#0HQ.#HP
M-#HU-B!"96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#(P#0HQ.#HP
M-#HU-B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1,:6-E;G-E#0HQ.#HP
M-#HU.2!%;F0@.06-T:6]N($1I86QO9U-H;W=39$QI8V5N<V4-"C$X.C T.C4Y
M($1I86QO9R P>#(P(')E='5R;F5D.B Q#0HQ.#HP-#HU.2!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#0Z-3D@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X-# P,# L:6YD97@.],3@.-"C$X.C T
M.C4Y($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# -"C$X
M.C T.C4Y($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$-L:5-V<@.T*,3@.Z
M,#0Z-3D@.1&ES<&QA>5-Y<W1E;5!R95)E<0T*,3@.Z,#4Z,#,@.4VAO=T1L9T-L
M:65N=%-E<G9E<E-E;&5C="!R971U<FYE9#H@.,0T*,3@.Z,#4Z,#,@.5'EP92 Z
M(#!X,@.T*,3@.Z,#4Z,#,@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQI4W9R
M#0HQ.#HP-3HP,R!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$X.C U
M.C S(&Y&=6QL36%S:R ](#!X8F8T,# S-RP@.;D-U<G)E;G0@./2 P>#0P,# P
M+"!N1&ER96-T:6]N(#T@.,0T*,3@.Z,#4Z,#,@.57!D871E9"!$:6%L;V<@.36%S
M:SH@.,'AB9F,P,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$X.C U.C S($1I
M86QO9R P>#0P,# P(')E='5R;F5D.B Q#0HQ.#HP-3HP,R!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#4Z,#,@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# L:6YD97@.],3D-"C$X.C U
M.C S($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X.# P,# -"C$X
M.C U.C S($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$EN<W1A;F-E3F%M
M90T*,3@.Z,#4Z,#,@.0F5G:6X@.06-T:6]N.B!3:&]W1&QG26YS=&%N8V5.86UE
M#0HQ.#HP-3HP."!%;F0@.06-T:6]N.B!3:&]W1&QG26YS=&%N8V5.86UE#0HQ
M.#HP-3HP."!3:&]W1&QG26YS=&%N8V5.86UE(')E='5R;F5D(#H@.,0T*,3@.Z
M,#4Z,#@.@.26YS=&%N8V5.86UE(#H@.0U-03#)+#0HQ.#HP-3HP."!%;F0@.06-T
M:6]N("!$:6%L;V=3:&]W4V1);G-T86YC94YA;64-"C$X.C U.C X(&)E9VEN
M(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#4Z,#@.@.;D9U;&Q-87-K(#T@.
M,'AB9F,P,#,W+"!N0W5R<F5N=" ](#!X.# P,# L(&Y$:7)E8W1I;VX@./2 Q
M#0HQ.#HP-3HP."!5<&1A=&5D($1I86QO9R!-87-K.B P>&)F8S P,S<L($1I
M<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#4Z,#@.@.1&EA;&]G(#!X.# P,# @.<F5T
M=7)N960Z(#$-"C$X.C U.C X($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R
M#0HQ.#HP-3HP."!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U
M<G)E;G0],'@.Q,# P,# L:6YD97@.],C -"C$X.C U.C X($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# P#0HQ.#HP-3HP."!"96=I;B!!
M8W1I;VXZ("!$:6%L;V=3:&]W4V13971U<%1Y<&4-"C$X.C U.C X($)E9VEN
M($%C=&EO;CH@.4V5T=7 @.5'EP90T*,3@.Z,#4Z-3(@.4U%,('!R;V=R86T@.9F]L
M9&5R.B!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HQ
M.#HP-3HU,B!344P@.9&%T82!F;VQD97(Z($0Z7%!R;V=R86T@.1FEL97-<36EC
M<F]S;V9T(%-13"!397)V97(-"C$X.C U.C4R(%=I;F1O=W,@.<WES=&5M(&9O
M;&1E<CH@.0SI<5TE.3E1<<WES=&5M,S)<#0HQ.#HP-3HU,B!0<F]G(')E<3H@.
M,S0W.#DL($1A=&$@.<F5Q.B S-#0S,BP@.4WES(')E<3H@.,3,R,38X#0HQ.#HP
M-3HU,B!0<F]G(&%V86EL.B Q-30S.3$R+"!$871A(&%V86EL.B Q-30S.3$R
M+"!3>7,@.879A:6PZ(#4U,C<S,S8-"C$X.C U.C4R(%!R;V<@.<F5Q('9S+B!A
M=F%I;"P@.-CDR,C$L(#$U-#,Y,3(-"C$X.C U.C4R($1A=&$@.<F5Q('9S+B!A
M=F%I;"P@.,S0T,S(L(#$U-#,Y,3(-"C$X.C U.C4R(%-Y<R!R97$@.=G,N(&%V
M86EL+" Q,S(Q-C@.L(#4U,C<S,S8-"C$X.C U.C4R($1I<W!L87E3>7-T96U0
M<F5297$-"C$X.C U.C4R(%M3971U<%1Y<&5344Q=#0HQ.#HP-3HU,B!S>D1I
M<B ]($0Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T(%-13"!397)V97(-"C$X
M.C U.C4R('-Z1&ER(#T@.1#I<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,
M(%-E<G9E<@.T*,3@.Z,#4Z-3(@.4F5S=6QT(#T@.,S Q#0HQ.#HP-3HU,B!S>D1A
M=&%$:7(@./2!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R
M#0HQ.#HP-3HU,B!S>D1A=&%$:7(@./2!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R#0HQ.#HP-3HU,B!%;F0@.06-T:6]N.B!3971U<"!4
M>7!E#0HQ.#HP-3HU,B!3971U<"!4>7!E.B!4>7!I8V%L("@.S,#$I#0HQ.#HP
M-3HU,B!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V13971U<%1Y<&4-"C$X.C U
M.C4R(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#4Z-3(@.;D9U
M;&Q-87-K(#T@.,'AB9F,P,#,W+"!N0W5R<F5N=" ](#!X,3 P,# P+"!N1&ER
M96-T:6]N(#T@.,S Q#0HQ.#HP-3HU,R!5<&1A=&5D($1I86QO9R!-87-K.B P
M>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#4Z-3,@.1&EA;&]G
M(#!X,3 P,# P(')E='5R;F5D.B S,#$-"C$X.C U.C4S($5N9"!!8W1I;VX@.
M4VAO=T1I86QO9W-(;'!R#0HQ.#HP-3HU,R!3:&]W1&EA;&]G<T=E=$1I86QO
M9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.T,# P,# L:6YD97@.],C(-"C$X.C U
M.C4S($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# P#0HQ
M.#HP-3HU,R!"96=I;B!!8W1I;VXZ("!$;&=397)V:6-E<PT*,3@.Z,#8Z,#$@.
M4VAO=T1L9U-E<G9I8V5S(')E='5R;F5D.B Q#0HQ.#HP-CHP,2!;1&QG4V5R
M=FEC97-=#0HQ.#HP-CHP,2!,;V-A;"U$;VUA:6X)/2 V,38X, T*,3@.Z,#8Z
M,#$@.075T;U-T87)T"0D](#$U#0HQ.#HP-CHP,2!344Q$;VUA:6X)"3T@.0TA%
M3%-/1E0-"C$X.C V.C Q(%-13$1O;6%I;D%C8W0)/2!!9&UI;FES=')A=&]R
M#0HQ.#HP-CHP,2!344Q$;VUA:6Y0=V0-"C$X.C V.C Q($%G=$1O;6%I;@.D)
M/2!#2$5,4T]&5 T*,3@.Z,#8Z,#$@.06=T1&]M86EN06-C= D]($%D;6EN:7-T
M<F%T;W(-"C$X.C V.C Q($%G=$1O;6%I;E!W9 T*,3@.Z,#8Z,#$@.4F5S=6QT
M"3T@.,0T*,3@.Z,#8Z,#$@.16YD($%C=&EO;B!$;&=397)V:6 -E<PT*,3@.Z,#8Z
M,#$@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ.#HP-CHP,2!N1G5L
M;$UA<VL@./2 P>&)D8S P,S<L(&Y#=7)R96YT(#T@.,'@.T,# P,# L(&Y$:7)E
M8W1I;VX@./2 Q#0HQ.#HP-CHP,2!5<&1A=&5D($1I86QO9R!-87-K.B P>&)D
M8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z,#$@.1&EA;&]G(#!X
M-# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHP,2!%;F0@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<@.T*,3@.Z,#8Z,#$@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T
M=7)N960Z(&Y#=7)R96YT/3!X.# P,# P+&EN9&5X/3(S#0HQ.#HP-CHP,2!"
M96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#@.P,# P, T*,3@.Z,#8Z
M,#$@.0F5G:6X@.06-T:6]N.B @.1&QG4U%,4V5C=7)I='D-"C$X.C V.C,S(%-H
M;W=$;&=344Q396-U<FET>2!R971U<FYE9#H@.,0T*,3@.Z,#8Z,S,@.3&]G:6Y-
M;V1E(#T@.,BQS>E!W9 T*,3@.Z,#8Z,S,@.16YD($%C=&EO;B!$;&=344Q396-U
M<FET>0T*,3@.Z,#8Z,S,@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ
M.#HP-CHS,R!N1G5L;$UA<VL@./2 P>&)D8S P,S<L(&Y#=7)R96YT(#T@.,'@.X
M,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ.#HP-CHS,R!5<&1A=&5D($1I86QO
M9R!-87-K.B P>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z
M,S,@.1&EA;&]G(#!X.# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHS,R!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#8Z,S,@.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,3 P,# P,"QI;F1E>#TR
M- T*,3@.Z,#8Z,S,@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q
M,# P,# P#0HQ.#HP-CHS,R!"96=I;B!!8W1I;VXZ("!$;&=#;VQL871I;VX-
M"C$X.C V.C,S(%-H;W=$;&=#;VQL871I;VX@.<F5T=7)N960Z(#$-"C$X.C V
M.C,S(&-O;&QA=&EO;E]N86UE(#T@.4U%,7TQA=&EN,5]'96YE<F%L7T-0,5]#
M25]!4RQL;V-A;&5?;F%M92 ]($QA=&EN,5]'96YE<F%L+&QC:60@./2 P>#0P
M.2Q3;W)T260@./2 U,BQD=T-O;7!&;&%G<R ](#!X,S P,#$-"C$X.C V.C,S
M($5N9"!!8W1I;VX@.1&QG0V]L;&%T:6]N#0HQ.#HP-CHS,R!B96=I;B!3:&]W
M1&EA;&]G<U5P9&%T94UA<VL-"C$X.C V.C,S(&Y&=6QL36%S:R ](#!X8F1C
M,# S-RP@.;D-U<G)E;G0@./2 P>#$P,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ
M.#HP-CHS,R!5<&1A=&5D($1I86QO9R!-87-K.B P>&)D8S P,S<L($1I<V%B
M;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z,S,@.1&EA;&]G(#!X,3 P,# P,"!R971U
M<FYE9#H@.,0T*,3@.Z,#8Z,S,@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C$X.C V.C,S(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#(P,# P,# L:6YD97@.],C4-"C$X.C V.C,S($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# P, T*,3@.Z,#8Z,S,@.0F5G:6X@.
M06-T:6]N.B @.1&QG3F5T=V]R:PT*,3@.Z,#8Z,S,@.4VAO=T1L9TYE='=O<FL@.
M<F5T=7)N960Z(#$-"C$X.C V.C,S(%M$;&=397)V97).971W;W)K70T*,3@.Z
M,#8Z,S,@.3F5T=V]R:TQI8G,@./2 R-34-"C$X.C V.C,S(%1#4%!O<G0@./2 P
M#0HQ.#HP-CHS,R!40U!0<GAY(#T@.1&5F875L= T*,3@.Z,#8Z,S,@.3DU04&EP
M94YA;64@./2!<7"Y<<&EP95Q-4U-13"1#4U!,,DM<<W%L7'%U97)Y#0HQ.#HP
M-CHS,R!297-U;'0@./2 Q#0HQ.#HP-CHS,R!%;F0@.06-T:6]N($1L9TYE='=O
M<FL-"C$X.C V.C,S(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z
M,#8Z,S,@.;D9U;&Q-87-K(#T@.,'AB9&,P,#,W+"!N0W5R<F5N=" ](#!X,C P
M,# P,"P@.;D1I<F5C=&EO;B ](#$-"C$X.C V.C,S(%5P9&%T960@.1&EA;&]G
M($UA<VLZ(#!X8F1C,# S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ.#HP-CHS
M,R!$:6%L;V<@.,'@.R,# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHS,R!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#8Z,S,@.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# P,"QI;F1E>#TR
M-PT*,3@.Z,#8Z,S,@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.X
M,# P,# P#0HQ.#HP-CHS,R!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V13
M=&%R=$-O<'D-"C$X.C V.C,T($5N9"!!8W1I;VX@.1&EA;&]G4VAO=U-D4W1A
M<G1#;W!Y#0HQ.#HP-CHS-"!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-
M"C$X.C V.C,T(&Y&=6QL36%S:R ](#!X8F1C,# S-RP@.;D-U<G)E;G0@./2 P
M>#@.P,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ.#HP-CHS-"!5<&1A=&5D($1I
M86QO9R!-87-K.B P>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z
M,#8Z,S0@.1&EA;&]G(#!X.# P,# P,"!R971U<FYE9#H@.,0T*,3@.Z,#8Z,S0@.
M16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$X.C V.C,T(%-H;W=$:6%L
M;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP># L:6YD97@.], T*
M,3@.Z,#8Z,S0@.16YD($%C=&EO;B!3:&]W1&EA;&]G<PT*,3@.Z,#8Z,S0@.0F5G
M:6X@.06-T:6]N(%!R;V-E<W-"969O<F5$871A36]V93H-"C$X.C V.C,T($1E
M:6YS=&%L;%-T87)T(')E='5R;F5D("A$.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R7$U34U%,)$-34$PR2RDZ(# -"C$X.C V.C,T($5N
M9"!!8W1I;VX@.("!0<F]C97-S0F5F;W)E1&%T84UO=F4Z#0HQ.#HP-CHS-"!"
M96=I;B!!8W1I;VX@.4V5T5&]O;'-#;VUP;VYE;G1396QE8W1I;VXZ#0HQ.#HP
M-CHS-"!#<F5A=&53971U<%1O<&]L;V=Y*$-34$PI+"!(86YD;&4@..B P>#$X
M.30Q-# L(')E='5R;F5D(#H@., T*,3@.Z,#8Z,S0@.0W)E871E4V5T=7!4;W!O
M;&]G>2!R971U<FYE9" Z(# L($AA;F1L92 Z(#!X,3@.Y-#$T, T*,3@.Z,#8Z
M,S0@.5&]P;VQO9WD@.5'EP92 Z(#$L(%)E='5R;B!686QU92 Z(# -"C$X.C V
M.C,T(%-47T=E=%!H>7-I8V%L3F]D92!R971U<FYE9" Z(# L(%!.2&%N9&QE
M(#H@.,'@.Q.#DT,38X#0HQ.#HP-CHS-"!03E]%;G5M97)A=&5%>"!R971U<FYE
M9" Z(# -"C$X.C V.C,T(%!.7T=E=%-13%-T871E<R!R971U<FYE9" Z(# L
M(%-Q;%-T871E<R Z(#!X,C(W#0HQ.#HP-CHS-"!03E]3=&%R=%-C86X@.6S!X
M,3@.Y-#$V.%T@.<F5T=7)N960@..B P#0HQ.#HP-CHS-"!03E]'971.97AT(%LP
M>#$X.30Q-CA=(')E='5R;F5D(#H@.,"P@.2&%N9&QE.B!;,'@.Q.#DU,#@.P70T *
M,3@.Z,#8Z,S0@.4U%,25]'9714>7!E(%LP>#$X.34P.#!=(')E='5R;F5D(#H@.
M,"P@.;E1Y<&4Z(#!X,PT*,3@.Z,#8Z,S0@.4U%,25]'971);G-T86QL4&%T:"!;
M,'@.Q.#DU,#@.P72!R971U<FYE9" Z(# L(%!A=&@.@./2!$.EQ0<F]G<F%M($9I
M;&5S7$U34U%,-PT*,3@.Z,#8Z,S0@.4U%,25]'971$871A4&%T:"!;,'@.Q.#DU
M,#@.P72!R971U<FYE9" Z(# L($1A=&%0871H(#T@.1#I<4')O9W)A;2!&:6QE
M<UQ-4U-13#<-"C$X.C V.C,T(%-13$E?1V5T5F5R<VEO;B!;,'@.Q.#DU,#@.P
M72!R971U<FYE9" Z(# L(%9E<G-I;VX@./2 W+C P+C8R,PT*,3@.Z,#8Z,S0@.
M4U%,25]'971296=+97E2;V]T(%LP>#$X.34P.#!=(')E='5R;F5D(#H@.,"P@.
M4F5G2V5Y4F]O=" ](%-O9G1W87)E7$UI8W)O<V]F=%Q-4U-13%-E<G9E<@.T*
M,3@.Z,#8Z,S0@.5&]O;',@.4&%T:#H@.(" @.($0Z7%!R;V=R86T@.1FEL97-<35-3
M44PW#0HQ.#HP-CHS-"!4;V]L<R!697)S:6]N.B @.-RXP,"XV,C,-"C$X.C V
M.C,T(%1O;VQS(%)E9VES=')Y.B!3;V9T=V%R95Q-:6-R;W-O9G1<35-344Q3
M97)V97(-"C$X.C V.C,T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N
M960@..B Q."P@.2&%N9&QE.B!;,'@.P70T*,3@.Z,#8Z,S0@.1F]R8V4@.4'5R9V4-
M"C$X.C V.C,T(%!.7U-T87)T4V-A;B!;,'@.Q.#DT,38X72!R971U<FYE9" Z
M(# -"C$X.C V.C,T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N960@.
M.B P+"!(86YD;&4Z(%LP>#$X.30V9CA=#0HQ.#HP-CHS-"!344Q)7T=E=$EN
M<W1A;&Q0871H(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.4 &%T:" ]($0Z
M7%!R;V=R86T@.1FEL97-<35-344PW#0HQ.#HP-CHS-"!344Q)7T=E=$1A=&%0
M871H(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.1&%T85!A= &@.@./2!$.EQ0
M<F]G<F%M($9I;&5S7$U34U%,-PT*,3@.Z,#8Z,S0@.4U%,25]'971697)S:6]N
M(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.5F5R<VEO;B ](#<N,# N-C(S
M#0HQ.#HP-CHS-"!344Q)7T=E=%)E9TME>5)O;W0@.6S!X,3@.Y-#9F.%T@.<F5T
M=7)N960@..B P+"!296=+97E2;V]T(#T@.4V]F='=A<F5<36EC<F]S;V9T7$U3
M4U%,4V5R=F5R#0HQ.#HP-CHS-"!03E]'971.97AT(%LP>#$X.30Q-CA=(')E
M='5R;F5D(#H@.,3@.L($AA;F1L93H@.6S!X,%T-"C$X.C V.C,T(%)E;&5A<V53
M971U<%1O<&]L;V=Y#0HQ.#HP-CHS-"!%;F0@.06-T:6]N(%-E=%1O;VQS0V]M
M<&]N96YT4V5L96-T:6]N.@.T*,3@.Z,#8Z,S0@.0F5G:6X@.06-T:6]N(%!R;V-E
M<W-#;VUP;VYE;G1396QE8W1I;VXZ#0HQ.#HP-CHS-"!%;F0@.06-T:6]N(%!R
M;V-E<W-#;VUP;VYE;G1396QE8W1I;VX-"C$X.C V.C,T($)E9VEN($%C=&EO
M;B!,;V=396QE8W1E9$-O;7!O;F5N=',Z#0HQ.#HP-CHS-"!344Q0<F]G#0HQ
M.#HP-CHS-"!344Q0<F]G7%-13%-E<G9R#0HQ.#HP-CHS-"!344Q0<F]G7%-1
M3%-E<G9R7$AE;' -"C$X.C V.C,T(%-13%!R;V=<4U%,4V5R=G)<4T--1&5V
M#0HQ.#HP-CHS-"!344Q0<F]G7%-13%-E<G9R7%-#341E=EQ30TUH#0HQ.#HP
M-CHS-"!344Q0<F]G7%-13%-E<G9R7%-#341E=EQ30TU8.#9,8@.T*,3@.Z,#8Z
M,S0@.4U%,4')O9UQ344Q397)V<EQ30TU$979<4T--04QB#0HQ.#HP-CHS-"!3
M44Q0<F]G7%-13%-E<G9R7%)S,3 S,PT*,3@.Z,#8Z,S0@.4U%,4')O9UQ344Q3
M97)V<EQ2<TEN=&P-"C$X.C V.C,T(%-13%!R;V=<4U%,4V5R=G)<06-T:79E
M6 T*,3@.Z,#8Z,S0@.4U%,4')O9UQ344Q397)V<EQ3>7-T96T-"C$X.C V.C,T
M(%-13%!R;V=<4F5P;%-U<' -"C$X.C V.C,T(%-13%!R;V=<4F5P;%-U<'!<
M4F5P;$1A= T*,3@.Z,#8Z,S0@.4U%,4')O9UQ297!L4W5P<%Q297!#;VUM#0HQ
M.#HP-CHS-"!344Q0<F]G7%)E<&Q3=7!P7%)E<$YO1&L-"C$X.C V.C,T(%-1
M3%!R;V=<4F5P;%-U<'!<06-T:79E6 T*,3@.Z,#8Z,S0@.4U%,4')O9UQ);G-T
M86QL#0HQ.#HP-CHS-"!344Q0<F]G7%-Y<W1E;0T*,3@.Z,#8Z,S0@.4U%,4')O
M9UQ3=G)%>'0-"C$X.C V.C,T(%-13%!R;V=<4W9R17AT7$AE;' -"C$X.C V
M.C,T(%-13%!R;V=<4W9R17AT7%-V<D5X=%)S#0HQ.#HP-CHS-"!344Q0<F]G
M7%-V<D5X=%Q297-);G1L#0HQ.#HP-CHS-"!344Q0<F]G7$1A= T*,3@.Z,#8Z
M,S0@.4U%,4')O9UQ$8713;7!L#0HQ.#HP-CHS-"!344Q0<F]G7$)A<V53>7,-
M"C$X.C V.C,T(%-13%!R;V=<0F%S94)I;FX-"C$X.C V.C,T(%-13%!R;V=<
M35-396%R8V@.-"C$X.C V.C,T(%-13%!R;V=<35-396%R8VA<2&5L< T*,3@.Z
M,#8Z,S0@.4U%,4')O9UQ-4U-E87)C:%Q!8W1I=F58#0HQ.#HP-CHS-"!344Q0
M<F]G7$)A<V5);G-T#0HQ.#HP-CHS-"!344Q0<F]G7%-Y;6)O;',-"C$X.C V
M.C,T(%-13%!R;V=<4WEM8F]L<UQ%6$4-"C$X.C V.C,T(%-13%!R;V=<4WEM
M8F]L<UQ$3$P-"C$X.C V.C,T(%-13%!R;V=<4&5R9FUO;@.T*,3@.Z,#8Z,S0@.
M4U%,4')O9UQ097)F;6]N7%-Y<W1E;0T*,3@.Z,#8Z,S0@.4U%,4')O9UQ2;V]T
M#0HQ.#HP-CHS-"!-9W14;V]L#0HQ.#HP-CHS-"!-9W14;V]L7%-%30T*,3@.Z
M,#8Z,S0@.36=T5&]O;%Q314U<2%1-3 T*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<
M35-$.3@.-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$U31#DX4UE3#0HQ.#HP-CHS
M-"!-9W14;V]L7%-%35Q-4T0Y.%)E<PT*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<
M35-$.3A(;' -"C$X.C V.C,T($UG=%1O;VQ<4T5-7$AE;' -"C$X.C V.C,T
M($UG=%1O;VQ<4T5-7%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7%)E
M<TEN=&P-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$U31#DX4G-)#0HQ.#HP-CHS
M-"!-9W14;V]L7%-%35Q!8W1I=F58#0HQ.#HP-CHS-"!-9W14;V]L7%-%35Q!
M8W1I=F587%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$%C=&EV95A<
M4F5S26YT; T*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<4V-R:7!T<PT*,3@.Z,#8Z
M,S0@.36=T5&]O;%Q314U<3TQ%1$(-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$],
M141"7%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$],141"7%)E<TEN
M=&P-"C$X.C V.C,T($UG=%1O;VQ<4')O9FEL97(-"C$X.C V.C,T($UG=%1O
M;VQ<4')O9FEL97)<2&5L< T*,3@.Z,#8Z,S0@.36=T5&]O;%Q0<F]F:6QE<EQ2
M97,Q,#,S#0HQ.#HP-CHS-"!-9W14;V]L7%!R;V9I;&5R7%)E<TEN=&P-"C$X
M.C V.C,T($UG=%1O;VQ<47)Y86YL>@.T*,3@.Z,#8Z,S0@.36=T5&]O;%Q1<GEA
M;FQZ7$AE;' -"C$X.C V.C,T($UG=%1O;VQ<47)Y86YL>EQ297,Q,#,S#0HQ
M.#HP-CHS-"!-9W14;V]L7%%R>6%N;'I<4F5S26YT; T*,3@.Z,#8Z,S0@.36=T
M5&]O;%Q$5$-#3&D-"C$X.C V.C,T($UG=%1O;VQ<5WIC;F9L8W0-"C$X.C V
M.C,T($UG=%1O;VQ<5WIC;F9L8W1<5WIC;DAL< T*,3@.Z,#8Z,S0@.36=T5&]O
M;%Q7>F-N9FQC=%Q7>F-N,3 S,PT*,3@.Z,#8Z,S0@.36=T5&]O;%Q7>F-N9FQC
M=%Q7>F-N3W1H<@.T*,3@.Z,#8Z,S0@.36=T5&]O;%Q7>F-N9FQC=%Q7>F-N0VUN
M#0HQ.#HP-CHS-"!-9W14;V]L7%5T:6Q3>7,-"C$X.C V.C,T($UG=%1O;VQ<
M571I;$)I;FX-"C$X.C V.C,T($-O;FYE8W0-"C$X.C V.C,T($-O;FYE8W1<
M0V]N;E-Y<PT*,3@.Z,#8Z,S0@.0F]O:W,-"C$X.C V.C,T($)O;VMS7$)O;VMS
M;PT*,3@.Z,#8Z,S0@.0F]O:W-<0F]O:W-O7%5T:6QS#0HQ.#HP-CHS-"!$9794
M;V]L<PT*,3@.Z,#8Z,S0@.1&5V5&]O;'-<1&)G($EN= T*,3@.Z,#8Z,S0@.1&5V
M5&]O;'-<1&)G($EN=%Q$8F<@.26YT($-O;6UO;@.T*,3@.Z,#8Z,S0@.1&5V5&]O
M;'-<1&)G($EN=%Q%6$4-"C$X.C V.C,T($-O<F5297!L#0HQ.#HP-CHS-"!#
M;W)E4F5P;%Q297,Q,#,S#0HQ.#HP-CHS-"!#;W)E4F5P;%Q297-);G1L#0HQ
M.#HP-CHS-"!#;W)E#0HQ.#HP-CHS-"!#;W)E7%)E<S$P,S,-"C$X.C V.C,T
M($-O<F5<4F5S3W1H97(-"C$X.C V.C,T(%)E<&]S=')Y#0HQ.#HP-CHS-"!2
M97!O<W1R>5Q297!S=%-Y<PT*,3@.Z,#8Z,S0@.4F5P;W-T<GE<4F5S,3 S,PT*
M,3@.Z,#8Z,S0@.4F5P;W-T<GE<4F5S26YT; T*,3@.Z,#8Z,S0@.0V]R94UI<V,-
M"C$X.C V.C,T($-O<F5-:7-C7$%C=&EV95@.-"C$X.C V.C,T($-O<F5-:7-C
M7$%C=&EV95A<4F5S,3 S,PT*,3@.Z,#8Z,S0@.0V]R94UI<V-<06-T:79E6%Q2
M97-);G1L#0HQ.#HP-CHS-"!#;W)E36ES8UQ297,Q,#,S#0HQ.#HP-CHS-"!-
M;VYA<F-H#0HQ.#HP-CHS-"!-;VYA<F-H7$UO;G(Q,#,S#0HQ.#HP-CHS-"!-
M;VYA<F-H7$UO;G));G1L#0HQ.#HP-CHS-"!*970-"C$X.C V.C,T($-O<F5)
M;G-T#0HQ.#HP-CHS-"!#;W)E0T]-#0HQ.#HP-CHS-"!#;W)E0T]-7%)E<S$P
M,S,-"C$X.C V.C,T($-O<F5#3TU<4F5S26YT; T*,3@.Z,#8Z,S0@.0V]R951O
M;VP-"C$X.C V.C,T($-O<F54;V]L7%)E<S$P,S,-"C$X.C V.C,T($-O<F54
M;V]L7%)E<T]T:&5R#0HQ.#HP-CHS-"!$0DQI8D-L:0T*,3@.Z,#8Z,S0@.4T9%
M>'0-"C$X.C V.C,T(%-&17AT7$%C=&EV95@.-"C$X.C V.C,T(%-&17AT7$%C
M=&EV95A<4F5S,3 S,PT*,3@.Z,#8Z,S0@.4T9%>'1<06-T:79E6%Q297-);G1L
M#0HQ.#HP-CHS-"!31D5X=%Q297,Q,#,S#0HQ.#HP-CHS-"!31D5X=%Q297-)
M;G1L#0HQ.#HP-CHS-"!4<F%C90T*,3@.Z,#8Z,S0@.5')A8V5<4F5S,3 S,PT*
M,3@.Z,#8Z,S0@.5')A8V5<4F5S3W1H97(-"C$X.C V.C,T($UI<V-#;W)E#0HQ
M.#HP-CHS-"!-0PT*,3@.Z,#8Z,S0@.34-<34,Q,#,S#0HQ.#HP-CHS-"!-0UQ-
M0TEN=&P-"C$X.C V.C,T($U#7$AE;' -"C$X.C V.C,T(%-13$UG<@.T*,3@.Z
M,#8Z,S0@.4U%,36=R7%)E<S$P,S,-"C$X.C V.C,T(%-13$UG<EQ297-);G1L
M#0HQ.#HP-CHS-"!3=G)4;V]L#0HQ.#HP-CHS-"!3=G)4;V]L7%)E<S$P,S,-
M"C$X.C V.C,T(%-V<E1O;VQ<4F5S26YT; T*,3@.Z,#8Z,S0@.1%1354D-"C$X
M.C V.C,T($144U5)7%)E<S$P,S,-"C$X.C V.C,T($144U5)7%)E<TEN=&P-
M"C$X.C V.C,T($U33VQA< T*,3@.Z,#8Z,S0@.35-/;&%P7%)E<S$P,S,-"C$X
M.C V.C,T($U33VQA<%Q297-);G1L#0HQ.#HP-CHS-"!!5$P-"C$X.C V.C,T
M($%43%QW:6YN= T*,3@.Z,#8Z,S0@.051,7'=I;CEX#0HQ.#HP-CHS-"!-1D,T
M,E4-"C$X.C V.C,T(%9##0HQ.#HP-CHS-"!60@.T*,3@.Z,#8Z,S0@.4U%,061(
M;' -"C$X.C V.C,T(%-13$%D2&QP7%)E<S$P,S,-"C$X.C V.C,T(%-13$%D
M2&QP7%)E<T]T:&5R#0HQ.#HP-CHS-"![13 W1D1$0D4M-4$R,2TQ,60R+3E$
M040M,#!#,#1&-SE$-#,T?0T*,3@.Z,#8Z,S0@.>T4P-T9$1$,W+35!,C$M,3%D
M,BTY1$%$+3 P0S T1C<Y1#0S-'T-"C$X.C V.C,T('M%,#=&1$1#,"TU03(Q
M+3$Q9#(M.41!1"TP,$,P-$8W.40T,S1]#0HQ.#HP-CHS-"![13 W1D1$0D8M
M-4$R,2TQ,60R+3E$040M,#!#,#1&-SE$-#,T?0T*,3@.Z,#8Z,S0@.16YD($%C
M=&EO;B!,;V=396QE8W1E9$-O;7!O;F5N=',-"C$X.C V.C,T($)E9VEN($%C
M=&EO;B!);G-T86QL4&MG<SH-"C$X.C V.C,T($)E9VEN($%C=&EO;CH@.3&]C
M:V5D($-O;FYE8W1I=FET>2!&:6QE<R!#:&5C:PT*,3@.Z,#8Z,S8@.0V]N;F5C
M=&EV:71Y3&]C:V5D(')E='5R;F5D.B P#0HQ.#HP-CHS-B!4:&4@.;W!E<F%T
M:6]N(&-O;7!L971E9"!S=6-C97-S9G5L;'DN#0H-"C$X.C V.C,V($5N9"!!
M8W1I;VXZ($QO8VME9"!#;VYN96-T:79I='D@.1FEL97,@.0VAE8VL-"C$X.C V
M.C,V(%-E='5P(&ES(&EN<W1A;&QI;F<@.36EC<F]S;V9T($1A=&$@.06-C97-S
M($-O;7!O;F5N=',@.*$U$04,I("XN+@.T*,3@.Z,#8Z,S8@.7%Q#4U!,7 %-O9G1W
M87)E7$]T:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8.#9<3W1H97)<<W%L<F5D
M:7,N97AE("]Q.F$@.+T,Z(G-E='5P<F4N97AE(%=!4DX],2 M<R M4TU3(@.T*
M,3@.Z,#<Z,C @.17AI=$-O9&4Z(# -"C$X.C W.C(P(%-E='5P(&ES(&EN<W1A
M;&QI;F<@.36EC<F]S;V9T($1I<W1R:6)U=&5D(%1R86YS86-T:6]N($-O;W)D
M:6YA=&]R("A-4T140RD@.+BXN#0HQ.#HP-SHR," @.0SI<1$]#54U%?C%<041-
M24Y)?C%<3$]#04Q3?C%<5&5M<%Q3<6Q3971U<%Q":6Y<8VQD=&-S=' N97AE
M("U3=7!P;W)T1&ER(")#.EQ$3T-5345^,5Q!1$U)3DE^,5Q,3T-!3%-^,5Q4
M96UP7%-Q;%-E='5P7$)I;B(@.+4140U!K9R B7%Q#4U!,7%-O9G1W87)E7$]T
M:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8.#9<3W1H97)<9'1C<V5T=7 N97AE
M(B M3&]G1FEL92 B0SI<5TE.3E1<<W%L<W1P+FQO9R(-"C$X.C W.C(P(%!R
M;V-E<W,@.17AI="!#;V1E.B H,"D@.#0HQ.#HP-SHR,"!);G-T86QL35-396%R
M8V@.@.:6YS=&%N8V4Z($-34$PR2PT*,3@.Z,#<Z,C @.4V]F='=A<F5<36EC<F]S
M;V9T7%-E87)C:%Q);G-T86QL.E9E<G-I;VX@.;F]T('!R97-E;G0-"C$X.C W
M.C(P($U34V5A<F-H(#(N,"!O<B!G<F5A=&5R('9E<G-I;VX@.8VAE8VL@.<F5T
M=7)N960@.+3$-"C$X.C W.C(Q(%-E='5P(&ES(&EN<W1A;&QI;F<@.=&AE($UI
M8W)O<V]F="!&=6QL+51E>'0@.4V5A<F-H($5N9VEN92 N+BX-"C$X.C W.C(Q
M(" B7%Q#4U!,7%-O9G1W87)E7$]T:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8
M.#9<1G5L;%1E>'1<35-396%R8VA<4V5A<F-H7%-E87)C:%-T<"YE>&4B("]S
M("]A.E-13%-E<G9E<B1#4U!,,DL-"C$X.C W.C0U(%!R;V-E<W,@.17AI="!#
M;V1E.B H,"D@.#0HQ.#HP-SHT-2 @.+U$Z02 O5#I#.EQ$3T-5345^,5Q!1$U)
M3DE^,5Q,3T-!3%-^,5Q496UP7&EX<# P,2YT;7 -"C$X.C W.C0U(%-E='5P
M(&ES(&EN<W1A;&QI;F<@.2%1-3"!(96QP("XN+@.T*,3@.Z,#<Z-#8@.2%1-3"!(
M96QP(&EN<W1A;&QE<B!E>&ET(&-O9&4Z(# -"C$X.C X.C X($5N9"!!8W1I
M;VX@.26YS=&%L;%!K9W,-"C$X.C X.C X($)E9VEN($%C=&EO;B!-;W9E1FEL
M941A=&$Z#0HQ.#HP.#HP."!%;F%B;&5D(%-%3$9214=)4U1%4D)!5$-(#0HQ
M.#HP.#HP."!%;F%B;&5D($-/4D5#3TU03TY%3E1(04Y$3$E.1PT*,3@.Z,#DZ
M,# @.0F5G:6X@.06-T:6]N.B @.36]V949I;&5$871A4W!E8VEA; T*,3@.Z,#DZ
M,#$@.16YD($%C=&EO;CH@.($UO=F5&:6QE1&%T85-P96-I86P-"C$X.C Y.C Q
M($5N9"!!8W1I;VX@.("!-;W9E1FEL941A=&$-"C$X.C Y.C Q(%-E=%)E9D-O
M=6YT.B!#.EQ724Y.5%QS>7-T96TS,EQN='=D8FQI8BYD;&P@.*#4I#0HQ.#HP
M.3HP,2!"96=I;B!!8W1I;VX@.4')O8V5S<T%F=&5R1&%T84UO= F4Z#0HQ.#HP
M.3HP,2!<7$-34$Q<4V]F='=A<F5<3W1H97)S7%-13#(P,#!<1$5614Q/?C%<
M6#@.V7$)I;FY<:&AC;VPN97AE($,Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T
M(%-13"!397)V97)<.#!<5&]O;'-<0F]O:W,-"C$X.C Y.C R($5N9"!!8W1I
M;VX@.("!0<F]C97-S069T97)$871A36]V90T*,3@.Z,#DZ,#(@.0F5G:6X@.06-T
M:6]N($)U:6QD4V5R=F5R.@.T*,3@.Z,#DZ,#(@.0SI<1$]#54U%?C%<041-24Y)
M?C%<3$]#04Q3?C%<5&5M<%Q3<6Q3971U<%Q":6Y<<V-M+F5X92 @.+5-I;&5N
M=" Q("U!8W1I;VX@.-2 M17AE4&%T:" B1#I<4')O9W)A;2!&:6QE<UQ-:6-R
M;W-O9G0@.4U%,(%-E<G9E<EQ-4U-13"1#4U!,,DM<8FEN;EQS<6QS97)V<BYE
M>&4B("U397)V:6-E(")-4U-13"1#4U!,,DLB#0HQ.#HP.3HP,R!0<F]C97-S
M($5X:70@.0V]D93H@.*# I( T*,3@.Z,#DZ,#,@.0F5G:6X@.06-T:6]N.B!#<F5A
M=&5296=I<W1R>5-E=%-13 T*,3@.Z,#DZ,#,@.16YD($%C=&EO;CH@.0W)E871E
M4F5G:7-T<GE3971344P-"C$X.C Y.C S($)E9VEN($%C=&EO;CH@.4F5G5W)I
M=&53971U<$5N=')Y#0HQ.#HP.3HP,R!%;F0@.06-T:6]N.B!296=7<FET95-E
M='5P16YT<GD-"C$X.C Y.C S($)E9VEN($%C=&EO;CH@.0W)E871E4V5R#0HQ
M.#HP.3HP,R!%;F0@.06-T:6]N.B!#<F5A=&5397(-"C$X.C Y.C S($)E9VEN
M($%C=&EO;CH@.4VMU270-"C$X.C Y.C S($5N9"!!8W1I;VXZ(%-K=4ET#0HQ
M.#HP.3HP-"!3971&:6QE4V5C=7)I='E344Q!;F1!9&UI;B!F;W(@.1#I<4') O
M9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<EQ-4U-13"1#4U!,,DL@.
M<F5T=7)N960Z(# L(# -"C$X.C Y.C T(%-E=%)E9U-E8W5R:71Y4U%,06YD
M061M:6X@.9F]R(%-O9G1W87)E7$UI8W)O<V]F=%Q-:6-R;W-O9G0@.4U%,(%-E
M<G9E<EQ#4U!,,DL@.<F5T=7)N960Z(# L(# -"C$X.C Y.C T($)E9VEN($%C
M=&EO;CH@.57!D871E4WES=&5M4&%T: T*,3@.Z,#DZ,#0@.4&%T:"!S=6-C97-S
M9G5L;'D@.=7!D871E9"X-"C$X.C Y.C T("5724XS,D1-25!!5$@.E7$))3CLE
M4WES=&5M4F]O="5<<WES=&5M,S([)5-Y<W1E;5)O;W0E.R53>7-T96U2;V]T
M)5Q3>7-T96TS,EQ78F5M.T0Z7%!R;V=R86T@.1FEL97-<35-344PW7$))3DX[
M0SI<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<EPX,%Q4;V]L
M<UQ"24Y.#0HQ.#HP.3HP-"!%;F0@.06-T:6]N.B!5<&1A=&53>7-T96U0871H
M#0HQ.#HP.3HP-"!'<F%N="!2:6=H="!F;W(@.0TA%3%-/1E1<061M:6YI<W1R
M871O<B!R971U<FYE9" Z(#$L(# -"C$X.C Y.C T($=R86YT(%)I9VAT(&9O
M<B!#2$5,4T]&5%Q!9&UI;FES=')A=&]R(')E='5R;F5D(#H@.,2P@., T*,3@.Z
M,#DZ,#4@.1W)A;G0@.4FEG:'0@.9F]R($-(14Q33T947$%D;6EN:7-T<F%T;W(@.
M<F5T=7)N960@..B Q+" P#0HQ.#HP.3HP-2!'<F%N="!2:6=H="!F;W(@.0TA%
M3%-/1E1<061M:6YI<W1R871O<B!R971U<FYE9" Z(#$L(# -"C$X.C Y.C U
M($=R86YT(%)I9VAT(&9O<B!#2$5,4T]&5%Q!9&UI;FES=')A=&]R(')E='5R
M;F5D(#H@.,2P@., T*,3@.Z,#DZ,#8@.0SI<4')O9W)A;2!&:6QE<UQ-:6-R;W-O
M9G0@.4U%,(%-E<G9E<EPX,%Q4;V]L<UQ":6YN7&-N9F=S=G(N97AE(" M1B B
M0SI<5TE.3E1<<W%L<W1P+FQO9R(@.+4D@.0U-03#)+("U6(#$@.+4T@.," M42 B
M4U%,7TQA=&EN,5]'96YE<F%L7T-0,5]#25]!4R(@.+4@.@.,3DW,3(T("U5('-A
M("U0( T*(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C (R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C( R,C(PT*#0H-
M"E-T87)T:6YG(%-E<G9I8V4@.+BXN#0H-"E-13%],871I;C%?1V5N97)A;%]#
M4#%?0TE?05,-"@.T*+6T@.+5$@.+50T,#(R("U4,S8U.0T*#0I#;VYN96-T:6YG
M('1O(%-E<G9E<B N+BX-"@.T*9')I=F5R/7MS<6P@.<V5R=F5R?3MS97)V97(]
M0U-03%Q#4U!,,DL[54E$/7-A.U!71#T[9&%T86)A<V4];6%S=&5R#0H-"EM-
M:6-R;W-O9G1=6T]$0D,@.4U%,(%-E<G9E<B!$<FEV97)=6U1#4"])4"!3;V-K
M971S74=E;F5R86P@.;F5T=V]R:R!E<G)O<BX@.0VAE8VL@.>6]U<B!N971W;W)K
M(&1O8W5M96YT871I;VXN#0H-"EM-:6-R;W-O9G1=6T]$0D,@.4U%,(%-E<G9E
M<B!$<FEV97)=6U1#4"])4"!3;V-K971S74-O;FYE8W1I;VY296%D("AR96-V
M*"DI+@.T*#0ID<FEV97(]>W-Q;"!S97)V97)].W-E<G9E<CU#4U!,7$-34$PR
M2SM5240]<V$[4%=$/3MD871A8F%S93UM87-T97(-"@.T*6TUI8W)O<V]F=%U;
M3T1"0R!344P@.4V5R=F5R($1R:79E<EU;5$-0+TE0(%-O8VME='-=1V5N97)A
M;"!N971W;W)K(&5R<F]R+B!#:&5C:R!Y;W5R(&YE='=O<FL@.9&]C=6UE;G1A
M=&EO;BX-"@.T*6TUI8W)O<V]F=%U;3T1"0R!344P@.4V5R=F5R($1R:79E<EU;
M5$-0+TE0(%-O8VME='-=0V]N;F5C=&EO;E)E860@.*')E8W8H*2DN#0H-"F1R
M:79E<CU[<W%L('-E<G9E<GT[<V5R=F5R/4-34$Q<0U-03#)+.U5)1#US83M0
M5T0].V1A=&%B87-E/6UA<W1E<@.T*#0I;36EC<F]S;V9T75M/1$)#(%-13"!3
M97)V97(@.1')I=F5R75M40U O25 @.4V]C:V5T<UU'96YE<F%L(&YE='=O<FL@.
M97)R;W(N($-H96-K('EO=7(@.;F5T=V]R:R!D;V-U;65N=&%T:6]N+@.T*#0I;
M36EC<F]S;V9T75M/1$)#(%-13"!397)V97(@.1')I=F5R75M40U O25 @.4V]C
M:V5T<UU#;VYN96-T:6]N4F5A9" H<F5C=B@.I*2X-"@.T*4U%,(%-E<G9E<B!C
M;VYF:6=U<F%T:6]N(&9A:6QE9"X-"@.T*(R,C(R,C(R,C(R,C(R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C( R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(PT*#0HQ.#HP.3HS,R!0<F]C97-S($5X:70@.0V]D93H@.
M*"TQ*2 -"C$X.C$X.C(Y(%-E='5P(&9A:6QE9"!T;R!C;VYF:6=U<F4@.=&AE
M('-E<G9E<BX@.("!2969E<B!T;R!T:&4@.<V5R=F5R(&5R<F]R(&QO9W,@.86YD
M($,Z7%=)3DY47'-Q;'-T<"YL;V<@.9F]R(&UO<F4@.:6YF;W)M871I;VXN#0HQ
M.#HQ.#HR.2!!8W1I;VX@.0VQE86Y5<$EN<W1A;&PZ#0HQ.#HQ. #HR.2!#.EQ$
M3T-5345^,5Q!1$U)3DE^,5Q,3T-!3%-^,5Q496UP7%-Q;%-E='5P7$)I;EQS
M8VTN97AE(" M4VEL96YT(#$@.+4%C=&EO;B T("U397)V:6-E(%-13$%G96YT
M)$-34$PR2PT*,3@.Z,3@.Z,CD@.4')O8V5S<R!%>&ET($-O9&4Z("@.Q,#8P*2!4
M:&4@.<W!E8VEF:65D('-E<G9I8V4@.9&]E<R!N;W0@.97AI<W0@.87,@.86X@.:6YS
M=&%L;&5D('-E<G9I8V4N#0H-"C$X.C$X.C(Y($,Z7$1/0U5-17XQ7$%$34E.
M27XQ7$Q/0T%,4WXQ7%1E;7!<4W%L4V5T=7!<0FEN7'-C;2YE>&4@.("U3:6QE
M;G0@.,2 M06-T:6]N(#0@.+5-E<G9I8V4@.35-344PD0U-03#)+#0HQ.#HQ.#HR
M.2!0<F]C97-S($5X:70@.0V]D93H@.*# I( T*,3@.Z,3@.Z,CD@.4W1A='-'96YE
M<F%T92!R971U<FYE9#H@.,@.T*,3@.Z,3@.Z,CD@.4W1A='-'96YE<F%T92 H,'@.R
M,C<L,'@.Q+#!X9C P+#!X,S P+#$P,S,L,S S+#!X,"PP>#$L,"PP+# -"C$X
M.C$X.C(Y(%-T871S1V5N97)A=&4@.+3$L061M:6YI<W1R871O<BD-"C$X.C$X
:.C(Y($EN<W1A;&QA=&EO;B!&86EL960N#0H`
`
end
You have a TCP/IP alias established created on your computer. Remove it and
setup should complete successfully. Setup starts SQL Server in a mode to
accept only shared memory connections. The alias is preventing setup from
connecting.
Run cliconfg from Start - Run. Go to the ALias tab and delete the alias for
this server, You do not need it. Or should not need it. If you do then
there is another problem that needs to be addressed.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Rand!
You the man! I was about to have a heart attack when i had uninstalled
our SQL Developer server and could not install Standard edition. Your
suggestion worked like a charm! Your advice is excellent even 6 months
later.
Blackened
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message537287.html
Problem in installing SQLSERVER2000 Developer Edition
You have a TCP/IP alias established created on your computer. Remove it and
setup should complete successfully. Setup starts SQL Server in a mode to
accept only shared memory connections. The alias is preventing setup from
connecting.
Run cliconfg from Start - Run. Go to the ALias tab and delete the alias for
this server, You do not need it. Or should not need it. If you do then
there is another problem that needs to be addressed.
Rand
This posting is provided "as is" with no warranties and confers no rights.Rand!
You the man! I was about to have a heart attack when i had uninstalled our
SQL Developer server and could not install Standard edition. Your suggestio
n worked like a charm! Your advice is excellent even 6 months later.
setup should complete successfully. Setup starts SQL Server in a mode to
accept only shared memory connections. The alias is preventing setup from
connecting.
Run cliconfg from Start - Run. Go to the ALias tab and delete the alias for
this server, You do not need it. Or should not need it. If you do then
there is another problem that needs to be addressed.
Rand
This posting is provided "as is" with no warranties and confers no rights.Rand!
You the man! I was about to have a heart attack when i had uninstalled our
SQL Developer server and could not install Standard edition. Your suggestio
n worked like a charm! Your advice is excellent even 6 months later.
Problem in installing SQL2K SP3
HI
I'm installing SQL2K SP3 (new installation not upgrade) but I've this error
"Setup failed to configure the server. Refer to the server error logs and setup error logs for more information."
I don't know what's the error and I want to know where I can find the "server error log" or the "setup error log"Originally posted by mac07
HI
I'm installing SQL2K SP3 (new installation not upgrade) but I've this error
"Setup failed to configure the server. Refer to the server error logs and setup error logs for more information."
I don't know what's the error and I want to know where I can find the "server error log" or the "setup error log"
Check out the following files to see where the installation went wrong:
All in C:\Winnt\ folder
setpapi.log
dasetup.log
Hope this helpssql
I'm installing SQL2K SP3 (new installation not upgrade) but I've this error
"Setup failed to configure the server. Refer to the server error logs and setup error logs for more information."
I don't know what's the error and I want to know where I can find the "server error log" or the "setup error log"Originally posted by mac07
HI
I'm installing SQL2K SP3 (new installation not upgrade) but I've this error
"Setup failed to configure the server. Refer to the server error logs and setup error logs for more information."
I don't know what's the error and I want to know where I can find the "server error log" or the "setup error log"
Check out the following files to see where the installation went wrong:
All in C:\Winnt\ folder
setpapi.log
dasetup.log
Hope this helpssql
problem in Installing SQl Server Management studio express _ (ctp)
I'm very new to MS SQl Server, i Downloaded MS SQl Server express edition, the problem is i can't deal with it, when i downloaded (Microsoft SQL Server Management Studio Express - Community Technical Preview (CTP) November 2005) every time i try to install it , it give me error message says "The system administrator has set policies To Prevent this installation"
How can i over come this problem and install this interface to be able to deal with sql server?
is there any other software can do this job "making interface for the sql server express edition"?
ThxI downloaded the Nov CTP as well of the Management studio, but can't go beyond this error.
How can i over come this problem and install this interface to be able to deal with sql server?
is there any other software can do this job "making interface for the sql server express edition"?
ThxI downloaded the Nov CTP as well of the Management studio, but can't go beyond this error.
This installation package cannot be installed by the windows installer service. You must install a windows service pack that contains a newer version of the windows installer service.
I have Windows 2000 SP4 and also the Windows Installer 3.0, MSXML 6.0 Still 
Thanks in advance for any help.
Kalyan.|||Go to the following link an install the latest update to Windows Installer: http://www.microsoft.com/downloads/details.aspx?FamilyID=889482fc-5f56-4a38-b838-de776fd4138c&DisplayLang=en
Cheers,
Dan|||hi,
I have the windows installer 3.1 but yet i can't install (TCP) managment studio keep getting the same error "administrator has set policies to prevent this installation"
additional hint : - i use windows xp_sp2 - when i used to counter this problem i downloaded MS Visual Web developer express 2005 and i was able to connect to sql server, but really i'm new to sql and i need to see interface to be able to learn it at least|||Sorry for the messege, i downloaded the SQl Server Management Studio Express Again and when i tried to install it , it worked seems it was a problem in the first time i downloaded it something was wrong in it
anyway thx guys
Problem in Installing SQL Server Management Studio
Hi all, i have already installed Visual Studio 2005 Professional Addition, due to which the following components have been installed on my computer
Microsoft .NET Compact Framework 1.0 SP3 Developer
Microsoft Compact Framework 2.0
Microsoft .NET Framework 2.0
Microsoft Device Emulator version 1.0-ENU
Microsoft Document Explorer 2005
Microsoft SQL Server 2005
Microsoft SQL Server 2005 Mobile [ENU] Developers Tools
Microsoft SQL Server Native Client
Microsoft SQL Server Setup Support Files
Microsoft SQL Server VSS Writer
Microsoft Visual J# 2.0 Redistributable Package
Microsoft Visual Studio 2005 Professional Edition - ENU
MSDN Library for Visual Studio 2005
MSXML 6.0 Parser
My visual studio 2005 professional edition is working correctly, but now i want to install Microsoft SQL Server Management Studio. I have a CD on which i have following folders
1.SQL Kit and Reporting Services(this folder contains folowing setups,
SQLServer2005_SSMSEE,
SQLEXPR_ADV,
SQLEXPR_TOOLKit)
2.Database Publising Wizard 1.0 RC(this folder contains a setup named as Database Publising Wizard 1.0 RC)
3.Book folder contains a setup named as SqlServer2k5_BOL_june2006
My problem is that, i don't know in which sequence i have to run these setups, so that the management studio successfully insatlled on my computer. If anybody understands my problem, plz help.It looks like you have SQL 2005 Express Edition. To install the Express version of SSMS, run the setup or installer in SQLServer2005_SSMSEE .
|||You have solved my problem, thank you so much for replying.
Problem in Installing Sql Server 2005 Developer Edition
I tring to install SQL Server 2005 Developer Edition on Windows XP Pro but i not able to to so because of the following errors:-
Action "OpenPipeAction" failed during execution
Action "CreatePipeAction" failed during execution.
MsiOpenDatabase failed with 87
MsiOpenDatabase failed with 87 for MSI
Action "InstallDTSAction.9" failed during execution. Error information reported during run:
Action: "InstallDTSAction.9" will be marked as failed due to the following condition:
Condition "Package "9" either passed when it was last installed, or it has not been executed yet" returned false. Condition context:
Prereq package will be failed due to the previous installation attempt returning: 1605
Can Anyone help me out on this?
Thanks
VG
It seems that there are 2 versions of MSXML6 running on my machine using add remove programs was useless. If you use Windows Intall Clean Up tool to remove all traces of MSXML6 then reintall SQL SERVER it should work.
I think this is the link i used to download the tool.
http://www.softpedia.com/get/Security/Secure-cleaning/Windows-Installer-CleanUp-Utility.shtmlProblem in installing SQL Server 2005 (Beta version is not getting uninstalled)
Hi All,
I had installed a beta version of SQL Server (SQL Server 2005 CTP) and now I want to install a full version of SQL Server 2005 Developer Edition on my machine. I have properly uninstalled all the CTP componenets from Add-Remove programs and even deleted the registry data of that installation. I have also removed the related folders from the hard drive.
When I run the setup of the full version it says that setup has detected the beta versions of either .Net Framework, Visual Studio or SQl Server. Remove the beta components using Add-Remove programs and try again. Can anyone help me out of this problem?
Regards,
Sachin
hope this will help u.
http://geekswithblogs.net/mattrobertsblog/archive/2005/11/06/59246.aspx
Madhu
Problem in Installing SQL Server 2000 Personal
Hi... I recently reformatted my pc due to a very slow operation. Then I reinstall SQL Server 2000 Personal to my PC running Windows XP OS....As I run the setup, it will display INTERNAL ERROR and won't continue... What seemed to be the problem there? Before I reformatted the PC, it was installed well...
In windows XP I think you can only install Client tools ! ! ! anything from the setup log ?|||Deepak... you can install Personal Edition on XP as well.. the problem seems to be something else... check error log or post the exact error what u get
BTW why u want to install 2000 , you have SQL Server 2005 Express downloadable edition. I think u should install that...
http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx
http://www.databasejournal.com/features/mssql/article.php/1442281
Madhu
|||Madhu, Thanks for pointing out my mistake.......apologize for my ignorance|||No Deepak... we all make mistake... we all are there for a common cause to its help each other and there by improve our knowledge... so pse do not take it as personal...
Madhu
|||Madhu, I didnt take it personnally.I am indeed happy that you pointed out my mistake 
so that i can learn from my mistakes.......i just felt like apologising for providing a wrong information........thanks once again friend
Hi...Thanks for your immediate replies...Madhu the exact error displays
"Internal Error. Contact Microsoft Technical Support."
I already have SQL Server 2005 Express installed and it does not allow connections to other pc...
I have found out about SQL Management Studio and used it instead....And it really has a good environment...
Thank for replying here.... Happy programming!
Problem in installing SQL express
If you know how to fix my problem , pls let me know. I am trying to install SQL express version with XP SP2 . iIt stops at the screen of "Detecting Installed IIS" . I have tried the same installation in server 2003. It is ok.
I too have the exact same problem. I've got a case logged into MS support and I'll post back whenever they get around to returning my call.|||OK - I resolved the problem on two identicial clean machines, but we were not sure what exactly resolved the problem. First off, I have two, out-of-the-box Dell 9150s and both came with a Norton Internet Security installed with 'Personnal Firwewall' turned ON. I turned the firewall off and also installed the service packs listed below and I was able to install SQL Express without issue on both machines.
I hope this helps.
Security Update for Windows XP (KB890859)
- Update for Windows XP (KB894391)
- Security Update for Windows XP (KB896428)
- Security Update for Windows XP (KB905749)
- Security Update for Windows XP (KB904706)
- Security Update for Microsoft .NET Framework, Version 1.1 Service Pack 1 (KB886903)
- Critical Update for Windows XP (KB886185)
- Security Update for Windows XP (KB900725)
- Security Update for Windows XP (KB888302)
- Security Update for Windows XP (KB905414)
- Security Update for Windows XP (KB899589)
- Security Update for Windows XP (KB893066)
- Cumulative Security Update for Internet Explorer for Windows XP (KB896688)
- Security Update for Windows XP (KB890046)
- Security Update for Windows XP (KB902400)
- Security Update for Microsoft Windows (KB898458)
- Security Update for Windows XP (KB896358)
- Update for Windows XP (KB887742)
- Security Update for Windows XP (KB896423)
- Security Update for Windows XP (KB893756)
- Security Update for Windows XP (KB896424)
I was having the same problem with the install haning up at the IIS detection on my laptop. I didn't have any problem installing it on my desktop. Both machines are running XP Home. The difference is the desktop has ZoneAlarms as a firewall, while the laptop is running the Norton firewall.
I couldn't install on the laptop either from the download or from a SQL Server Standard Edition CD. They both stopped at the IIS detection.
I turned off the Norton firewall, downloaded the install to my desktop, ran it from there and it installed very quickly.
Problem in Installing Microsoft SQL Server Management Studio Express - Community Technology Prev
Hi,
I installed SQL Server Express Edition and trying to install Management Studio Express but not successful.
Following Error is thrown while installing MSSMSE.
"The Installation Package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer Package"
I downloaded the software from http://www.microsoft.com/downloads/details.aspx?FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en
Please help me. I am struck.
Shyam
This sounds like a problem with the download. Try turning off anti-virus protection when you do the download. Also, make sure you save the download to a drive that is not near capacity.
Problem in Installing 64-bit Reporting Services
Hi,
Trying to install 64-bit SQL Server 2005 RTM on Windows 2003 x64 Server with SP 1. The Reporting services option is not enabled in the installation steps. The installation process gets completed, but the Reporting Services is not installed.
The server does have IIS installed, the .NET framework 2.0 is installed by SQL Server 2005 RTM itself. Am I doing anything wrong.
Can anyone help/suggest ?
Thanks in advance.
Setup should show error message in case of error.
Also, you can check setup log files in %ProgramFiles%\Microsoft SQL Server\90\Setup BootStrap\LOG\Files
|||Unfortunately, the setup doesnt show any error. The Reporting Services option is not "enabled" during the installation steps.
Can anyone suggest any other forum, where installation issues are discussed.
Thanks in advance.
|||Rajeeb,
We have tested RS successfully on many x64 machines, so it is definitely possible! If RS is not selectable during setup, it is because some prereq is not met. Please look carefully at the System Configuration Check screen for anything that is not "green". It is possible for IIS to be installed, but not in a configuration that allows RS to be installed.
|||Please verify that IIS is installed before installing SQL Reporting Services. IIS is a required for Reporting Services.Problem in inserting value in view
Hi There,
i have created one view on an exsisting table, but when i am inserting value in it, it is giving the following error msg:
Derived table 'View Name' is not updatable because a column of the derived table is derived or constant.
Thanx
Is this related to SSIS? Well the error is coming straight from SQL Server itself, and is fairly clear to me.
You cannot update a column that is not really a column. So what columns are being updated and can you honestly say they are unadulterated columns, and have not been derived or manipulated in any way before being returned from the view.?
If you want a specific answer then post the UPDATE statement and a the DDL (CREATE VIEW...) for the view.
problem in inserting date in sql server 7 through insert query
hello myself avinash
i am developing on application having vb 6 as front end and sql server 7
as back end.
when i use insert query to insert data in table then the date value of
that query is going as 01/01/1900
my query is as follows
i am developing on application having vb 6 as front end and sql server 7
as back end.
when i use insert query to insert data in table then the date value of
that query is going as 01/01/1900
my query is as follows
StrSql = "Insert Into
SalesVoucher(TransactionID,VoucherNo,VoucherDate,D ebitTo,CreditTo,TotalAmt,Discount,ModAmt,ModWt,Oth er,Othertype,TaxPerc,TaxAmt,NetAmt,Advance,Narrati on,Haste)"
StrSql = StrSql & " Values(" & txtTransactionID.text & "," &
txtChallanno.text & ",'" & Format(txtChallanDate.Value, "dd/mm/yyyy") &
"'," & AccCode & ",'" & IIf((Category = "Gold"), 36, 38) & "',"
StrSql = StrSql & vsAmountDesc.ValueMatrix(RowAmountArr(0),
2)
& "," & vsAmountDesc.ValueMatrix(RowAmountArr(2), 2) & "," &
val(txtModTotal.caption) & "," & val(TxtModWt.caption) & ","
StrSql = StrSql & vsAmountDesc.ValueMatrix(RowAmountArr(1),
2)
& ",'" & vsAmountDesc.TextMatrix(RowAmountArr(1), 1) & "','" &
vsAmountDesc.TextMatrix(RowAmountArr(4), 1) & "'," &
vsAmountDesc.ValueMatrix(RowAmountArr(4), 2) & ","
StrSql = StrSql & vsAmountDesc.ValueMatrix(RowAmountArr(3),
2)
+ val(txtModTotal.caption) & "," & val(txtAdvance.text) & ",'-'," &
IIf(Trim(txtHaste.text) <> "", RetriveAccountCode(Trim(txtHaste.text)),
0)
& ")"
and its output is
Insert Into
SalesVoucher(TransactionID,VoucherNo,VoucherDate,D ebitTo,CreditTo,TotalAmt,Discount,ModAmt,ModWt,Oth er,Othertype,TaxPerc,TaxAmt,NetAmt,Advance,Narrati on,Haste)
Values(18,1831,'07/04/2004',150,'36',11000,0,0,0,-10,'','1.00',109.9,11100,0,'-',0)
in above query though i used cdate to voucherdate value still it save in
database as 01/01/1900 though here it shows right date
plz help me its a very big issue for me & i really just fed of this
problemYou might try running a Profiler trace to capture the actual statement
executed by SQL Server and check for any triggers that might change the
value. Note that SQL Server will interpret an empty string as 1900-01-01.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"avinash" <pawar_avinash@.rediffmail.com> wrote in message
news:9c11bb7aacaeeddcf230738468fd3b72@.localhost.ta lkaboutdatabases.com...
> hello myself avinash
> i am developing on application having vb 6 as front end and sql server 7
> as back end.
> when i use insert query to insert data in table then the date value of
> that query is going as 01/01/1900
> my query is as follows
> StrSql = "Insert Into
> SalesVoucher(TransactionID,VoucherNo,VoucherDate,D ebitTo,CreditTo,TotalAmt,Discount,ModAmt,ModWt,Oth er,Othertype,TaxPerc,TaxAmt,NetAmt,Advance,Narrati on,Haste)"
> StrSql = StrSql & " Values(" & txtTransactionID.text & "," &
> txtChallanno.text & ",'" & Format(txtChallanDate.Value, "dd/mm/yyyy") &
> "'," & AccCode & ",'" & IIf((Category = "Gold"), 36, 38) & "',"
> StrSql = StrSql & vsAmountDesc.ValueMatrix(RowAmountArr(0),
> 2)
> & "," & vsAmountDesc.ValueMatrix(RowAmountArr(2), 2) & "," &
> val(txtModTotal.caption) & "," & val(TxtModWt.caption) & ","
> StrSql = StrSql & vsAmountDesc.ValueMatrix(RowAmountArr(1),
> 2)
> & ",'" & vsAmountDesc.TextMatrix(RowAmountArr(1), 1) & "','" &
> vsAmountDesc.TextMatrix(RowAmountArr(4), 1) & "'," &
> vsAmountDesc.ValueMatrix(RowAmountArr(4), 2) & ","
> StrSql = StrSql & vsAmountDesc.ValueMatrix(RowAmountArr(3),
> 2)
> + val(txtModTotal.caption) & "," & val(txtAdvance.text) & ",'-'," &
> IIf(Trim(txtHaste.text) <> "", RetriveAccountCode(Trim(txtHaste.text)),
> 0)
> & ")"
> and its output is
> Insert Into
> SalesVoucher(TransactionID,VoucherNo,VoucherDate,D ebitTo,CreditTo,TotalAmt,Discount,ModAmt,ModWt,Oth er,Othertype,TaxPerc,TaxAmt,NetAmt,Advance,Narrati on,Haste)
> Values(18,1831,'07/04/2004',150,'36',11000,0,0,0,-10,'','1.00',109.9,11100,0,'-',0)
> in above query though i used cdate to voucherdate value still it save in
> database as 01/01/1900 though here it shows right date
> plz help me its a very big issue for me & i really just fed of this
> problem|||hi avinash
i have come across such problems frequently. i would advise u
to set the date format within dtpicker control u are using. Check
properties for the control and set the format to custom. then set the
mask.
thats it.
Regards
Debashishsql
Problem in inserting binary data in sql;
Hi,
I am facing problem inserting binary data into sql data type varbinary.
I want to save an object data type in var binary data type into sql.It gives a followin error.
The name 'DocumentData' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
I do not use ASP Upload file.
Any type of help .
Thanks in advance
Friend
Hello my friend,
The variable is not being passed to the SQL correctly. For example: -
INSERT INTO tblCountry (CountryName) VALUES ('Italy') - this is fine
INSERT INTO tblCountry (CountryName) VALUES (Italy) - not right because single quotes are missing. However, SQL thinks I am referring to a column name when I say Italy. Check your SQL.
Kind regards
Scotty
|||
Hi,
Thanks for your reply.Follwoing is my code plz review and help me if i am making any mistake.
query =
"Insert into Documents(DocumentID,DocumentName,DocumentData,DocumentType,FileID,Field1,Field2,Field3,Field4)values (@.DocumentID,@.DocumentName,DocumentData,DocumentType,FileID,Field1,Field2,Field3,Field4,)";sc.Parameters.Add(
"@.DocumentID",SqlDbType.Int, 10);sc.Parameters.Add(
"@.DocumentName",SqlDbType.VarChar, 15);sc.Parameters.Add(
"@.DocumentData",SqlDbType.Binary, 15);sc.Parameters.Add(
"@.DocumentType",SqlDbType.VarChar, 10);sc.Parameters.Add(
"@.FileID",SqlDbType.Int, 10);sc.Parameters.Add(
"@.Field1",SqlDbType.VarChar, 15);sc.Parameters.Add(
"@.Field2",SqlDbType.VarChar, 15);sc.Parameters.Add(
"@.Field3",SqlDbType.VarChar, 15);sc.Parameters.Add(
"@.Field4",SqlDbType.VarChar, 15);
sc.Parameters[
"@.DocumentID"].Value = documentid;sc.Parameters[
"@.DocumentName"].Value = docname;sc.Parameters[
"@.documentData"].Value=fileimg;sc.Parameters[
"@.documentType"].Value = doctype;sc.Parameters[
"@.FileId"].Value = fileid;sc.Parameters[
"@.Field1"].Value = f1;sc.Parameters[
"@.Field2"].Value = f2;sc.Parameters[
"@.Field3"].Value = f3;sc.Parameters[
"@.Field4"].Value = f4;sc.CommandText = query;
sc.ExecuteNonQuery();
|||Hello again my friend,
I see it now. You are missing the @. symbols within the insert statement at the top of your code for every parameter after @.DocumentName. Besides this, have a space between ) and values. Also, you need to take out the comma after Field4 at the end of the values group so it ends in a bracket, not a comma with a bracket. I amend it as follows: -
query ="Insert into Documents (DocumentID,DocumentName,DocumentData,DocumentType,FileID,Field1,Field2,Field3,Field4) values (@.DocumentID,@.DocumentName, @.DocumentData, @.DocumentType, @.FileID, @.Field1, @.Field2, @.Field3, @.Field4)";
Kind regards
Scotty
|||
Hi,
Thanks, thank you very much..
Best Regards,
Adnan
problem in inserting an integer into a database table
i am using visual web developer 2005 and SQL Express 2005 with VB as the code behind
i want to insert an integer into my database table and this is my code
i = i + 1
productionstatus.UpdateCommand = "UPDATE productionprogressbar SET completedprocess = i WHERE order_id = 10"
productionstatus.Update()
"i" is declared at the top of the page like this
Partial Class production_processlist
Inherits System.Web.UI.Page
Dim i As Integer = 0
when i run the program i get the error
input string is not in the correct format
what is wrong in my code ?
please help me
you are treating your variable "i" as a literal character
try it like this:
"UPDATE productionprogressbar SET completedprocess =" & i.ToString & "WHERE order_id = 10"
problem in inserting a record whose values are of date and time format.
hello,
I am trying to insert date and time into my table.
insert into <table_name> values('12/12/2006','12:23:04');
but it displays error at " ; "
can anyone help me to figure out the problem
Thanks a lot in advance.
Regards,
Sweety
What happens if you remove ";"?
|||hi,
thx for responding..i figured out the problem and i solved it..
bye
Sweety
Problem in Insert in Table
Dear Friends
I have a table Which is giving problem for the Insert.
Insert ERROR:
Column Name or number of supplied values does not match table Definations
The same table is in replication. I have updated our Servicepack to 4 in
last w
.
Please suggest how i can solve the problem.
Thanks and best regards
ShaileshYou have given less number of columns but included values for all the
columns
Post the query you used
Madhivanan|||hi sailesh
there might be difference between the columns and values passed in the
insert query..
eg:
INSERT INTO <TABLE>(ID, Name) VALUES (1, 'Chandra', 28)
please post the query so that we can give a better solution
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***
I have a table Which is giving problem for the Insert.
Insert ERROR:
Column Name or number of supplied values does not match table Definations
The same table is in replication. I have updated our Servicepack to 4 in
last w
.Please suggest how i can solve the problem.
Thanks and best regards
ShaileshYou have given less number of columns but included values for all the
columns
Post the query you used
Madhivanan|||hi sailesh
there might be difference between the columns and values passed in the
insert query..
eg:
INSERT INTO <TABLE>(ID, Name) VALUES (1, 'Chandra', 28)
please post the query so that we can give a better solution
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***
Problem in insert a datetime into SqlServer 2005
I user Visual Studio 2005 64 bit ,windowxp 64 bit ,sqlserver 2005
The Sql statement : "insert into sickleave (StaffID,sickLeaveReason,DateStart,DateEnd,RegistrationDate) values (20001,'test',28/3/2006,4/5/2006,4/5/2006 ) "
and the result in Datebase (All the time become 1/1/1900 0:00:00 )
Although i change the datetype from datetime to smalldatetime the result is same
and i try input the date 28/3/2006 0:00:00 into server but
it show the error:Incorrect syntax near '0'.
What wrong ? help me please,Thank.
They have to be passed as strings:
insert into sickleave (StaffID,sickLeaveReason,DateStart,DateEnd,RegistrationDate) values (20001,'test','3/28/2006','5/4/2006','5/4/2006' ) "
or as ISO values which is preferable
insert into sickleave (StaffID,sickLeaveReason,DateStart,DateEnd,RegistrationDate) values (20001,'test',20060328,20060405,20060405 ) "
HTH, jens Suessmeyer.
Your date is in the future (28th of March this year). That is not allowed:
Server: Msg 242, Level 16, State 3, Line 4
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Server: Msg 296, Level 16, State 3, Line 5
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
HTH
|||I prefer to use dates in the following format 'yyyy-mm-dd'.
Have you tried that already (as mentioned above)?
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||@.Original Poster: Could you please track the status of the post ? Thanks.
-Jens
sqlProblem in Insert
Dear Friends,
I am having one table which is giving problem while inserting the records
which is as follows:oops! u missed to explain ut problem
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***
I am having one table which is giving problem while inserting the records
which is as follows:oops! u missed to explain ut problem
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***
Problem in inner join ?
Hai ,
select emp_id,count(emp_id) as count1 from poll_data group by emp_id order by count1 desc
The output of above query is
emp_id count1
EMP10041 8
EMP10058 8
EMP10059 6
EMP10008 6
EMP10012 3
EMP10018 3
EMP10039 3
EMP10001 2
I have another table as user_table
user_id user_name
EMP10001 Raja
EMP10039 Ram
EMP10018 Ravi
etc
now i am writing a inner join as follows
select y.user_name, x.count1 from [select emp_id,count(emp_id) as count1 from poll_data group by emp_id order by count1 desc] x inner join [user_table] y on x.emp_id = y.user_id
I want to get the below format
Jambu 8
Elangovan 8
Ravi 6
Anitha 6
Ram 3
but i am getting the below error :
Invalid object name 'select emp_id,count(emp_id) as count1 from poll_data group by emp_id order by count1 desc
how to solve this
remove the [ ] & order by clasue on the sub query. Sub query should be enclosed with ( ).
Code Snippet
select
y.user_name
, x.count1
from
(select emp_id,count(emp_id) as count1 from poll_data group by emp_id) x
inner join [user_table] y on x.emp_id = y.user_id
|||You need to enclose the derived table in parentheses -NOT square brackets.
Code Snippet
SELECT
u.User_Name,
p.Count1
FROM (SELECT
Emp_ID,
Count1 = count(Emp_ID)
FROM Poll_Data
GROUP BY Emp_ID
) p
INNER JOIN User_Table u
ON p.Emp_ID = u.User_ID
problem in inner join
Hey,
I want to update the price in the items table to be equal to the corrosponding price in the books table but my problem is in the "on stmt", i cant set items.id=books.id because in the items table the id is saved as nvarcharex:b1234 where b identifies a book and in the books table it is saved as int as follows 1234 and this is the only primary key ! so how can i solve it and how can i write the query to update the price in the items table??
Thank you
Hiba
You can try to use some string functions to do so. Fo r example you can try RIGHT(items.id,4)=books.id if both ids' column is nvarchar column. Or
SUBSTRING( items.id, 2,LEN( items.id))=CONVERT(NVARCHAR,books.id)) if the books id is not nvarchar.
|||Actually you can use RIGHT or SUBSTRING to get you data like RIGHT(book,4) if you are sure that your ID will be no longer then 4 digits or
if you know that you will always have 1 character to identify book you can use syntax like
where items.ID= LEFT(items.ID,1)+books.id
actually it is the same like using
where items.ID= SUBSTRING(items.ID,0,1)+books.id
Because Left just call substring to do its work.
Thanks
JPazgier
|||hi.
are u familiar with adobc?
how can i use dataadapter using adobc?
my code is:
Dim sqldataadapter As New SqlClient.SqlDataAdapter(stringQuery, MyConn)
Dim ds As New DataSet()
Dim foundrow, temprow As DataRow
Dim ds2 As New DataSet
Dim temp_data_table As New DataTable
sqldataadapter.Fill(ds, "TT0001")
Dim sqldataadapter2 As New SqlClient.SqlDataAdapter(stringQuery2, MyConn)
sqldataadapter2.Fill(ds2, "tempo_db")
Dim date_ctr As Integer
but it doesnt accept sqlClient....what can u suggest?
|||Hey, Anyways thank you but I sloved it in this way:
update
itemsset
items.weight=books.weight,items.profit=books.profit,items.alldiscount=books.alldiscountfrom
(booksjoin itemson'b'+cast(books.idAsnvarchar(12))=items.id)where
items.center='lb'and items.ordernum>47000Thanx
Hiba
Problem in Importing Excel data into MS SQL 2000
Hi all,
I want to import MS Excel data into MS SQL 2000 and I am programming this in VB 6.0. I am referring the article http://support.microsoft.com/kb/316934/EN-US/ for this. I can able to import Excel data successfully into SQL database table. But the problem is, the order of exported data in SQL table is not matching that of MS Excel data. All the rows were jumbled, which made it totally unusable.
Please guide me how to Import Excel data into MS SQL in its original order only. Any other method other than what I am following is present; please suggest me to keep the original order.
Regards,
Rajeev Vandakar
Bangalore
As long as the data is correct on each row, there is no way to 'guarantee' that SQL Server will store data in any particular order -UNLESS there is a CLUSTERED index on the table, and if so, the data will be stored in the index order.
Otherwise, with SQL Server, we do NOT concern ourselves with the order of data storage, we use ORDER BY in our queries to cause the resultset to be in the order desired.
I suspect you may have a PRIMARY KEY with a CLUSTERED Index, and that is why it 'appears' that your data is being jumbled.
Check in Books Online about how to use the ORDER BY clause in your queries to un-jumble your data.
|||Thank you Arnie Rowland for reply.
I can use ORDER BY clause in MS SQL after importing data. But this will not solve my problem here. Because the way data is present in Excel. In Excel some 12 colums present. Rows were organised in sections and to indicate start of a section 3rd colummn (meant for person name) have section name and remaining columns were left blank. So after importing into SQL, if I use ORDER BY clause, these rows, meant for sectin name will come in the top! If Excel data moves to SQL in as-it-is, same order, my problem will be solved. How to do this?
Regards,
Rajeev Vandakar
|||As I indicated before, SQL Server (in fact the SQL language specification), clearly states that there is no guarantee about the order that data is stored in a table.
If you MUST load the table with data in a particular order, I suggest that you might wish to add a column to the Excel file, fill that column with some indicator of row order, and add a clustered index (or primary key) to the SQL table using that column.
Then the data will be ordered as you desire.
Without some way to place the rows in a particular order, SQL Server does not care, does not enforce order, and does not produce reliably ordered data.
sqlProblem in importing data from excel to sql2005
Hi
I have to import data from a number of excel files to corresponding tables in SQL 2005. The excel files are created using excel 4.0. I have created an excel connection manager and provided it with the path of the excel sheet.Next i have added an excel source from the toolbox to the dataflow. I have set the connection manger, data access mode, and the name of the excel sheet (the wizard detects the sheet correctly) in the dialog window i get when i double click the excel source. Every thing goes fine till here. Now when i select the 'columns' in this dialog window or the preview button, i get this error
I have to import data from a number of excel files to corresponding tables in SQL 2005. The excel files are created using excel 4.0. I have created an excel connection manager and provided it with the path of the excel sheet.Next i have added an excel source from the toolbox to the dataflow. I have set the connection manger, data access mode, and the name of the excel sheet (the wizard detects the sheet correctly) in the dialog window i get when i double click the excel source. Every thing goes fine till here. Now when i select the 'columns' in this dialog window or the preview button, i get this error
TITLE: Microsoft Visual Studio
Error at Data Flow Task [Excel Source [1]]: An OLE DB error has occurred. Error code: 0x80004005.
Error at Data Flow Task [Excel Source [1]]: Opening a rowset for "test4$" failed. Check that the object exists in the database.
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
Any ideas about why is this happening?
UmerDid you specify the Excel 4.0 as the version in the connection manager?|||yes i have specified the version 4.0 in the connection manager
Problem in Importing data from excel to sql server
I have excel file that has field named Purpose. Its max length is 400 character. I import this file to sql server database table. And also i change the purpose field in sql server database table with nvarchar 400. But when i run this job, it gave me error message:
Error at source for row number 1215. Errors encountereed so far in this task: 1.
Data for source column 18 ('Purpose') is too large for the specified buffer size.
What should i do so that i still can import the data from excel to sql server database?
Thanks for your help.I have far fewer problems when I take spreadsheets and put them in Access and then import them into sql server from access than I do just importing from excel.
Error at source for row number 1215. Errors encountereed so far in this task: 1.
Data for source column 18 ('Purpose') is too large for the specified buffer size.
What should i do so that i still can import the data from excel to sql server database?
Thanks for your help.I have far fewer problems when I take spreadsheets and put them in Access and then import them into sql server from access than I do just importing from excel.
Problem in IDENTITY COLUMNS
Hi folks! I've a merge replication setup b/w two servers.
Published tables have columns (INT IDENTITY SEED 1 INCREMENT[NOT FOR REPLICATION]).
Whenever i apply the SNAPSHOT, i have to run DBCC CHECKIDENT('table' RESEED) for each table at the subscriber twice, for the values in the columns are almost always greater than the ID-Seed value. For example the last Identity value in the column is 999 but whenever i insert a new row; i get error; couldn't insert duplicate value into the table. When i run the dbcc check i see the following message:
"Checking identity information: current identity value '1', current column value '999'."
How do i square this away?Originally posted by TALAT
Hi folks! I've a merge replication setup b/w two servers.
Published tables have columns (INT IDENTITY SEED 1 INCREMENT[NOT FOR REPLICATION]).
Whenever i apply the SNAPSHOT, i have to run DBCC CHECKIDENT('table' RESEED) for each table at the subscriber twice, for the values in the columns are almost always greater than the ID-Seed value. For example the last Identity value in the column is 999 but whenever i insert a new row; i get error; couldn't insert duplicate value into the table. When i run the dbcc check i see the following message:
"Checking identity information: current identity value '1', current column value '999'."
How do i square this away?
You will have to find the max value and do something like this.
DBCC CHECKIDENT('table',RESEED,@.max_value)|||Howdy!
Running: DBCC CHECKIDENT('table', RESEED). when i run it second time for the table; the identity value gets normal, i.e. it gets the same as the last value in the column. But it's rather painful to run it for each table. I never had this problem at the publisher it's only at the subscriber. Is there a permanent solution?
Thanx for the reply.
Published tables have columns (INT IDENTITY SEED 1 INCREMENT[NOT FOR REPLICATION]).
Whenever i apply the SNAPSHOT, i have to run DBCC CHECKIDENT('table' RESEED) for each table at the subscriber twice, for the values in the columns are almost always greater than the ID-Seed value. For example the last Identity value in the column is 999 but whenever i insert a new row; i get error; couldn't insert duplicate value into the table. When i run the dbcc check i see the following message:
"Checking identity information: current identity value '1', current column value '999'."
How do i square this away?Originally posted by TALAT
Hi folks! I've a merge replication setup b/w two servers.
Published tables have columns (INT IDENTITY SEED 1 INCREMENT[NOT FOR REPLICATION]).
Whenever i apply the SNAPSHOT, i have to run DBCC CHECKIDENT('table' RESEED) for each table at the subscriber twice, for the values in the columns are almost always greater than the ID-Seed value. For example the last Identity value in the column is 999 but whenever i insert a new row; i get error; couldn't insert duplicate value into the table. When i run the dbcc check i see the following message:
"Checking identity information: current identity value '1', current column value '999'."
How do i square this away?
You will have to find the max value and do something like this.
DBCC CHECKIDENT('table',RESEED,@.max_value)|||Howdy!
Running: DBCC CHECKIDENT('table', RESEED). when i run it second time for the table; the identity value gets normal, i.e. it gets the same as the last value in the column. But it's rather painful to run it for each table. I never had this problem at the publisher it's only at the subscriber. Is there a permanent solution?
Thanx for the reply.
Subscribe to:
Posts (Atom)