Stored Procedures [dbo].[MssWebGetTaskDependencyDates]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
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
Uses