I'm trying to create a Unique ID from several fields in my table by combining several rows into a single row.
Here's a select statement that (I think) is outputting what I want:
SELECT (CAST(BIRTH_DATE as VARCHAR(10))+(CAST(BEGIN_DATE as VARCHAR(10)))+RACE+SEX)
I would like to take the output of the above select and insert it into the MyID field in MyTable_t.
Any help will be greatly appreciated - thanks!