USP_DATALIST_AUCTIONITEMSUBCATEGORY

Lists subcategories for an auction item category.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_AUCTIONITEMSUBCATEGORY
                (
                    @AUCTIONITEMCATEGORYID uniqueidentifier
                )
                as
                    set nocount on;

                    select AUCTIONITEMSUBCATEGORY.ID,
                           AUCTIONITEMSUBCATEGORY.NAME,
                           AUCTIONITEMSUBCATEGORY.DESCRIPTION
                    from dbo.AUCTIONITEMSUBCATEGORY
                    where AUCTIONITEMSUBCATEGORY.AUCTIONITEMCATEGORYID = @AUCTIONITEMCATEGORYID
                    order by AUCTIONITEMSUBCATEGORY.NAME