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 |
|
ekb18c
Starting Member
18 Posts |
 Posted - 2007-06-20 : 12:50:54
|
| I have a table[employee]name - office address - office city - office zipData:mark johnson - 123 stone street - washington - 13453mark johnson - 456 sw east street - miami - 21345mark johnson - 234 67 street - new jersey - 23423John lee - 3425 46 street - new york - 10034fred mack - 1 east chester road - boston - 33533How do I get a query to do this..Mark Johnson - 123 stone street~456 sw east street~234 67 street the ~ seperates the address data points.Can someone shed some light? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-21 : 10:27:59
|
| Note that if the concatenated string exceeds 8000 characters you need to use more than one variableWhere do you want to show data?MadhivananFailing to plan is Planning to fail |
 |
|
|
ekb18c
Starting Member
18 Posts |
Posted - 2007-06-21 : 10:59:25
|
| thanks! that helped! |
|
|
|
|
|
|
Query with repeating data