Create a rowID / identity column in a cross-join subquery
I have a table with some of the combinations of two ids. I need to create a unique id for each other combination. Since some combinations already exist, I can’t just use an identifier column.
SQL: Trying to create a rowID / identity column in a cross-join subquery
I would like to ensure I have a unique id for each combination of two other ids. Some combinations already exist, so I can’t just use an identifier column.