create procedure [dbo].[MssWebGetTaskDependencyDates]
as
begin
set nocount on
    select
        Id = DependencyDateID,
        [Name] = DependencyDate.Description,
        [IdentifierType] = ToDoIdentifierType.Description
    from DependencyDate
    inner join ToDoIdentifierType on ToDoIdentifierType.ToDoIdentifierTypeID = DependencyDate.ToDoIdentifierTypeFID     
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetTaskDependencyDates] TO [MssExec]
GO