How can we help you today? How can we help you today?

Feature Req: Support for common table expressions (CTE)

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
lewismoten
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hi Lewis,

    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.