View Single Post
  #2 (permalink)  
Old 12-26-2006, 10:17 PM
Juan carlos
 
Posts: n/a
Default T-SQL answer. Re: to convert rows to column using SQL?

[sql]
SELECT COLUMNNAME
FROM DBC.COLUMNS
ORDER BY COLUMNID;
[/sql]

* RESULT IN TERADATA SQL
ColumnName
SECT
GARA
BIEN

* I want obtained
SECT;GARA;BIEN;
Reply With Quote