Home Forums SQL Server 2008 SQL Server 2008 - General Just one row for each patientid 2 RE: Just one row for each patientid 2

  • February 16, 2014 at 3:25 am

    #1689326

    Thanks Igor, but unfortunately we don't have our Contracts column with that sql.

    re

    (CASE WHEN t.LedgerType = 1 THEN t.LedgerAmount ELSE 0.00 END) * -1 AS