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