Possible to Insert Multiple Values Into One Variable

[seabaz2000]

Hi
I was just wondering is it possible to Insert Data from many fields into a single variable and then insert the data from that variable into a single field on another table.
Eg
Table 1 Contains
Coding
Testing
Integration
Select the three of them, Place them into a single variable called @variable
and write the data to
Table 2 as
Coding, Integration, Testing

 

[travisbrown]

Easiest way is create a function that concatenates the values, like below.

But unless you are data warehousing... usually a better way is to keep the data normalized with relational tables. I use the function below for reporting and warehousing, but not not for transaction processing.

Create FUNCTION dbo.udf_GetCategoryNames(@contactid INT, 
                    @contactname VARCHAR(30))
RETURNS VARCHAR(2000)
AS
BEGIN
DECLARE @v_out  VARCHAR(2000)
SET @v_out = ''

SELECT @v_out = @v_out + ',' + ca.CategoryName 
FROM tblContacts c INNER JOIN
tblContactCategories cc ON c.ContactID = cc.fContactID INNER JOIN
tblCategories ca ON cc.fCategoryID = ca.CategoryID
WHERE c.ContactId=@contactid 
and c.ContactName = @contactname
   
RETURN(SUBSTRING(@v_out, 3, LEN(@v_out)))
END

 

[ChrisCarroll]

Select @variable= Coding + ',' + Testing + ',' + @Integration from Table1 where ...
Insert into Table2 Values (@variable)

?

 

[travisbrown]

Oh, crap. I read that wrong. My example is for many records into one field. Chris' example is for many fields into one field. Ignore me; pay attention to Chris. Principle is the same, just depends if you want to go up and downs or side to side.