This is my first post. I am not a programmer but I like to play with databases (I have access to them as part of my real job - don't worry I only ever work in test environments)
I have a table in a sql 2008 database. I want to create a unqiue identity for each record based on the information in 4 fields combined.
After a copy of data (bcp - just learnt how to do that) into the table I have
Field 1 = A
Field 2 = B
Field 3 = C
Field 4 = 1
Field 5 = NULL
work some programming magic (this is what I want from the forum)
Field 5 = A B C 1
This is for all the records - maximum will be about 200 records at any one time.
This is to run in a stored procedure.
As, I mentioned I am not a programmer. I have spent many hours trying to do this and just don't know what I am doing.
Can someone give me the answer. I have browsed the web and forums and can't find out how to do it.
Thanks in anticipation