spLoadRecord_DataSources

Parameters

Parameter Parameter Type Mode Description
@PKID int IN

Definition

Copy


    CREATE  PROCEDURE [dbo].[spLoadRecord_DataSources]
                    (
                        @PKID int
                    )
                AS
                    SELECT [DataSourceID]
                      ,[Name]
                      ,[TypeNamespace]
                      ,[TypeName]
                      ,[IsEmailListSource]
                      ,[BackOfficeSystemId]
                      ,[Available]
                      ,[SubscriberProviderForSystemID]
                      ,[ImportListID]  
                      ,[UploadOrigin]
                    FROM [dbo].[DataSources] WHERE DataSourceID = @PKID AND Deleted = 0