update
a
set
vcIsSend='1'
FROM
dbo.hy_Mobile_R_Msg_User a
NNER JOIN
dbo.hy_MobileMsgUser b
ON
a.uUserPK = b.uUserPK
WHERE
a.uMsgPK = @uMsgPK
AND
b.vcMobileNo IN (@strTel)
a
set
vcIsSend='1'
FROM
dbo.hy_Mobile_R_Msg_User a
NNER JOIN
dbo.hy_MobileMsgUser b
ON
a.uUserPK = b.uUserPK
WHERE
a.uMsgPK = @uMsgPK
AND
b.vcMobileNo IN (@strTel)
a
set
vcIsSend='1'
FROM
dbo.hy_Mobile_R_Msg_User a
NNER JOIN
dbo.hy_MobileMsgUser b
ON
a.uUserPK = b.uUserPK
WHERE
a.uMsgPK = @uMsgPK
AND
charindex(','+b.vcMobileNo+',',','+@strTel+',')>0
set vcIsSend='1'
from dbo.hy_MobileMsgUser a inner join dbo.hy_Mobile_R_Msg_User b
ON a.uUserPK = b.uUserPK
where a.vcMobileNo IN (@strTel)
and b.uMsgPK = @uMsgPK