Feature Req: Support for common table expressions (CTE)
lewismoten
Posts: 58
I have a lot of stored procedures that appear to be orphans. I checked out all of the tables that it references, and they all exist in the diagram.
The thing that they all seem to have in common is the use of common table expressions. This was introduced with SQL Server 2005. I use these help speed up paging operations for large sets of data.
Will there be future support for this?
http://msdn2.microsoft.com/en-us/library/ms190766.aspx
The thing that they all seem to have in common is the use of common table expressions. This was introduced with SQL Server 2005. I use these help speed up paging operations for large sets of data.
Will there be future support for this?
http://msdn2.microsoft.com/en-us/library/ms190766.aspx
Comments
I think this may be related to a known bug in SQL Compare. Since SQL Compare shares some components with Dependency Tracker, this should be fixed at the same time as SQL Compare.
Note that there is support for CTE in Dependency Tracker, it's only when a UDF, and I suppose this also applies to stored procedures, returns a CTE.