Subquery returned more than 1 value. This is not permitted when the subquery follows or when the subquery is used as an expression.

HI

below is my SP

ALTER  procedure [dbo].[ViewState3]
@id nvarchar(10)
AS
BEGIN

SELECT
     
          ,Name
          ,substring(District+' - '+AddressN,0,60) as addressN
          ,(select Tell+'-'+Code from House_Info ) as TellS1

    FROM Estate_p
    WHERE id=@id

END

Below error happen

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.  Exception Details: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. Source Error: 

Line 93:        _cn.Open();
Line 94:        SqlDataReader _dr1 = _cmd1.ExecuteReader();
Line 95: while (_dr1.Read()) Line 96:        {
Line 97: 

IS SP right?

Best Regards

NEDA