Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sajeeshuni
Starting Member
1 Post |
 Posted - 2011-12-22 : 01:42:42
|
| hi,I've to convert Rows values to column..my exact reguirement is as follows.suppose the result of followng query is select ItemCode, Description1, Description2 from ItemTableItemCode Description1 Description20001 LCD Sony0001 15" Flat0001 Model no A/230002 LED LG0002 17"my requirement is unique itemCode's descriptions to be concatenate.so my requirement is to show the result as ItemCode Description0001 LCD Sony 15" Flat Model no A/230002 LED LG 17"if any one support me as early as possible, it would be a great helpkps |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-22 : 04:06:52
|
| are you looking for t-sql solution or report expresson?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sathibob
Starting Member
2 Posts |
Posted - 2012-01-02 : 08:12:11
|
| www.w3schools.com/sql/default.asp chk out this link and ul definitely get satisfied[url=http://www.graduatepapers.com]dissertation online[/url]|[url=http://www.graduatepapers.com]thesis service[/url] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-02 : 11:59:20
|
quote:
Originally posted by sathibob
www.w3schools.com/sql/default.asp chk out this link and ul definitely get satisfied[url=http://www.graduatepapers.com]dissertation online[/url]|[url=http://www.graduatepapers.com]thesis service[/url]
sorry what has that to be done with OP's original question?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
rows to column conversion