
[dbo].[MssWebGetTaskDependencyDates]
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