Posted by info@bodykind.com on 12/17/06 15:14

Yes, I tried his query and received the following error message: -

---------------------------------------------------------------------------------

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.
The statement has been terminated.

---------------------------------------------------------------------------------

David Portas wrote:
> info@bodykind.com wrote:
> > The following query appears to work correctly in SQL server, the only
> > problem (and it is a major problem) is that it sets the value of the
> > stock field to null on every record except the one that it is reducing.
> >
> > Any ideas?
> >
> > ----------------------------------------------------------------------------------------------------
>
> Did you try the query that Gert-Jan posted?
>
> --
> David Portas, SQL Server MVP
>
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
>
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --

[Back to original message]