USP_ADDUPDATE_CMSUSERSOCIALMEDIAACCOUNT

Parameters

Parameter	Parameter Type	Mode
@CLIENTUSERID	int	IN
@SOCIALMEDIASERVICEID	uniqueidentifier	IN
@USERID	nvarchar(100)	IN
@URL	nvarchar(2047)	IN

Definition

Copy



create procedure dbo.USP_ADDUPDATE_CMSUSERSOCIALMEDIAACCOUNT
(
    @CLIENTUSERID int,
    @SOCIALMEDIASERVICEID uniqueidentifier,
    @USERID nvarchar(100),
    @URL nvarchar(2047)
)
as
begin

    declare @CHANGEAGENTID uniqueidentifier;
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    merge into dbo.CMSUSERSOCIALMEDIAACCOUNT as TARGET
    using (SELECT @CLIENTUSERID as CLIENTUSERID,  @SOCIALMEDIASERVICEID as SOCIALMEDIASERVICEID) as SOURCE
    on TARGET.CLIENTUSERID = SOURCE.CLIENTUSERID and TARGET.SOCIALMEDIASERVICEID = SOURCE.SOCIALMEDIASERVICEID
    when matched then
      update set USERID = @USERID, URL = @URL
    when not matched by target then
      insert (CLIENTUSERID, SOCIALMEDIASERVICEID, USERID, URL, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED) 
      values (@CLIENTUSERID, @SOCIALMEDIASERVICEID, @USERID, @URL, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);
end