SQL Stored Procedure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Stored Procedure

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.
This is a duplicate of http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=5677 Cheers