UFN_MERCHANDISEDEPARTMENT_GETCATEGORIES

Returns the categories configured for a given department.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MERCHANDISEDEPARTMENTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_MERCHANDISEDEPARTMENT_GETCATEGORIES
        (
            @MERCHANDISEDEPARTMENTID uniqueidentifier = null
        )
        returns table
        as
            return (
                select
                    C.ID,
                    C.NAME,
                    C.DESCRIPTION,
                    case
                        when exists(select 1 from dbo.MERCHANDISEPRODUCT where MERCHANDISEDEPARTMENTCATEGORYID = C.ID) then 1
                        when exists(select 1 from dbo.SALESORDERITEMMERCHANDISE where MERCHANDISEDEPARTMENTCATEGORYID = C.ID) then 1
                        else 0
                    end INUSE
                from dbo.MERCHANDISEDEPARTMENTCATEGORY C
                where MERCHANDISEDEPARTMENTID = @MERCHANDISEDEPARTMENTID
            )