[dbo].[GetValidationByKey]
CREATE PROCEDURE [dbo].[GetValidationByKey]
@inNameKey varchar(16)
as
set nocount on
select top (1)
KeyValue
from Validation
where NameKey = @inNameKey and
EffectiveDateUtc <= getutcdate()
order by NameKey asc, EffectiveDateUtc desc, ExpirationDateUtc desc
GO
GRANT EXECUTE ON [dbo].[GetValidationByKey] TO [MssExec]
GO