spLoadRecord_EmailList_Subscription

CREATE PROCEDURE [dbo].[spLoadRecord_EmailList_Subscription] (
    @PKID int)
AS

    select 
        ID, 
        EmailListID, 
        UserID, 
        HasOpted, 
        BackofficeSystemPeopleID, 
        EmailAddress, 
        FirstName, 
        LastName
    from EmailList_Subscription
    where id = @pkid