Results 1 to 3 of 3
Apr 27, 2012, 23:30 #1
- Join Date
- Apr 2012
- 0 Post(s)
- 0 Thread(s)
In one table join2 fields and put result into 3rd field (actually want to join 4)
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