USP_DATALIST_MKTSEGMENT

          create procedure dbo.USP_DATALIST_MKTSEGMENT
          as
            set nocount on;

            select 
              S.[ID],
              S.[CODE],
              S.[NAME],
              S.[DESCRIPTION],
              dbo.UFN_MKTSEGMENT_ISINUSE(S.[ID]),
              S.[DATEREFRESHED]
            from dbo.[MKTSEGMENT] S
            where [ISSYSTEM] = 0
            order by S.[NAME];

            return 0;