WITH syntax - 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

General SQL Server Forums

New to SQL Server Programming

WITH syntax

Author

Topic

kt
Yak Posting Veteran

88 Posts

Posted - 2013-09-19 : 13:51:29

Hi,
why am i getting an error:Incorrect syntax near the keyword 'INNER'.?
can you pls help?
thanks

WITH RecursiveBOM (LEVEL,t_mitm, t_sitm)
AS (SELECT 1,ROOT.t_mitm, ROOT.t_sitm
FROM bom011 ROOT
WHERE ltrim(ROOT.t_mitm) = '040300'
Union All
SELECT PARENT.LEVEL+1, CHILD.t_mitm, CHILD.t_sitm
FROM RecursiveBOM PARENT, bom011 CHILD
WHERE PARENT.t_sitm = CHILD.t_mitm

)
SELECT *
FROM RecursiveBOM as Rec
OPTION (MAXRECURSION 10)
INNER JOIN cpr007110 as icpr
on Rec.t_mitm = icpr.t_item

MuMu88
Aged Yak Warrior

549 Posts

Posted - 2013-09-19 : 14:12:10

Try this:
[CODE]

WITH RecursiveBOM (LEVEL,t_mitm, t_sitm)
AS (SELECT 1,ROOT.t_mitm, ROOT.t_sitm
FROM bom011 ROOT
WHERE ltrim(ROOT.t_mitm) = '040300'
Union All
SELECT PARENT.LEVEL+1, CHILD.t_mitm, CHILD.t_sitm
FROM RecursiveBOM PARENT, bom011 CHILD
WHERE PARENT.t_sitm = CHILD.t_mitm

)
SELECT *
FROM RecursiveBOM as Rec
INNER JOIN cpr007110 as icpr
on Rec.t_mitm = icpr.t_item
OPTION (MAXRECURSION 10)
[/CODE]

kt
Yak Posting Veteran

88 Posts

Posted - 2013-09-19 : 15:01:18

you are rock, thank youuuuuuuuuuuuuuuu

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources