USP_CLIENTUSERSCIPHER_GET_CIPHER

create procedure dbo.USP_CLIENTUSERSCIPHER_GET_CIPHER
(
  @CLIENTUSERSID int
)
as begin

     exec dbo.USP_GET_KEY_ACCESS;

       select coalesce(convert(varchar(255),DECRYPTBYKEY(CIPHER)), '') 
   from dbo.CLIENTUSERSCIPHER where CLIENTUSERSID = @CLIENTUSERSID;

    exec dbo.USP_CLOSE_KEY_ACCESS;

end