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 |
|
AustraliaDBA
Starting Member
38 Posts |
 Posted - 2015-03-26 : 19:47:55
|
Hi All,I hope you gus can help me in resolving this issue.I have a datasetLocationCode,Location,Venue,(date,capacity,model), MMMYYrow groupsparent LocationCode then child Location then child Venue.column group MMMYYwhat i want to achieve is for each venue for next 2 month i need date,capacity and modelLCode 1 Location AU Venue MEL Jan15 Feb15 Date capacity model Date capacity model 1 jan15 10 a 1feb 23 bwhat i am getting is LCode ![]() 1 Location AU Venue MEL Jan15 Feb15 Date capacity model Date capacity model 1 jan15 10 a 1feb 23 bso all these records for jan and feb should be in 1 row instead of different row (as returned by dataset). How I can merge records for both MMMYY in one row for a venue. Please adviseformatting of my table disappear after i submit it. couldn't copy the image so it might be hard for u all to understand what i am trying to achive...:(Thanks |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2015-03-27 : 18:14:40
|
Um....What? It would help us to help you if you could supply the actual table definition, at least the relevant columns, some sample code and the expected outputs.
I would rather be the man who bought the Brooklyn Bridge than the one who sold it. -Will Rogers |
 |
|
|
huangchen
Starting Member
37 Posts |
Posted - 2015-04-02 : 05:51:37
|
| unspammed |
|
|
|
|
|
|
display data from different rows