Incorrect syntax near the keyword 'WITH'

[icanmakeiteasy]

Hi, DECLARE @Location_ID INT SELECT @Location_ID = 3 ;WITH ret AS( SELECT * FROM Locations WHERE Location_ID = @Location_ID UNION ALL SELECT t.* FROM Locations t INNER JOIN ret r ON t.Parent_ID = r.Location_ID ) SELECT * FROM ret here is my query, am getting error:Incorrect syntax near the keyword 'WITH' help me to fix this problem friends

icanmakeiteasy

[Michel Godfroid]

Semi-colons do not display in Braille?

[David Skelly]

Michel Godfroid wrote:

Semi-colons do not display in Braille?

There's nothing wrong with the semi-colon. What point were you trying to make, or were you just trying to be smart?

[Michel Godfroid]

:~ You're right, I stand corrected; sincere apologies. The line breaks and absence of indentation made me think the first couple of lines belonged to the same statement.

[WoutL]

There is nothing wrong with this query unless you are using SQL 2000 or earlier!

Wout Louwers

[icanmakeiteasy]

srry, for the late reply am using sql server 2000, plz help me to achieve this in sql server 2000

icanmakeiteasy