ForgiveMeForIHaveSinned

create table temp1 (id int identity primary key, Location varchar(4), ItemNo int)
create table alreadyReturned(id int primary key)

create or alter function fn_a (@id int)
returns int
as
begin
    declare @sql varchar(4000),
            @cmd varchar(4000),
            @retval tinyint


    if not exists (select 1 from alreadyReturned where id = @id)
    begin
        select @sql = 'insert into alreadyReturned select ' + cast(@id as varchar)
        select @cmd = 'sqlcmd -S ' +@@SERVERNAME+ ' -d ' +db_name()+ ' -Q "' + @sql +'"'
        exec master..xp_cmdshell @cmd, 'no_output'
        set @retval = 1
    end
    else set @retval = 0

return @retval
end
go

CREATE or alter FUNCTION fn_b(@id AS int)
    RETURNS TABLE
    RETURN SELECT 1 AS 'SecureCourierShipments'  where  dbo.fn_a(@id) = 1
go


CREATE SECURITY POLICY bazmek

ADD FILTER PREDICATE dbo.fn_b(id)
ON dbo.temp1
WITH (STATE = ON, Schemabinding = off);