USP_SIMPLEDATALIST_SITEIMAGECATEGORIES

CREATE procedure dbo.[USP_SIMPLEDATALIST_SITEIMAGECATEGORIES]
as
  select
    [FOLDERID] as [VALUE],
    [FOLDERNAME] as [LABEL]
  from dbo.[SITEFOLDERS]
  where [TYPE] = 2
  and [DELETED] = 0
  order by [FOLDERNAME] asc