Skip to content

Instantly share code, notes, and snippets.

@vinijmoura

vinijmoura/TeamSettingsIterationCapacities.sql

Created August 12, 2021 23:31
Show Gist options
  • Save vinijmoura/444193a4ceb2ee8cad293886ec18b201 to your computer and use it in GitHub Desktop.
Save vinijmoura/444193a4ceb2ee8cad293886ec18b201 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
TeamSettingsIterationCapacities.sql
CREATE TABLE [dbo].[TeamSettingsIterationCapacities](
[TeamProjectName] [varchar](100) NOT NULL,
[TeamName] [varchar](100) NOT NULL,
[IterationName] [varchar](100) NOT NULL,
[IterationStartDate] [datetime] NOT NULL,
[IterationFinishDate] [datetime] NOT NULL,
[totalIterationCapacityPerDay] DECIMAL(10,2) NOT NULL,
[totalIterationDaysOff] DECIMAL(10,2) NOT NULL
)
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment