MERGE

MERGE dbo.wph_WorkplaceFriend T

USING (

SELECT wph_wf_BuildingID, wph_wf_VillageID, wph_wf_UserID, wph_wf_FriendUserID, wph_wf_CoWorkState, wph_wf_ReduceTime 

FROM Admin_DB.dbo.udf_CLR_SplitString_WorkplaceFriend(@WorkplaceFriend_TT)

) S ON T.wph_wf_VillageID = S.wph_wf_VillageID AND T.wph_wf_BuildingID = S.wph_wf_BuildingID

WHEN MATCHED AND S.wph_wf_FriendUserID = 0 THEN

DELETE

WHEN MATCHED AND S.wph_wf_FriendUserID <> 0 THEN

UPDATE SET T.wph_wf_UserID = S.wph_wf_UserID

, T.wph_wf_FriendUserID = S.wph_wf_FriendUserID

, T.wph_wf_CoWorkState = S.wph_wf_CoWorkState

, T.wph_wf_ReduceTime = S.wph_wf_ReduceTime;