Syntax correction, pl help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Syntax correction, pl help

Author

Topic

netvinny
Starting Member

3 Posts

Posted - 2001-05-21 : 16:27:26

Can anybody point out the syntax error in the following code, Please help

Create procedure wintest
@ObjectId Int
As
Declare @TempOTID Int
Select Distinct

Objects.ObjectID,
Objects.ObjectParentID,
Objects.OTID,
Objects.ObjectName,
Objects.Version,
Objects.Locked,
Objecttypes.OTID,
Objecttypes.OTName,
Properties.PropertyValue,
OTProperties.OTPropertyName,
OTProperties.OTPropertyType,
OTProperties.OTPropertyFrequency,
ChildParentOT.ChildOTID
From
Objects,
Objecttypes,
OTProperties,
ChildParentOT,
Properties
Where
Objects.ObjectID = @ObjectId and
Properties.ObjectID = @ObjectID and
Objecttypes.OTID = (select Objects.OTID
from objects
where
Objects.ObjectId = @ObjectId)and
ChildParentOT.OTID = (select Objects.OTID
from objects
where
Objects.ObjectId = @ObjectId)
/*Properties.OTPropertyID = OTProperties.OTPropertyID*/ and
@TempOTID = (select Objects.OTID
from objects
where Objects.ObjectId = @ObjectId)

If Exists (select OTID
from OTProperties
where OTProperties.OTID = @TempOTID)
Begin
OTProperties.OTID = (select Objects.OTID
from objects
where Objects.ObjectId = @ObjectId)
End

**************
de error i am getting is

ADO error: Line 50 : Incorrect syntax near 'OTProperties.'
Incorrect syntax near the keyword 'End'
****************************

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources