USP_DATALIST_AUCTIONITEMCATEGORY

                CREATE procedure dbo.USP_DATALIST_AUCTIONITEMCATEGORY
                as
                    set nocount on;

                    select
                        AUCTIONITEMCATEGORY.ID,
                        AUCTIONITEMCATEGORY.NAME,
                        AUCTIONITEMCATEGORY.DESCRIPTION,
                        (select dbo.UDA_BUILDLIST(AUCTIONITEMSUBCATEGORY.NAME)
                         from AUCTIONITEMSUBCATEGORY
                         where AUCTIONITEMSUBCATEGORY.AUCTIONITEMCATEGORYID = AUCTIONITEMCATEGORY.ID
                        ) as SUBCATEGORIES
                    from dbo.AUCTIONITEMCATEGORY
                    order by AUCTIONITEMCATEGORY.NAME