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 12, 2012 at 8:13 am

    #1472605

    suhailtajraja (4/12/2012)

    Hi Vinu:

    I checked entity_id,and user_id are retruning multiple records in a table. So, what field do I need in my statement as a distinct.Are these entity_id

    ,user_id ones? or something else.

    Thanks.

    can you post DDL and sample data. that will really help us out in figuring out what will cut the multiple rows. also there may be a way to get rid of the cursor which we will see once you post sample data and DDL statements.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]