USP_SETFEATURETIPSEEN

create procedure dbo.USP_SETFEATURETIPSEEN
(
    @APPUSERID uniqueidentifier,
    @FEATURETIPID uniqueidentifier,
    @TipSeen bit
)
as
begin

    if @TipSeen = 1 
    begin
        if not exists(select ID from dbo.APPUSERFEATURETIP where APPUSERID = @APPUSERID and FEATURETIPID = @FEATURETIPID)
        begin
            insert into dbo.APPUSERFEATURETIP (APPUSERID,FEATURETIPID)
            values (@APPUSERID,@FEATURETIPID);    
        end
    end
    else
    begin
        delete dbo.APPUSERFEATURETIP where APPUSERID = @APPUSERID and FEATURETIPID = @FEATURETIPID
    end

end