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.
Asked
Active
Viewed 381 times
1
-
why does it have to be sequential increasing and not guid – Batavia Oct 29 '14 at 17:44
-
Because guids aren't supported. – Rob Farley Apr 16 '15 at 16:03
1 Answers
1
Try using ROW_NUMBER() OVER (ORDER BY (SELECT 1)) + (SELECT MAX(ID) FROM dbo.TheTable)
Rob Farley
- 15,625
- 5
- 44
- 58