USE tempdb
GO
SET NOCOUNT ON
GO
IF OBJECT_ID('tempdb..#tmp') IS NOT NULL DROP TABLE #tmp
GO
CREATE TABLE #tmp
(
rowId INT IDENTITY(0,1) PRIMARY KEY,
yourSpecialId AS FORMAT( uniqueConstraintP1, 'kyyMMdd' ) + ' ' + FORMAT( CAST( ( ( rowId ) % 100 ) AS INT ), '00' ),
uniqueConstraintP1 DATE DEFAULT GETDATE(),
uniqueConstraintP2 AS ( rowId ) % 100,
uniqueConstraintP3 AS DATEPART (dayOfYear, GETDATE() )
)
GO
-- Column cannot be used in an index or statistics or as a partition key because it is non-deterministic.