spGetDataSourcesForNewsletters

        CREATE    Procedure dbo.spGetDataSourcesForNewsletters
        AS
        select 
            DataSourceID, 
            [Name] as DataSourceName,
            BackOfficeSystemId
            from DataSources
            where 
            SubscriberProviderForSystemID is not null
            order by BackOfficeSystemId, [Name]