concatinating and merging
I am trying to take a list of usernames from two columns in a database and add them to an unpopulated column in the same database.
I also need to precede the names with domain name\
The end product would be something like HOME\SMITHA, HOME\SMITHB etc.
The database holds the name data as FAMILY_NAME, FIRST_NAME. I need to concatenate these to be FAMILY_NAMEFirstLetterOfFIRST_NAME.
The DOMAIN name is constant and is not derived from anywhere within the database. i.e. it is just an additional text string. the end result will be a column with data presented as below
I use MS SQL on a Microsoft Server 2008 R3
Many Thanks in anticipation