Hi Alvin,
Can you explain why it doesn't work?
>Sergey,
>This will not work .. I have not posted my full sproc..but.. I need to return a subquery as stated on my initial question to get the price of individual ordereditems using factor and base price..
>
>I have use SUM() to get try to get the values for individual items... This returns a value..but an incorrect one.
>
>Server: Msg 512, Level 16, State 1, Line 1
>Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
>
>This is what I get when I remove the SUM keyword...
>
>Any other ideas?
>
>Thanks for your help,
>
>Alvin
--sb--