Home Forums SQL Server 2008 T-SQL (SS2K8) subdivision on output query in server 2000 RE: subdivision on output query in server 2000

  • August 28, 2012 at 4:03 am

    #1530665

    ChrisM@Work (8/28/2012)

    raghuldrag (8/28/2012)

    alter procedure Goals_history

    ...

    What version of SQL Server is your database?

    OP answered in a PM, he's using SQL Server 2000.

    Raghuldrag, please post in the SQL Server 7, 2000 forum section. Posting in the SS2K8 section wastes people's time as the solutions may be different and incompatible with your antique version.

    “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