Hello,
I'm trying to add a column the table below that is a unique identifier of sequential dates.  Stand alone dates would also have a unique identifier.  I've been able to get as far as seeing if a row is part of a 2+ day streak using coalesce, over() and preceding/following... but can't think of a way to tell the streaks apart.

Hi All ,
Can anyone help me with Equivalent in Teradata for Unique Identifier in SQL Server ? Though i can accomodate the values with VARCHAR datatype but when i need unique values to be generated . What will i do in that case ?
 
Thanks in advance !!!