UFN_DELIVERYMETHOD_VALIDPRINTCODE

            CREATE function dbo.UFN_DELIVERYMETHOD_VALIDPRINTCODE (
                @DELIVERYMETHODID uniqueidentifier, 
                @PRINTCODE tinyint
            )
            returns bit
            with execute as caller
            as begin

                if @PRINTCODE is null
                    return 0;
                else if 
                    @PRINTCODE = 2 and
                    exists (
                        select 1
                        from dbo.SALESMETHODDELIVERYMETHOD
                        inner join dbo.SALESMETHOD
                            on SALESMETHODDELIVERYMETHOD.SALESMETHODID = SALESMETHOD.ID
                        where 
                            DELIVERYMETHODID = @DELIVERYMETHODID and
                            SALESMETHOD.TYPECODE in (0,1)
                    )
                        return 0;
                else if
                    @PRINTCODE = 2 and
                    exists (
                        select 1
                        from dbo.DOCUMENTPRINTINGRULE
                        where DELIVERYMETHODID = @DELIVERYMETHODID
                    )
                        return 0;

                return 1;
            end