SQL Recipes
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers
vertical rows in horizantal vertical rows in horizantal

Reply
 
LinkBack Thread Tools Search this Thread
  #1 (permalink)  
Old 06-30-2008, 11:59 AM
ali ali is offline
Junior Member
  
Join Date: Jun 2008
Posts: 1
ali is on a distinguished road
Default ANY dialect question:

vertical rows in horizantal

ENAME
----------
SMITH
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS

ENAME
----------
JAMES
FORD
MILLER


i want to display above ename follwoing format

SMITH, ALLEN, WARD, JONES, MARTIN, BLAKE, CLARK, SCOTT, KING,TURNER, ADAMS

some body help me
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 07-03-2008, 01:43 AM
Jeremias Spoken Jeremias Spoken is offline
Junior Member
  
Join Date: Jun 2008
Posts: 5
Jeremias Spoken is on a distinguished road
Default ANY answer. Re: vertical rows in horizantal
Hi... I found this link, I hope help you...

Vertical-Horizontal Row

The "easy way" is programming like VBA or .Net or whatever (connections, datasets, datarows, loops,...)

but I'm still search...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 08-27-2008, 10:03 AM
Unregistered
 
Posts: n/a
Default ANY answer. Re: vertical rows in horizantal
Export or copy the col values in MS Excel and Transpose the values, represent them using Concatenate function.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« How to select a record based on 1 field being min/max | number to date »

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 11:00 PM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2008 SQL Recipes

1 2 3 4 5 6 7 8