UFN_PASSWORD_LASTCHANGED

create function dbo.UFN_PASSWORD_LASTCHANGED
(
@CLIENTUSERSID int
)
returns datetime
as begin

                DECLARE @dateUsed datetime;
                select top 1 @dateUsed = DATEUSED from dbo.CLIENTUSERSCIPHERHISTORY where CLIENTUSERSID = @CLIENTUSERSID order by DATEUSED Desc;
                if @dateUsed is null
                    select top 1 @dateUsed = UpdateDate from ClientUsers where ID = @CLIENTUSERSID;

                RETURN coalesce(@dateUsed, getutcdate());
end