Common Table Experssion (CTE) Format
Posted on 2011-10-12
In SQL 2008 Management Studio I developed a CTE in a view. My question or issue is that when I reopen the view I lose the begining syntax of the CTE. In other words my CTE starts as With XYZ as (Select A, B, C etc), I then save the view and when I reopen it the With XYZ as ( is gone, so the view now only shows Select A, B, C etc.....
I also developed a stored procedure using this same view and it works ok. So overall my application is OK, however why would I lose that syntax when reopening the CTE?