113 reputation
3
bio website
location
age
visits member for 1 year, 10 months
seen May 24 '13 at 1:19

Mar
28
awarded  Popular Question
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