Home Forums SQL Server 2005 Development Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. RE: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

  • July 15, 2013 at 2:08 am

    #1632347

    Where in the code listing does the error come from?

    Normally the reason for this error is self explanatory - you tried to assign a single value to a parameter, but got two back. SQL only wants one value - so throws the error.

    Unfortunately it can take a few attempts (from my experience) in resolving this.

    You need to work out which query the error is coming from then examine the underlying data to work out why.

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx