UFN_VSECATEGORY_ALLROWSEXIST

Returns whether all of the VSE categories have a row included in the VSECATEGORY table.

Return

Return Type
bit

Definition

Copy



            CREATE function dbo.UFN_VSECATEGORY_ALLROWSEXIST()
            returns bit
            as begin
                if (select
                        count(ID)
                    from
                        dbo.VSECATEGORY
                    where
                        VSECATEGORY.VSECATEGORYCODE in (
                            0,1,2,3,4,5,6,7,8,9,10,12,13,14,15,18,19,20,21,22,23,24,25,26)) = 24
                    return 1;

                return 0;
            end