spLoadRecord_NewsReaders

        CREATE PROCEDURE dbo.spLoadRecord_NewsReaders 
        (            
            @PKID int 
        )
        AS

        declare @NewsReaderUsername varchar(100) 
        declare @NewsReaderPassword varchar(50)

        BEGIN TRY
        exec dbo.USP_GET_KEY_ACCESS;

            SELECT                
                @NewsReaderUsername = Convert(nvarchar(100), DECRYPTBYKEY(NewsReaderUsername)),
                @NewsReaderPassword = Convert(nvarchar(50), DECRYPTBYKEY(NewsReaderPassword))   
            FROM NewsReaders 
            WHERE ID = @PKID

        close symmetric key sym_BBInfinity;
        END TRY
        BEGIN CATCH
            EXEC dbo.USP_RAISE_ERROR;
            close symmetric key sym_BBInfinity;
        END CATCH

        SELECT
            ID,
            SiteContentID,
            [GUID],
            ShowDate,
            ShowGraphic,
            MaxHeadlines,
            HeadlineOnly,
            ArticlesPerPage,
            PagedOutput,
            NewsReaderURL,
            NewsReaderAuthType,
            @NewsReaderUsername,
            @NewsReaderPassword  
        FROM NewsReaders 
        WHERE ID = @PKID