GOTO problem

I get the following error when I try and use a GOTO statment with my abel at the bottom of the script:

[[A GOTO statement references the label 'ENDSCRIPT' but the label has not been declared.]]

My code structure is as follows:

Some code here

SET NOCOUNT OFF

SELECT * FROM PERSON_STAGE1 WHERE PERSONUID
IN (SELECT PERSONUID FROM PRO_SING_QA_26923_AMMAR..PERSONUID)

IF @.@.ROWCOUNT > 1
BEGIN
PRINT '*** ERROR: SCRIPT ENDING BECAUSE OF DUPLICATE UID'
GOTO ENDSCRIPT
END

SET NOCOUNT ON

.
.
.
.
.
ENDSCRIPT:

when I execute my code I get the error message mentioned above. Any suggestions?

Thanks in advance.hi,

your script (as much as you have posted) works fine in my enviroment !

markus

Good references

Can any one Suggest some good books on Data Warehouse
(Begner to Expert Level)
Thanks
Sai
For me, The Data Warehouse Toolkit was a great place to start. It's by
Ralph Kimball (and Margy Ross).
"Sai" <anonymous@.discussions.microsoft.com> wrote in message
news:1460501c444ed$dce7c050$a601280a@.phx.gbl...
> Can any one Suggest some good books on Data Warehouse
> (Begner to Expert Level)
> Thanks
> Sai
|||Thank you very much,I will try that
>--Original Message--
>For me, The Data Warehouse Toolkit was a great place to
start. It's by
>Ralph Kimball (and Margy Ross).
>
>"Sai" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1460501c444ed$dce7c050$a601280a@.phx.gbl...
>
>.
>
|||That one is absolutelly great from the modeling point of view. But if u are
interested int he project, and arquitecture of a DW implementation, do not
miss his second book. the datawarehouse LIFECYCLE toolkit. (three times
bigger, six times more valuable ;))
ALEJANDRO LEGUIZAMO
MVP SQL - Colombia
"Sai" <anonymous@.discussions.microsoft.com> wrote in message
news:149e201c444f1$ff84b1f0$a501280a@.phx.gbl...[vbcol=seagreen]
> Thank you very much,I will try that
> start. It's by
> message
|||Dear ALEJANDRO
Thank you so much for your Valuable
suggestions,I myself was puzzled ,when i looked in Amazon
about his second book,Now Your suggestions makes me clear
about the 2end books,Thank you very much again for you
help,I will get that one too
Sai
>--Original Message--
>That one is absolutelly great from the modeling point of
view. But if u are
>interested int he project, and arquitecture of a DW
implementation, do not
>miss his second book. the datawarehouse LIFECYCLE
toolkit. (three times
>bigger, six times more valuable ;))
>--
>ALEJANDRO LEGUIZAMO
>MVP SQL - Colombia
>
>"Sai" <anonymous@.discussions.microsoft.com> wrote in
message
>news:149e201c444f1$ff84b1f0$a501280a@.phx.gbl...
>
>.
>
|||You welcome!!! Here we are always trying to help anyone in anything (even
when the only thing i just have an idea is SQL Server ;)))
ALEJANDRO LEGUIZAMO
MVP SQL - Colombia
"Sai" <anonymous@.discussions.microsoft.com> wrote in message
news:14f6c01c445ff$035585d0$a401280a@.phx.gbl...[vbcol=seagreen]
> Dear ALEJANDRO
> Thank you so much for your Valuable
> suggestions,I myself was puzzled ,when i looked in Amazon
> about his second book,Now Your suggestions makes me clear
> about the 2end books,Thank you very much again for you
> help,I will get that one too
> Sai
> view. But if u are
> implementation, do not
> toolkit. (three times
> message

Good references

Can any one Suggest some good books on Data Warehouse
(Begner to Expert Level)
Thanks
SaiFor me, The Data Warehouse Toolkit was a great place to start. It's by
Ralph Kimball (and Margy Ross).
"Sai" <anonymous@.discussions.microsoft.com> wrote in message
news:1460501c444ed$dce7c050$a601280a@.phx
.gbl...
> Can any one Suggest some good books on Data Warehouse
> (Begner to Expert Level)
> Thanks
> Sai|||Thank you very much,I will try that
>--Original Message--
>For me, The Data Warehouse Toolkit was a great place to
start. It's by
>Ralph Kimball (and Margy Ross).
>
>"Sai" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1460501c444ed$dce7c050$a601280a@.phx
.gbl...
>
>.
>|||That one is absolutelly great from the modeling point of view. But if u are
interested int he project, and arquitecture of a DW implementation, do not
miss his second book. the datawarehouse LIFECYCLE toolkit. (three times
bigger, six times more valuable ;))
ALEJANDRO LEGUIZAMO
MVP SQL - Colombia
"Sai" <anonymous@.discussions.microsoft.com> wrote in message
news:149e201c444f1$ff84b1f0$a501280a@.phx
.gbl...[vbcol=seagreen]
> Thank you very much,I will try that
> start. It's by
> message|||Dear ALEJANDRO
Thank you so much for your Valuable
suggestions,I myself was puzzled ,when i looked in Amazon
about his second book,Now Your suggestions makes me clear
about the 2end books,Thank you very much again for you
help,I will get that one too
Sai
>--Original Message--
>That one is absolutelly great from the modeling point of
view. But if u are
>interested int he project, and arquitecture of a DW
implementation, do not
>miss his second book. the datawarehouse LIFECYCLE
toolkit. (three times
>bigger, six times more valuable ;))
>--
>ALEJANDRO LEGUIZAMO
>MVP SQL - Colombia
>
>"Sai" <anonymous@.discussions.microsoft.com> wrote in
message
> news:149e201c444f1$ff84b1f0$a501280a@.phx
.gbl...
>
>.
>|||You welcome!!! Here we are always trying to help anyone in anything (even
when the only thing i just have an idea is SQL Server ;)))
ALEJANDRO LEGUIZAMO
MVP SQL - Colombia
"Sai" <anonymous@.discussions.microsoft.com> wrote in message
news:14f6c01c445ff$035585d0$a401280a@.phx
.gbl...[vbcol=seagreen]
> Dear ALEJANDRO
> Thank you so much for your Valuable
> suggestions,I myself was puzzled ,when i looked in Amazon
> about his second book,Now Your suggestions makes me clear
> about the 2end books,Thank you very much again for you
> help,I will get that one too
> Sai
> view. But if u are
> implementation, do not
> toolkit. (three times
> message