USP_DATAFORMTEMPLATE_EDITLOAD_BBWSURL

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBWSURL (
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @BBWSURL dbo.UDT_WEBADDRESS = null output,
            @BBWSUSERNAME nvarchar(100) = null output,
            @BBWSPASSWORD nvarchar(100) = null output
                    ) as
                        set nocount on;

                        set @DATALOADED = 1;
                        set @TSLONG = 0;

            exec dbo.USP_GET_KEY_ACCESS

            begin try

                          select top 1
                              @TSLONG = TSLONG,
                              @BBWSURL = [BBWSURL],
                            @BBWSUSERNAME = convert(nvarchar(100), DecryptByKey(BBWSUSERNAME))
                          from
                              dbo.[WEALTHPOINTCONFIGURATION]
              order by dateadded;

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

        return 0;