USP_SIMPLEDATALIST_VSECATEGORIESCOLLEGE

                CREATE procedure dbo.USP_SIMPLEDATALIST_VSECATEGORIESCOLLEGE

                as                

                    set nocount on;

                select 
                    [ID] as VALUE, 
                    [VSECATEGORY] as LABEL 
                from 
                    dbo.VSECATEGORY
                where
                    USAGETYPECODE = (select vsetypecode from dbo.vsetype) or USAGETYPECODE = 2
                order by 
                    [VSECATEGORY];