Skip to main content
Skip table of contents

Offer history tables partitioning

Overview

This document shows the partition logic that has been created and assigned to all of the Offer History tables within a new Redpoint CDP implementation.

Partition creation logic

The given partitions are created based on timestamp and will assign records to each partition on a monthly basis.

/****** Object: PartitionFunction [PF_Offer_HistoryP] ******/
CREATE PARTITION FUNCTION PF_Offer_HistoryP AS RANGE LEFT FOR VALUES (N'2020-01-01T00:00:00.000', N'2020-02-01T00:00:00.000', N'2020-03-01T00:00:00.000', N'2020-04-01T00:00:00.000', N'2020-05-01T00:00:00.000', N'2020-06-01T00:00:00.000', N'2020-07-01T00:00:00.000', N'2020-08-01T00:00:00.000', N'2020-09-01T00:00:00.000', N'2020-10-01T00:00:00.000', N'2020-11-01T00:00:00.000', N'2020-12-01T00:00:00.000', N'2021-01-01T00:00:00.000', N'2021-02-01T00:00:00.000', N'2021-03-01T00:00:00.000', N'2021-04-01T00:00:00.000', N'2021-05-01T00:00:00.000', N'2021-06-01T00:00:00.000', N'2021-07-01T00:00:00.000', N'2021-08-01T00:00:00.000', N'2021-09-01T00:00:00.000', N'2021-10-01T00:00:00.000', N'2021-11-01T00:00:00.000', N'2021-12-01T00:00:00.000', N'2022-01-01T00:00:00.000', N'2022-02-01T00:00:00.000', N'2022-03-01T00:00:00.000', N'2022-04-01T00:00:00.000', N'2022-05-01T00:00:00.000', N'2022-06-01T00:00:00.000', N'2022-07-01T00:00:00.000', N'2022-08-01T00:00:00.000', N'2022-09-01T00:00:00.000', N'2022-10-01T00:00:00.000', N'2022-11-01T00:00:00.000', N'2022-12-01T00:00:00.000', N'2023-01-01T00:00:00.000', N'2023-02-01T00:00:00.000', N'2023-03-01T00:00:00.000', N'2023-04-01T00:00:00.000', N'2023-05-01T00:00:00.000', N'2023-06-01T00:00:00.000', N'2023-07-01T00:00:00.000', N'2023-08-01T00:00:00.000', N'2023-09-01T00:00:00.000', N'2023-10-01T00:00:00.000', N'2023-11-01T00:00:00.000', N'2023-12-01T00:00:00.000', N'2024-01-01T00:00:00.000', N'2024-02-01T00:00:00.000', N'2024-03-01T00:00:00.000', N'2024-04-01T00:00:00.000', N'2024-05-01T00:00:00.000', N'2024-06-01T00:00:00.000', N'2024-07-01T00:00:00.000', N'2024-08-01T00:00:00.000', N'2024-09-01T00:00:00.000', N'2024-10-01T00:00:00.000', N'2024-11-01T00:00:00.000', N'2024-12-01T00:00:00.000', N'2025-01-01T00:00:00.000', N'2025-02-01T00:00:00.000', N'2025-03-01T00:00:00.000', N'2025-04-01T00:00:00.000', N'2025-05-01T00:00:00.000', N'2025-06-01T00:00:00.000', N'2025-07-01T00:00:00.000', N'2025-08-01T00:00:00.000', N'2025-09-01T00:00:00.000', N'2025-10-01T00:00:00.000', N'2025-11-01T00:00:00.000', N'2025-12-01T00:00:00.000', N'2026-01-01T00:00:00.000', N'2026-02-01T00:00:00.000', N'2026-03-01T00:00:00.000', N'2026-04-01T00:00:00.000', N'2026-05-01T00:00:00.000', N'2026-06-01T00:00:00.000', N'2026-07-01T00:00:00.000', N'2026-08-01T00:00:00.000', N'2026-09-01T00:00:00.000', N'2026-10-01T00:00:00.000', N'2026-11-01T00:00:00.000', N'2026-12-01T00:00:00.000', N'2027-01-01T00:00:00.000', N'2027-02-01T00:00:00.000', N'2027-03-01T00:00:00.000', N'2027-04-01T00:00:00.000', N'2027-05-01T00:00:00.000', N'2027-06-01T00:00:00.000', N'2027-07-01T00:00:00.000', N'2027-08-01T00:00:00.000', N'2027-09-01T00:00:00.000', N'2027-10-01T00:00:00.000', N'2027-11-01T00:00:00.000', N'2027-12-01T00:00:00.000')
GO

/****** Object: PartitionScheme [S_offer_historyP] ******/
CREATE PARTITION SCHEME [S_offer_historyP] AS PARTITION [PF_Offer_HistoryP] TO ([PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY])
GO

Create statements for offer history tables

Each of the following scripts will be part of the DDL for a new tenant creation, which will apply the above partitions to each of the tables.

/****** Object: Table [rpi].[OfferHistory] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [rpi].[OfferHistory](
[DataflowID] [int] NOT NULL,
[OutputID] [int] NULL,
[WorkflowID] [int] NOT NULL,
[OutputName] nvarchar NOT NULL,
[ChannelExecutionID] [int] NOT NULL,
[OfferActivityName] nvarchar NULL,
[ChannelName] nvarchar NOT NULL,
[OfferName] nvarchar NULL,
[OfferChannelSubName] nvarchar NULL,
[Timestamp] [datetime] NOT NULL,
[RPContactID] [bigint] IDENTITY(1,1) NOT NULL,
[AddressKey] nvarchar NULL,
[Selected] [bit] NULL,
[OfferTemplateInstanceID] [int] NULL,
[ADDRESS_ID] [bigint] NULL,
[EMAIL_ID] [bigint] NULL,
[EMPLOYEE_ID] nvarchar NULL,
[HOME_PHONE_ID] [bigint] NULL,
[HOUSEHOLD_ID] [bigint] NULL,
[MOBILE_PHONE_ID] [bigint] NULL,
[INDIVIDUAL_ID] [bigint] NULL,
[INDIVIDUAL_BUSINESS_UNIT_ID] [bigint] NULL,
[RPIResolutionKey] [bigint] NULL,
[CUSTOMER_ACCOUNT_ID] [bigint] NULL,
[PARTY_PROFILE_ID] [bigint] NULL,
[MAIN_INDIVIDUAL_ID] [bigint] NULL,
[MAIN_PARTY_PROFILE_ID] [bigint] NULL,
[MAIN_INDIVIDUAL_BUSINESS_UNIT_ID] [bigint] NULL,
[BUSINESS_UNIT_CODE] nvarchar NULL,
[LOYALTY_ACCOUNT_ID] [bigint] NULL,
CONSTRAINT [PK_OfferHistory] PRIMARY KEY NONCLUSTERED
(
[RPContactID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object: Index [cci_OfferHistory_P] ******/
CREATE CLUSTERED COLUMNSTORE INDEX [cci_OfferHistory_P] ON [dbo].[OfferHistory] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON S_offer_historyP
GO

/****** Object: Index [IX_OfferHistory_DataflowID] ******/
CREATE CLUSTERED INDEX [IX_OfferHistory_DataflowID] ON [rpi].[OfferHistory]
(
[DataflowID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, DROP_EXISTING = OFF, ONLINE = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO


/ Object: Table [rpi].[OfferHistory_Content] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [rpi].[OfferHistory_Content](
[RPContactID] [bigint] NOT NULL,
[ChannelExecutionID] [int] NOT NULL,
[OfferTemplateInstanceID] [int] NULL,
[OfferCode] [int] NULL,
CONSTRAINT [PK_OfferHistory_Content] PRIMARY KEY CLUSTERED
(
[RPContactID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object: Index [cci_OfferHistory_P] ******/
CREATE CLUSTERED COLUMNSTORE INDEX [cci_OfferHistory_P] ON [dbo].[OfferHistory_Content] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON S_offer_historyP
GO

/****** Object: Table [rpi].[OfferHistory_Content_Meta] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [rpi].[OfferHistory_Content_Meta](
[ChannelExecutionID] [int] NOT NULL,
[OfferCode] [int] NOT NULL,
[OfferTemplateInstanceID] [int] NOT NULL,
[AssetName] nvarchar NOT NULL,
[Metadata] nvarchar NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object: Index [cci_OfferHistory_P] ******/
CREATE CLUSTERED COLUMNSTORE INDEX [cci_OfferHistory_P] ON [dbo].[OfferHistory_Content_Meta] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON S_offer_historyP
GO

/****** Object: Table [rpi].[OfferHistory_Details] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [rpi].[OfferHistory_Details](
[ChannelExecutionID] [int] NOT NULL,
[TriggerExecutionID] [int] NULL,
[OfferExecutionID] [int] NULL,
[FirstExecutionDate] [datetime] NOT NULL,
[LastExecutionDate] [datetime] NOT NULL,
[ExportFileName] nvarchar NULL,
[ChannelName] nvarchar NULL,
[DeliveryMethod] nvarchar NULL,
[ActivityName] nvarchar NULL,
[ActivitySubName] nvarchar NULL,
[InteractionName] nvarchar NULL,
[OfferName] nvarchar NULL,
[TargetCount] [bigint] NULL,
[SeedCount] [int] NULL,
[IsRolledBack] [bit] NOT NULL,
[RolledBackDate] [datetime] NULL,
[MessageListInstanceID] [int] NULL,
[MessageID] [int] NULL,
[MessageListName] nvarchar NULL,
[MessageName] nvarchar NULL,
CONSTRAINT [PK_OfferHistory_Details] PRIMARY KEY CLUSTERED
(
[ChannelExecutionID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object: Index [cci_OfferHistory_P] ******/
CREATE CLUSTERED COLUMNSTORE INDEX [cci_OfferHistory_P] ON [dbo].[OfferHistory_Details] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON S_offer_historyP
GO

/****** Object: Table [rpi].[OfferHistory_Meta] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [rpi].[OfferHistory_Meta](
[DataflowID] [int] NOT NULL,
[OutputID] [int] IDENTITY(1,1) NOT NULL,
[WorkflowID] [int] NOT NULL,
[OutputName] nvarchar NOT NULL,
[CampaignCode] nvarchar NULL,
[CampaignName] nvarchar NULL,
[CampaignDesc] nvarchar NULL,
[PromoCode] nvarchar NULL,
[PromoName] nvarchar NULL,
[PromoStartDate] [datetime] NULL,
[PromoEndDate] [datetime] NULL,
[OfferCode] nvarchar NULL,
[OfferValue] nvarchar NULL,
[DropDate] [datetime] NULL,
[IsControl] nvarchar NULL,
[UTM_Source] nvarchar NULL,
[UTM_Content] nvarchar NULL,
[UTM_Medium] nvarchar NULL,
[UTM_Campaign] nvarchar NULL,
[UTM_Term] nvarchar NULL,
[SubjectLine] nvarchar NULL,
[PreHeader] nvarchar NULL,
[MessageIntent] nvarchar NULL,
CONSTRAINT [PK_OfferHistory_Meta] PRIMARY KEY CLUSTERED
(
[OutputID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object: Index [cci_OfferHistory_P] ******/
CREATE CLUSTERED COLUMNSTORE INDEX [cci_OfferHistory_P] ON [dbo].[OfferHistory_Meta] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON S_offer_historyP
GO

/****** Object: Table [rpi].[OfferHistory_Meta_SandBox] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [rpi].[OfferHistory_Meta_SandBox](
[DataflowID] [int] NOT NULL,
[OutputID] [int] IDENTITY(1,1) NOT NULL,
[WorkflowID] [int] NOT NULL,
[OutputName] nvarchar NOT NULL,
[CampaignCode] nvarchar NULL,
[CampaignName] nvarchar NULL,
[CampaignDesc] nvarchar NULL,
[PromoCode] nvarchar NULL,
[PromoName] nvarchar NULL,
[PromoStartDate] [datetime] NULL,
[PromoEndDate] [datetime] NULL,
[OfferCode] nvarchar NULL,
[OfferValue] nvarchar NULL,
[DropDate] [datetime] NULL,
[IsControl] nvarchar NULL,
[UTM_Source] nvarchar NULL,
[UTM_Content] nvarchar NULL,
[UTM_Medium] nvarchar NULL,
[UTM_Campaign] nvarchar NULL,
[UTM_Term] nvarchar NULL,
[SubjectLine] nvarchar NULL,
[PreHeader] nvarchar NULL,
[MessageIntent] nvarchar NULL,
CONSTRAINT [PK_OfferHistory_Meta_SandBox] PRIMARY KEY CLUSTERED
(
[OutputID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object: Index [cci_OfferHistory_P] ******/
CREATE CLUSTERED COLUMNSTORE INDEX [cci_OfferHistory_P] ON [dbo].[OfferHistory_Meta_SandBox] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON S_offer_historyP
GO

/****** Object: Table [rpi].[OfferHistory_RealtimeControl] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [rpi].[OfferHistory_RealtimeControl](
[ProcessID] nvarchar NOT NULL,
[ChannelExecutionID] [int] NOT NULL,
[WorkflowID] [int] NOT NULL,
[Timestamp] [datetime] NOT NULL,
[OfferHistorySchema] nvarchar NOT NULL,
[OfferHistoryTable] nvarchar NOT NULL,
[MetaTable] nvarchar NOT NULL,
[KeyField] nvarchar NOT NULL,
[Status] nvarchar NOT NULL,
[IsProcessed] [bit] NOT NULL,
[RollbackRequested] [bit] NOT NULL,
[RollbackProcessed] [bit] NOT NULL,
CONSTRAINT [PK_OfferHistory_RealtimeControl] PRIMARY KEY CLUSTERED
(
[ProcessID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object: Index [cci_OfferHistory_P] ******/
CREATE CLUSTERED COLUMNSTORE INDEX [cci_OfferHistory_P] ON [dbo].[OfferHistory_RealtimeControl] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON S_offer_historyP
GO

/****** Object: Table [rpi].[OfferHistory_SandBox] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [rpi].[OfferHistory_SandBox](
[DataflowID] [int] NOT NULL,
[OutputID] [int] NULL,
[WorkflowID] [int] NOT NULL,
[OutputName] nvarchar NOT NULL,
[ChannelExecutionID] [int] NOT NULL,
[OfferActivityName] nvarchar NULL,
[ChannelName] nvarchar NOT NULL,
[OfferName] nvarchar NULL,
[OfferChannelSubName] nvarchar NULL,
[Timestamp] [datetime] NOT NULL,
[RPContactID] [bigint] IDENTITY(1,1) NOT NULL,
[AddressKey] nvarchar NULL,
[Selected] [bit] NULL,
[OfferTemplateInstanceID] [int] NULL,
[ADDRESS_ID] [bigint] NULL,
[EMAIL_ID] [bigint] NULL,
[EMPLOYEE_ID] nvarchar NULL,
[HOME_PHONE_ID] [bigint] NULL,
[HOUSEHOLD_ID] [bigint] NULL,
[MOBILE_PHONE_ID] [bigint] NULL,
[INDIVIDUAL_ID] [bigint] NULL,
[INDIVIDUAL_BUSINESS_UNIT_ID] [bigint] NULL,
[RPIResolutionKey] [bigint] NULL,
[CUSTOMER_ACCOUNT_ID] [bigint] NULL,
[PARTY_PROFILE_ID] [bigint] NULL,
[MAIN_INDIVIDUAL_ID] [bigint] NULL,
[MAIN_PARTY_PROFILE_ID] [bigint] NULL,
[MAIN_INDIVIDUAL_BUSINESS_UNIT_ID] [bigint] NULL,
[BUSINESS_UNIT_CODE] nvarchar NULL,
[LOYALTY_ACCOUNT_ID] [bigint] NULL,
CONSTRAINT [PK_OfferHistory_SandBox] PRIMARY KEY NONCLUSTERED
(
[RPContactID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object: Index [cci_OfferHistory_P] ******/
CREATE CLUSTERED COLUMNSTORE INDEX [cci_OfferHistory_P] ON [dbo].[OfferHistory_SandBox] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON S_offer_historyP
GO

/****** Object: Index [IX_OfferHistory_SandBox_DataflowID] ******/
CREATE CLUSTERED INDEX [IX_OfferHistory_SandBox_DataflowID] ON [rpi].[OfferHistory_SandBox]
(
[DataflowID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, DROP_EXISTING = OFF, ONLINE = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO

/****** Object: Table [rpi].[OfferHistory_States] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [rpi].[OfferHistory_States](
[EventID] [bigint] IDENTITY(1,1) NOT NULL,
[RPContactID] [bigint] NOT NULL,
[ChannelExecutionID] [int] NOT NULL,
[FulfillmentState] nvarchar NOT NULL,
[EventName] nvarchar NULL,
[MetricValue] [decimal](18, 6) NULL,
[Timestamp] [datetime] NOT NULL,
CONSTRAINT [PK_OfferHistory_States] PRIMARY KEY CLUSTERED
(
[EventID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object: Index [cci_OfferHistory_P] ******/
CREATE CLUSTERED COLUMNSTORE INDEX [cci_OfferHistory_P] ON [dbo].[OfferHistory_States] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON S_offer_historyP
GO

/****** Object: Table [rpi].[OfferHistory_Web] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [rpi].[OfferHistory_Web](
[INDIVIDUAL_BUSINESS_UNIT_ID] [bigint] NOT NULL,
[ContentID] [int] NOT NULL,
[Slot1] [int] NULL,
[Slot2] [int] NULL,
[Slot3] [int] NULL,
[Slot4] [int] NULL,
[Slot5] [int] NULL,
[Slot6] [int] NULL,
[Slot7] [int] NULL,
[Slot8] [int] NULL,
[Slot9] [int] NULL,
[Slot10] [int] NULL,
[RPIResolutionKey] [bigint] NULL,
[CUSTOMER_ACCOUNT_ID] [bigint] NULL,
[LOYALTY_ACCOUNT_ID] [bigint] NULL,
CONSTRAINT [PK_OfferHistory_Web] PRIMARY KEY CLUSTERED
(
[INDIVIDUAL_BUSINESS_UNIT_ID] ASC,
[ContentID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object: Index [cci_OfferHistory_P] ******/
CREATE CLUSTERED COLUMNSTORE INDEX [cci_OfferHistory_P] ON [dbo].[OfferHistory_Web] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON S_offer_historyP
GO

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close