USP_GETFEATURETIPSEEN

create procedure dbo.USP_GETFEATURETIPSEEN
(
    @APPUSERID uniqueidentifier,
    @FEATURETIPID uniqueidentifier,
    @SETTIPASSEEN bit
)
as
begin
    declare @HASSEENTIP bit;
    if exists(select ID from dbo.APPUSERFEATURETIP where APPUSERID = @APPUSERID and FEATURETIPID = @FEATURETIPID)
    begin
        set @HASSEENTIP = 1;
    end
    else
    begin
        set @HASSEENTIP = 0;
    end

    if @SETTIPASSEEN = 1 and @HASSEENTIP = 0
    begin
        insert into dbo.APPUSERFEATURETIP (APPUSERID,FEATURETIPID)
        values (@APPUSERID,@FEATURETIPID);    
    end

    select @HASSEENTIP as TIPSEEN
end