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 |
|
marci
Starting Member
2 Posts |
 Posted - 2014-02-06 : 11:16:50
|
| Table 1:A B C1 1 4.72 1 4.73 1 4.7Table 2:A D E1 1a 1.21 1b 1.82 2a 2.12 2b 2.33 3a 0.6I would like to filter the second table taking one row per ID of Field A (first table) and selecting the rows whose sum of E is equal to the value in field C; in this example the resulting table should be:Table 3:A D E1 1b 1.82 2b 2.33 3a 0.6Total field E = value in field C = 4.7Thanks a lot in advance!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-10 : 09:04:26
|
| Will A values always be continuos?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
marci
Starting Member
2 Posts |
|
|
|
|
|
Selecting groups of rows in a table.. argh!