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 |
|
homebrew
Posting Yak Master
114 Posts |
 Posted - 2008-11-20 : 16:20:05
|
| I'm searching rows that may have multiple occurances of the data I want, and I want to display it in columns ... Is it possible ?? I think I saw an example a long time ago but can't find it.For example, in Table_A, Col_A = 'Salesman Tom spoke with Cathy and said he would call back on Monday' Col_B = '2008-11-20'I want to search for Tom or Cathy, and display the results asDate Name---------- ----------2008-11-20 Tom2008-11-20 CathyAny ideas ?? |
|
|
|
|
|
How to Pivot Data into Columns ?