USP_BBPSLOGIN_GET

Returns Blackbaud Payment Service login credentials.

Parameters

Parameter	Parameter Type	Mode	Description
@USERNAME	nvarchar(100)	INOUT
@PASSWORD	nvarchar(100)	INOUT

Definition

Copy



            create procedure dbo.USP_BBPSLOGIN_GET
            (
                @USERNAME nvarchar(100) = null output,
                @PASSWORD nvarchar(100) = null output
            )
            as
                set nocount on

                exec dbo.USP_GET_KEY_ACCESS

                begin try
                    select top 1
                        @USERNAME = convert(nvarchar(100), DecryptByKey(USERNAME)),
                        @PASSWORD = convert(nvarchar(100), DecryptByKey(PASSWORD))
                    from dbo.BBPSLOGIN
                    order by DATEADDED

                    close symmetric key sym_BBInfinity
                end try
                begin catch
                    close symmetric key sym_BBInfinity
                end catch