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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-06-07 : 11:23:40
|
| Mita writes "I have got tables for 3 different years.. each table has got about 800000 rows.. i need to join these tables to create a report here is the sample dataTable 1comp_name ID Year Volume_for_jan Vol_for Feb.....Vol_for_decAQQ 1 2000 55 44.............554 3 33 2222...........2224Table 2comp_name ID Year Volume_for_jan Vol_for Feb.....Vol_for_decCCC 33 2001 44 55.............66....Now i want to create a report which is something like this..Comp_name Id Year Vol_jan ...vol_feb.................What is the best way to do this???Please help.I tried to create a report in business intelligence studio but it takes ages to process and at the end nothing happens..i dont have any indexes or keys on these tables..How do i achieve this???Waiting for the replyregardsMita" |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Performance issue 