USP_ADDTAGTOIMAGE

CREATE procedure dbo.USP_ADDTAGTOIMAGE
(
    @TAGCODEID uniqueidentifier,
    @SITEIMAGEID int
)
as
begin
    -- do work

    declare @CHANGEAGENTID uniqueidentifier
    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

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

    if exists(select 1 from dbo.TAGCODE where ID = @TAGCODEID)
    begin
        merge dbo.siteimagetag as target
        using (select @SITEIMAGEID SITEIMAGEID, @TAGCODEID TAGCODEID) as source
        on target.SITEIMAGEID = source.SITEIMAGEID and target.TAGCODEID = source.TAGCODEID
        when not matched then
            insert (SITEIMAGEID, TAGCODEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
            values (@SITEIMAGEID, @TAGCODEID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);
    end

end