Home Forums SQL Server 2005 SQL Server Newbies If Statement RE: If Statement
John Mitchell-245523
SSC Guru
Points: 148809
More actions
January 28, 2014 at 3:29 am
#1683845
OK, so fix that. When you set the value of a scalar variable, you can only pass a single value to it. If the SELECT statement you use to set it returns more than one row, you'll get that error.
John