CODEWITHSUNDEEP
parallel-data-warehouse
Monalisa Rout
Monalisa Rout

Reputation: 19

What is to be used in PDW inplace of identity

What is to be used in PDW inplace of identity or is there any other column which can be used instead of Identity column in Parallel Datawarehousing or any alternative how to generate sequentially increasing column.

Upvotes: 2

Views: 398

Answers (1)

Rob Farley
Rob Farley

Reputation: 15849

Try using ROW_NUMBER() OVER (ORDER BY (SELECT 1)) + (SELECT MAX(ID) FROM dbo.TheTable)

Upvotes: 2

Related Questions