How to Concate more than one rows in one row ?.
-
I Want to display more than one rows data in just one row. My Data is: Code Name 50141 abc 50141 pqr I want Following Data in result. Code name 50141 abc,pqr Please Give me a solution. Thanks & Regards, Fazal
-
I Want to display more than one rows data in just one row. My Data is: Code Name 50141 abc 50141 pqr I want Following Data in result. Code name 50141 abc,pqr Please Give me a solution. Thanks & Regards, Fazal
Create Function to return the all names(seperated by comma) for a given code. Create FUNCTION [dbo].[GetNamesById] ( @code int ) RETURNS varchar(max) AS BEGIN declare @result varchar(max) select @result = COALESCE(@result + ',', '') + [name] from tblCode where code = @code return @result END GO now use following query: select code,dbo.GetNamesById(code) from tblCode group by code above query will give output as: Code name 50141 abc,pqr