spLoadSetting

        CREATE PROCEDURE [dbo].[spLoadSetting]
        AS
        BEGIN
            exec dbo.USP_GET_KEY_ACCESS

            begin try
                SELECT [ID], [Name], Value as 'Value', CreateDate, UpdateDate
                FROM [dbo].[Setting] s    
                WHERE ID not in (7,8,9,10,11,12,36,37,55,56,71,72,77,78,118,125,115,85,86)
                UNION 
                SELECT [ID], [Name], DECRYPTBYKEY(Value) as 'Value', CreateDate, UpdateDate
                FROM [dbo].[Setting] s
                WHERE ID in (7,8,36,37,55,56,77,78,125,115,85,86)        
                UNION
                SELECT top 1 9 as 'ID', [Name], Value as 'Value', DATEADDED as 'CreateDate', DATECHANGED as 'UpdateDate'
                FROM [dbo].[EXTERNALSERVICECONFIGURATION] s    
                WHERE NAME = 'BlackbaudServiceHost' and SITEID = 1
                UNION
                SELECT top 1 12 as 'ID', [Name], Value as 'Value', DATEADDED as 'CreateDate', DATECHANGED as 'UpdateDate'
                FROM [dbo].[EXTERNALSERVICECONFIGURATION] s    
                WHERE NAME = 'BlackbaudServiceUseSecureServices' and SITEID = 1
                UNION
                SELECT top 1 10 as 'ID', [Name], DECRYPTBYKEY(Value) as 'Value', DATEADDED as 'CreateDate', DATECHANGED as 'UpdateDate'
                FROM [dbo].[EXTERNALSERVICECONFIGURATION] s    
                WHERE NAME = 'BlackbaudServiceUser' and SITEID = 1
                UNION
                SELECT top 1 11 as 'ID', [Name], DECRYPTBYKEY(Value) as 'Value', DATEADDED as 'CreateDate', DATECHANGED as 'UpdateDate'
                FROM [dbo].[EXTERNALSERVICECONFIGURATION] s    
                WHERE NAME = 'BlackbaudServicePassword' and SITEID = 1
                UNION
                SELECT top 1 71 as 'ID', 'BBPSUser' as 'Name', DECRYPTBYKEY(USERNAME) as 'Value', DATEADDED, DATECHANGED
                FROM BBPSLOGIN
                UNION
                SELECT top 1 72 as 'ID', 'BBPSPassword' as 'Name', DECRYPTBYKEY(PASSWORD) as 'Value', DATEADDED, DATECHANGED
                FROM BBPSLOGIN                
                UNION             
                SELECT top 1 118 as 'ID', 'ClarifySiteId' as 'Name', CLARIFYSITEID as 'Value', null, null            
                FROM INSTALLATIONINFO

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

        END