[RESOLVED] Abnormal Unrolling

[Zvoni]

That was poorly stated on my part. I know you can write a CTE in SSMS. What I meant to say was that I'm not sure you can write a CTE in SSMS without writing SQL. If all you do is drag tables into a designer, fiddle with joins, etc., without ever touching the raw SQL, is it still possible to create a CTE?

Ahh….. don’t think so.

OTOH, never used those „click and dragdrop“-thingies in any db-client.
always used SQL, so I shouldn’t talk