Home Forums SQL Server 7,2000 T-SQL @@Rowcount is not reliable? RE: @@Rowcount is not reliable?

  • June 3, 2009 at 4:24 am

    #1003884

    Try to run this:

    SELECT ID, Status, COUNT(*)

    FROM Table

    GROUP BY ID, Status

    HAVING COUNT(*) > 1

    _____________
    Code for TallyGenerator