Определенное количество дней

GO
/****** Object:  Table [dbo].[ServedSet]    Script Date: 02.11.2023 16:19:40 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ServedSet](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [ServDate] [datetime] NOT NULL,
    
    [Served_Services] [INT] NOT NULL,
    [Served_Visits] [INT] NULL,
PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
 
GO
 
/****** Object:  Table [dbo].[VisitsSet]    Script Date: 02.11.2023 16:19:40 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VisitsSet](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [TYPE] [SMALLINT] NOT NULL,
    [OpenDate] [datetime] NOT NULL,
    [OpenOrderNumber] [SMALLINT] NULL,
    [OpenOrderDate] [datetime] NULL,
    [CloseDate] [datetime] NULL,
    [CloseOrderNumber] [SMALLINT] NULL,
    [CloseOrderDate] [datetime] NULL,
    
    [Classifier_Visits] [INT] NOT NULL,
    [Visits_Clients] [INT] NOT NULL,
PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
 
GO
INSERT [dbo].[ServedSet] ([Id], [ServDate], [Level], [Volume], [Quantity], [IsMass], [Additional], [IsServed], [ServiceLength], [TripTime], [Comment], [GroupID], [NonAppeared], [NonAppearedProcessed], [CreatedBy], [Created], [ModifiedBy], [Modified], [Served_Employee], [Served_Services], [Served_Visits]) VALUES (10151, CAST(0x0000A08C00000000 AS DateTime), 0, NULL, CAST(2.00 AS DECIMAL(8, 2)), 0, 0, 1, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 51, 2, 150)GO
ALTER TABLE [dbo].[ServedSet] ADD  DEFAULT ((0)) FOR [Served_Employee]
GO
ALTER TABLE [dbo].[ServedSet] ADD  DEFAULT ((0)) FOR [Served_Services]
 
GO
ALTER TABLE [dbo].[VisitsSet] ADD  DEFAULT ((0)) FOR [TYPE]
GO
ALTER TABLE [dbo].[VisitsSet] ADD  DEFAULT (getdate()) FOR [OpenDate]
GO
 
GOGO
ALTER TABLE [dbo].[ServedSet]  WITH CHECK ADD  CONSTRAINT [Served_Visits] FOREIGN KEY([Served_Visits])
REFERENCES [dbo].[VisitsSet] ([Id])
GO
ALTER TABLE [dbo].[ServedSet] CHECK CONSTRAINT [Served_Visits]
 
GO
ALTER TABLE [dbo].[VisitsSet]  WITH CHECK ADD  CONSTRAINT [Classifier_Visits] FOREIGN KEY([Classifier_Visits])
REFERENCES [dbo].[ClassifierSet] ([Id])
GO
ALTER TABLE [dbo].[VisitsSet] CHECK CONSTRAINT [Classifier_Visits]
GO
ALTER TABLE [dbo].[VisitsSet]  WITH CHECK ADD  CONSTRAINT [Visits_Clients] FOREIGN KEY([Visits_Clients])
REFERENCES [dbo].[ClientsSet] ([Id])
GO
ALTER TABLE [dbo].[VisitsSet] CHECK CONSTRAINT [Visits_Clients]
GO