Home Forums SQL Server 7,2000 T-SQL Determine Primary and Secondary numbers in a table. RE: Determine Primary and Secondary numbers in a table.

  • Thank you Lynn for your response.

    I have been offline for a few days and have not been able to try your solution.

    What I had been trying was using a series of case statements checking for each condition and that was working about as well as tits on a bore hog, hence my post.

    Yes, this is on SQL 2000, but since you suggested CTEs maybe I can use your suggestion as a guide to put something together in SQL 2000.

    Thanks Again.

    Gary