| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 4 months |
| seen | yesterday | |
| stats | profile views | 2 |
|
Jan 21 |
accepted | SQL Subquery , One to Multiple rows |
|
Jan 18 |
awarded | Student |
|
Jan 18 |
awarded | Scholar |
|
Jan 18 |
comment |
SQL Subquery , One to Multiple rows You saved my life !! :) |
|
Jan 18 |
comment |
SQL Subquery , One to Multiple rows Getting error : cannot use an aggregate or a subquery in an expression used for the group by by list of a group by clause |
|
Jan 18 |
asked | Consolidate does not work with my subquery |
|
Jan 17 |
comment |
SQL Subquery , One to Multiple rows Sorry I am new to stack exchange , dint notice your comment . I am using Microsoft SQL server. I have also edited my question. |
|
Jan 16 |
comment |
SQL Subquery , One to Multiple rows Thanks for your answer , I think the issue is consolidation does not work properly. For example : (without subquery) Component_weight for one consignment is 1.200 and _ic is 42 .But (with subquery) same row splits in to two with component_weight to 0.6 ,0.6 and _ic to 21, 21. Due to subquery my consolidations gets messed up. |
|
Jan 16 |
asked | SQL Subquery , One to Multiple rows |