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 |
|
SQL360
Starting Member
20 Posts |
 Posted - 2008-10-22 : 13:25:17
|
| On the Report I need to have columns below:Date A B C D E F G H I J K L1. Row is dependent on whatever date user entered when creating a report.2. Will be selecting value for A, B, C, D, E from Table X --static data (cannot edit)3. Need to join four tables T1, T2, T3, T4 to get the value for K, L --static data (cannot edit)4. Values for F, G, H, I, J are coming from user's manual data entry on the same report page above. These values are editable. If it is a new insert it will insert the value for F, G, H, I, J to table T5 and T6. If it is a update than it must update the value on correct row within table T5 and T6.My current apporach by creating several local temp tables and joining is not producing the desired result.Please advise me of best approach or few queries to handle the problem above. Thank you. SQL360 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-22 : 13:44:11
|
| show some sample data from your tables and explain what you want to see as report output. |
 |
|
|
|
|
|
|
|
Query