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 |
|
lane0618
Posting Yak Master
134 Posts |
 Posted - 2002-02-05 : 11:41:42
|
| I have a query that returns three results in a column. I want the results to be in a row seperated by commas like: data23, data46, data51Is this possible? I want to then use the results of this for inputs into a dynamic SQL query.Thanks in Advance!Lane |
|
|
butlermi_11
Starting Member
10 Posts |
Posted - 2002-02-05 : 11:46:50
|
| Check out this article to get you started.[url]http://www.sqlteam.com/item.asp?ItemID=256[/url] |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-05 : 12:26:14
|
Maybe Graz could add a feature whereby any post with comma or csv gets automatically redirected to the article .For the second part - could you use the 3 results in a temp table or derived table.Sounds like you have a field in your table with 3 values separated by commas - could you put these a separate records on a different table?==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-02-05 : 12:43:17
|
quote:
Maybe Graz could add a feature whereby any post with comma or csv gets automatically redirected to the article.
I've really, really considered something like that!===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
lane0618
Posting Yak Master
134 Posts |
Posted - 2002-02-05 : 14:15:03
|
| Thanks for the info. I was able to figure it out from the article.Thanks!Lane |
|
|
|
|
|
|
Query results in a row seperated by commas?