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 31, 2013 at 9:59 am

    #1637452

    I think if this is your code you may have a clue with isolating where the problem may be rather than providing a entire code dump. But I did find -->

    insert into #tempFPRA exec (@start_Date+','+@end_date)

    ...

    SET @WeekStartDate = (SELECT sdate FROM #tempFPRA)

    If #tempFPRA has more than one row at this point, this will cause the exception you speak of. I don't know if this helps.

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