About SQL Query

[Sasmi_Office]

Hi, I am working on MSSQL 2005 I want query help Suppose in table t1, I have field f1 and f2 now the details in the tables are as folows: f1, f2 1 a 1 b 1 c 1 d 1 e I want in my select query I should get the information as follows: f1 f2 1 a,b,c,d,e Can I get this Please help

[Wendelius]

So if the a,b,c,d,e is a comma separated list in one column, you could write a function to concatenate the result and return it to the query. For details, see: CREATE FUNCTION[^]

The need to optimize rises from a bad design.My articles[^]

[PunkIsNotDead]

hi!!!!!!! maybe you can use PIVOT[^] statements in SQL server! It's a very useful tool! good luck! ;)