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 |
|
scripter
Starting Member
49 Posts |
 Posted - 2006-11-13 : 02:38:51
|
| http://shotdrive.com/hopefulView.JPGIf you take a look at this screenshot you can see what the two tables look like. all I really need out of table Answers is the field "Answer" which that filed will be repeated multiple times for each question there is. with ASP.Net a Gridview or DetailsView needs to have records that appear as one single rowIs there away to do this. I can provide the quizid and or questionid during runtime if needed |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-13 : 02:43:07
|
| http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.aspPeter LarssonHelsingborg, Sweden |
 |
|
|
scripter
Starting Member
49 Posts |
Posted - 2006-11-13 : 02:57:18
|
| you wanted an example of what the finished product should look likehttp://shotdrive.com/exampletable.JPG take a look at that screenshot of course the top row is representing the column names. The top image is what it currently looks likethe bottom picture is how it needs to be. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-13 : 06:51:44
|
| I think you need to read about Cross-tab reports in sql server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Gridview or DetailsView StoredProcedure or View ne