Update EMRLabResultsDetails
Set LAB_PROFILE_ID = b.LAB_PROFILE_ID
From EMRLabResultsDetails a,
(
SELECT DISTINCT ELRD.LAB_REQUEST_ID,ELRD.LAB_PROFILE_ID,ELRDS.TEST_ID,ELRDS.LAB_RESULT_ID,ELRDS.LAB_RESULT_DETAILS_ID
FROM EMRLabRequest ELR 
INNER JOIN EMRLabRequestDetails ELRD ON ELR.LAB_REQUEST_ID=ELRD.LAB_REQUEST_ID AND LAB_PROFILE_ID IS NOT NULL 
INNER JOIN EMRLabResults ELRS ON ELRS.LAB_REQUEST_ID=ELR.LAB_REQUEST_ID 
INNER JOIN EMRLabResultsDetails ELRDS ON ELRDS.LAB_RESULT_ID=ELRS.LAB_RESULT_ID 
INNER JOIN EMRLabTestProfileLkup ELTPL ON ELTPL.LAB_PROFILE_ID=ELRD.LAB_PROFILE_ID 
INNER JOIN EMRTestProfiles ETP ON ETP.LAB_PROFILE_ID=ELTPL.LAB_PROFILE_ID  
WHERE ELR.STATUS=1 AND ELRD.LAB_PROFILE_ID=ETP.LAB_PROFILE_ID AND ETP.TEST_ID=ELRDS.TEST_ID  
) b
Where a.LAB_RESULT_ID = b.LAB_RESULT_ID
GO