USP_DATALIST_MERCHANDISEDEPARTMENTCATEGORY

Displays categories for a merchandise department.

Parameters

Parameter	Parameter Type	Mode	Description
@MERCHANDISEDEPARTMENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



create procedure dbo.USP_DATALIST_MERCHANDISEDEPARTMENTCATEGORY(@MERCHANDISEDEPARTMENTID uniqueidentifier)
as
    set nocount on;

    select ID,
           NAME,
           DESCRIPTION,
       ISACTIVE
    from dbo.MERCHANDISEDEPARTMENTCATEGORY
    where MERCHANDISEDEPARTMENTID = @MERCHANDISEDEPARTMENTID