spLoadRecord_DataSourceForSubscribersFromSystemID

Parameters

Parameter Parameter Type Mode Description
@BackOfficeSystemID int IN

Definition

Copy


            CREATE PROCEDURE [dbo].[spLoadRecord_DataSourceForSubscribersFromSystemID]
                (
                    @BackOfficeSystemID int
                )
            AS

            SELECT [DataSourceID]
              ,[Name]
              ,[TypeNamespace]
              ,[TypeName]
              ,[IsEmailListSource]
              ,[BackOfficeSystemId]
              ,[Available]
              ,[SubscriberProviderForSystemID]
              ,[ImportListID] 
            FROM [dbo].[DataSources] WHERE SubscriberProviderForSystemID= @BackOfficeSystemID