Follow up to my above post, here's my code

Create Table

CREATE TABLE TestPartition15m(

[Id] [BIGINT] NOT NULL,

[DateCreated] [DATETIME2](3) NOT NULL,

[Amount] [INT] NOT NULL,

[SupplierId] [INT] NOT NULL,

[PartitionId] AS (CONVERT([TINYINT],ABS(DATEDIFF(DAY,CONVERT([DATE],'20000101',(112)),[DateCreated])%(14))+(1),(0))) PERSISTED NOT NULL,

CONSTRAINT [pk_TestPart] PRIMARY KEY CLUSTERED

(

[Id] ASC,

[PartitionId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, DATA_COMPRESSION = PAGE) ON [FifteenMonthRetentionScheme]([PartitionId])

) ON [FifteenMonthRetentionScheme]([PartitionId])

GO

FUnction & Scheme here:

CREATE PARTITION FUNCTION [FifteenMonthRetention](TINYINT) AS RANGE LEFT FOR VALUES (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)

GO

CREATE PARTITION SCHEME [FifteenMonthRetentionScheme] AS PARTITION [FifteenMonthRetention] TO ([PFGDATA1], [PFGDATA2], [PFGDATA3], [PFGDATA4], [PFGDATA5], [PFGDATA1], [PFGDATA2], [PFGDATA3], [PFGDATA4], [PFGDATA5], [PFGDATA1], [PFGDATA2], [PFGDATA3], [PFGDATA4], [PFGDATA5])

GO

I enter data into the table above for last fifteen months, I would expect to see a row in each partition? Any reason why not?

TIA

qh