Home Forums SQL Server 2008 SQL Server Newbies Need Help with the Error 'Subquery returned more than 1 value'. RE: Need Help with the Error 'Subquery returned more than 1 value'.

  • April 15, 2012 at 10:08 pm

    #1473833

    Grass (4/14/2012)

    I think I actually found out which part of the code is giving the error. It is on the first two SET statements when I pass the three variables @Project_Id, @Matter_Id, and Project_Desc.Do you think I can rewrite that section of SET statements then it might work?

    Thanks.

    Yes. Try using Select Distinct or Select 1 in those SET statements.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉