USP_DATALIST_VSESUBCATEGORY
Returns a list of all of the VSE subcategories grouped by VSE category.
Definition
Copy
CREATE procedure dbo.USP_DATALIST_VSESUBCATEGORY
as
begin
select
VSECATEGORY.ID,
null as PARENTID,
1 as ISVSECATEGORY,
VSECATEGORY.VSECATEGORY as NAME
from
dbo.VSECATEGORY
where
VSECATEGORY.USAGETYPECODE = (SELECT VSETYPECODE FROM DBO.VSETYPE) or
VSECATEGORY.USAGETYPECODE = 2
union
select
VSESUBCATEGORY.ID,
VSESUBCATEGORY.VSECATEGORYID as PARENTID,
0 as ISVSECATEGORY,
VSESUBCATEGORY.NAME
from
dbo.VSESUBCATEGORY
left join dbo.VSECATEGORY on
VSESUBCATEGORY.VSECATEGORYID = VSECATEGORY.ID
where
VSECATEGORY.USAGETYPECODE = (SELECT VSETYPECODE FROM DBO.VSETYPE) or
VSECATEGORY.USAGETYPECODE = 2
order by
NAME;
end