USP_SIMPLEDATALIST_SOCIALMEDIASERVICE

CREATE procedure dbo.USP_SIMPLEDATALIST_SOCIALMEDIASERVICE 
as
    set nocount on;

    select 
        SOCIALMEDIASERVICE.ID as VALUE, 
        SOCIALMEDIASERVICE.NAME as LABEL
    from 
        dbo.SOCIALMEDIASERVICE
    where
        SOCIALMEDIASERVICE.ISACTIVE = 1
    order by 
        SOCIALMEDIASERVICE.NAME