Post reply

Complex Expression (CTE) equivalence in SQLServer 2000

  • January 4, 2007 at 11:17 pm

    #681388

    CTE = Common Table Expression.

    There is no equivalent functionality in SQL 2000. If you post the actual view statements, maybe we can help.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • January 5, 2007 at 2:48 am

    #681410

    It's not uncommon that a view works fine, but when you stack views on top of each other, you may get poorer performance than when using those views separately.

    It's one of those things 'how things work'.

    It all depends on what the particular view look like...

    /Kenneth

Viewing 2 posts - 1 through 3 (of 3 total)

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