USP_SIMPLEDATALIST_AUCTIONITEMSUBCATEGORY

Retrieves a list of auction item subcategories for a category.

Parameters

Parameter	Parameter Type	Mode	Description
@AUCTIONITEMCATEGORYID	uniqueidentifier	IN

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_AUCTIONITEMSUBCATEGORY 
                (
                    @AUCTIONITEMCATEGORYID uniqueidentifier
                )
                as
                    select 
                        ID as VALUE, 
                        NAME as LABEL
                    from dbo.AUCTIONITEMSUBCATEGORY
                    where AUCTIONITEMCATEGORYID = @AUCTIONITEMCATEGORYID
                    order by NAME