USP_BBWSCONFIGURATION_GET

            create procedure dbo.USP_BBWSCONFIGURATION_GET(
                @BBWSURL dbo.UDT_WEBADDRESS = null output,
                @USERNAME nvarchar(100) = null output,
                @PASSWORD nvarchar(100) = null output
            ) as begin
                set nocount on;

                exec dbo.USP_GET_KEY_ACCESS

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

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

                return 0;
            end;