sql server query to combine all rows into one column

Do like this

SELECT Cast(AutoId as varchar) + ',' + FirstName + ',' + LastName FROM PersonalDetail 

In this case the Column names are AutoId, FirstName and LastName and the table name is PersonalDetail.

Remember to use Cast function in case your column data type is not string.

Hope this helps.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Lakn2, if this helps please login to Mark As Answer. | Alert Moderator

hi
your query is not working would you please try with my columns
in my table datatypes are months,employees,departments,products are varchar datatype salesprice is money i had tried woth stuff function but it combine all rows into one column .but i don't want that .i want asif records separately,vijay records ......

Thanks&Regards
LakshmiNarayana Nalluri.

Lakn2, if this helps please login to Mark As Answer. | Alert Moderator

Hi Lakn2,

You can use SQL PIVOT to convert your rows into columns.

http://blog.sqlauthority.com/2008/05/22/sql-server-pivot-table-example/
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/

Thanks and Regards,
Jaydeep Choudhari

Kind Regards,
Jay

Lakn2, if this helps please login to Mark As Answer. | Alert Moderator

hi using pivot table we can show rows as column and column as rows but my requirement is not like that.

Thanks&Regards
LakshmiNarayana Nalluri.

Lakn2, if this helps please login to Mark As Answer. | Alert Moderator

hi SheoNarayan

thank you for your reply i got answer using COALESCE function with some modifications

Thanks&Regards
LakshmiNarayana Nalluri.

Lakn2, if this helps please login to Mark As Answer. | Alert Moderator

SELECG FIRSTNAME+ ','+ SECONDNAME + ', ' + LASTNAME + ', ' + ADDRESS AS NAMES FROM EMPLOYEE

REGARDS

sriram

Lakn2, if this helps please login to Mark As Answer. | Alert Moderator

First Use this Function to Concatenate string according to your table name:

    ALTER FUNCTION [dbo].[fnConcatenate]  (@id INT)

    RETURNS VARCHAR(8000)

    AS

    BEGIN

     

    DECLARE @v VARCHAR(8000)

    SELECT @v =''

     

    SELECT @v =@v + columnname+ ','

    FROM tablename

    where ID= @id

    SELECT @v = LEFT(@v,(LEN(@v)-1))

    return @v

    END

then use Group by to get single record of each employee..
Hope this will work, awaiting for ur reply...

Regards,
Somasundaram

Lakn2, if this helps please login to Mark As Answer. | Alert Moderator

In "Select" query,
such as:

select Id,dbo.fnConcatenate(id) from tablename

group by id,dbo.fnConcatenate(id)

Regards,
Somasundaram

Lakn2, if this helps please login to Mark As Answer. | Alert Moderator