I have Table A with 3 cloumns x,y,z Varchars.(data is a first middle lastname stuff)
I have Table b that is supposed to Store the Concatenated result of (xyz)

I have a stored procedure that is supposed to move through Table A and read the 3 columns then insert the result to table b. It works for 1 record only then stops, I am unsure how to get it to do more than one record.

Code:
CREATE  PROCEDURE namecat @newname nvarchar(50)
AS

	select  @newname = (X + Y + Z) from TableA
	Insert into  TableB (xyz) Values (@newname)
GO
Sorry for the Newish question but im thiking a Cursor is needed?