USP_SIMPLEDATALIST_VSESUBCATEGORIES

                CREATE procedure dbo.USP_SIMPLEDATALIST_VSESUBCATEGORIES
                (
                    @VSECATEGORYID uniqueidentifier = null
                )
                as
                    --The input parameter has been defaulted to null so that the simplelist 

                    --can return all values when used with Query.


                    set nocount on;

                    select 
                        ID as VALUE, 
                        NAME as LABEL
                    from 
                        dbo.VSESUBCATEGORY
                    where 
                        (
                            VSECATEGORYID = @VSECATEGORYID 
                            or 
                            @VSECATEGORYID is null
                        )
                    order by NAME