Home Forums SQL Server 2012 SQL Server 2012 - T-SQL CTE within a stored proc RE: CTE within a stored proc

  • August 28, 2015 at 5:13 pm

    #1823174

    I've seen the TOP 100 PERCENT...ORDER BY hack used in actual view definitions. I know it worked in SQL 2005, but I seem to recall it not working in a later version. I wish I could remember which version, but it's still a hack.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions