SQL Server Performance

SQL Stored Procedure

Discussion in 'SQL Server Reporting Services' started by ellebanna, Sep 30, 2004.

  1. ellebanna New Member

    Here is a sample of the data as it stands in our Db now

    PersonID = 1
    EnrollmentID = 100,101
    OUTCOmeID = 500,501
    In a simple query this result is returned
    Person ---->Enrollment--->OUTCOME
    1 100 Null
    1 101 500
    1 101 501

    Enrollment 1 per the users is the Accountable Person Enrollment
    OutCome 500 per the users is the accountable Person Outcome

    I need to be able to return just one record compared to 3 above with this result

    Person--->Enrollment--->OutCome
    1 100 500

    Can anyone give a sample T-QSL for this. Appreciate any help.
  2. Twan New Member

Share This Page