with within with error

Question

Post reply

with within with error

nkat

SSChasing Mays

Points: 658
More actions
June 6, 2022 at 5:19 pm

#4045175
Hello!
Please, consider the following simple code
```
with cte AS (
SELECT 
      
      [cntSRVLDAPLOADAVERAGE]
  FROM [watchdocstats].[dbo].[servercounters]);


 WITH cteCORE AS ( SELECT * FROM cte );

 SELECT * FROM cteCORE
```
Would someone please elaborate on why I get 'Incorrent syntax near ;' error?
June 7, 2022 at 8:38 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

nkat SSChasing Mays Points: 658 More actions · Answer 1

found the answer

https://stackoverflow.com/questions/18010850/sql-with-clause-within-a-with-clause

Happy coding!

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 2

nkat wrote:

found the answer
https://stackoverflow.com/questions/18010850/sql-with-clause-within-a-with-clause
Happy coding!

Can you post the solution for the code you posted?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ScottPletcher SSC Guru Points: 101108 More actions · Answer 3

Getting carried away with the semicolons, and attempting to use two WITHs for one SELECT:

:WITH cte AS (
    SELECT [cntSRVLDAPLOADAVERAGE]
    FROM [watchdocstats].[dbo].[servercounters]
),
cteCORE AS ( SELECT * FROM cte 
)
SELECT *
FROM cteCORE

This reply was modified 2 years, 6 months ago by ScottPletcher.

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

nkat SSChasing Mays Points: 658 More actions · Answer 4

Exactly! there's no way to nest 'with', but one can chain them.

Thank you!