Home Forums SQL Server 2008 T-SQL (SS2K8) trying to add alias for value generated by Where clause RE: trying to add alias for value generated by Where clause

  • polkadot (7/31/2012)


    ... I need an alias for the column the WHERE STATEMENT generates...

    The WHERE clause doesn't generate an output column. Ever.

    There are four well-known ways to calculate running totals in SS2k8:

    1. Quirky update - fastest

    2. Recursive CTE

    3. Cursor

    4. Triangular Join - usually slowest but depends upon partitioning.

    The code you've posted is an attempt at coding the TJ method. If the number of elements in each GROUP BY partition is small compared to the entire data set then it may be worth pursuing, however most folks would recommend the QU for speed or the rCTE for ease of coding.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden