Alright, so Im trying to build a composite key to join to another table that is storing comments on the rows. The report feeding my table is run daily. The same row can show up multiple days and we looking to create a key based on the first consecutive instance the item appeared.
Basically Im looking to concatenate the existing composite_key and the first consecutive report_date
H/A please help and advise
YOLO. Swag. Whatever. Fuck it. Lets do this.