USP_DATAFORMTEMPLATE_EDITLOAD_SFTPFINDERSERVICESSETTING

                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SFTPFINDERSERVICESSETTING
                (
                    @DATALOADED bit = 0 output,
                    @TSLONG bigint = 0 output,    
                    @USERNAME nvarchar(255) = null output,
                    @PASSWORD nvarchar(200) = null output
                )
                as

                    set nocount on;

                    -- be sure to set these, in case the select returns no rows
                    set @DATALOADED = 0
                    set @TSLONG = 0

                    if (select count(1) from dbo.[SFTPFINDERSERVICESCONFIGURATION]) = 1
                    begin  
                        select top 1
                            @DATALOADED = 1,
                            @TSLONG = TSLONG,
                            @USERNAME = USERNAME
                        from dbo.SFTPFINDERSERVICESCONFIGURATION;
                    end
                    else
                    begin
                            set @DATALOADED = 1;
                            set @USERNAME = N'';
                            set @PASSWORD = N'';
                    end  

                    return 0;