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'.

  • I tried using before but didn't work.can u tell me how to use the distinct to replace SET statement.what fields needs to be distinct?

    thanks.