Hello all -
I'm trying to populate a column during a select statement
such that the first row in the answer set will have a
value of '1' and each subsequent row in the answer set
will have a value of the preceding row's value + '1'.
I'm coming from the Teradata world and my standard query
to do this cannot work because apparently there isn't
a 'ZEROIFNULL' command in TRANSACT-SQL.
Does anyone have a routine on how to do this they could
post? It will save me some research time.
Also, is there a way without using ...