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 |
|
sardinka
Posting Yak Master
142 Posts |
 Posted - 2006-08-28 : 13:23:44
|
| My result from query:Name Coverage datesSmith 01/01/2000-01/01/2002Smith 01/01/2002-01/01/2001brown 01/01/2003-01/01/2004I need to display data like this:name Coverage dates1 Coverage dates2Smith 01/01/2000-01/01/2002 01/01/2002-01/01/2001brown 01/01/2003-01/01/2004how do I do this? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-28 : 14:07:13
|
| Search this site for PIVOT or CROSSTAB reports.Peter LarssonHelsingborg, Sweden |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
|
|
sardinka
Posting Yak Master
142 Posts |
Posted - 2006-08-28 : 15:14:14
|
| If I use that approach it may take a while to get a result bakc since I am executing against a huge db. |
|
|
|
sardinka
Posting Yak Master
142 Posts |
Posted - 2006-08-28 : 15:22:30
|
| If I use that approach it may take a while to get a result bakc since I am executing against a huge db. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-29 : 01:14:05
|
| How many columns do you expect, at most?Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
help with query result