SQL Exception Explanation

See more:

C#

SQL

stored-procedure

I am getting an exception thrown that doesn't make any sense to me - and would like some help, someone to explain why this is being thrown, and what I need to do to solve the problem ...

In my C# code ...

 SqlConnection thisConnection = new SqlConnection(@"Network Library=DBMS;Data Source=AZ75;database=MyDev;User id=usrread;Password=password;";);
try
{
    thisConnection.Open();
}
catch (Exception e)
{
    Console.WriteLine(e.ToString());
}

 string sDocIDsList = "202+211, 30+30";

 SqlDataAdapter da = new SqlDataAdapter();
 DataSet ds = new DataSet();

 SqlCommand tCommand = new SqlCommand();
 tCommand.CommandText = "GetReport";
 tCommand.Connection = thisConnection;
 tCommand.CommandType = CommandType.StoredProcedure;

 da.SelectCommand = tCommand;

 tCommand.Parameters.Add(new SqlParameter("@Return_Value", SqlDbType.Int));
 tCommand.Parameters["@Return_Value"].Direction = ParameterDirection.ReturnValue;

 tCommand.Parameters.Add(new SqlParameter("@DocIDsList", SqlDbType.VarChar));
 tCommand.Parameters["@DocIDsList"].Value = sDocIDsList;
 tCommand.Parameters["@DocIDsList"].Direction = ParameterDirection.Input;

 ds.Clear();

 try
 {
     da.Fill(ds);
 }
 catch (SqlException e)
 {
     Console.WriteLine(e.Message);
 }

When executing the da.Fill command - the system throws an exception, with the following text:


"Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression"


HELP !!! What does this mean???