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

Create PRoc uspCheckSubscription
@Userid int,@HasSubscrip bit out, @SubscripID int out,@HasSubscripLife bit out
AS
BEGIN
IF EXISTS (Select SubscriptionId from TblSubscription where UserId = @Userid and IsActive = 1)
BEGIN
Set @HasSubscrip = 1
Set @SubscripID = (Select SubscriptionId from TblSubscription where UserId = @Userid and IsActive = 1)
IF EXISTS (Select SubscriptionId from TblSubscription where UserId = @Userid and IsActive = 1 and GETDATE() between StartDate and FinishDate)
BEGIN
SET @HasSubscripLife = 1
END
ELSE
BEGIN
SET @HasSubscripLife = 0
UPDATE TblSubscription SET IsActive = 0 WHERE UserId = @Userid and IsActive = 1
END
END
ELSE
BEGIN
Set @HasSubscrip = 0
SET @HasSubscripLife = 0
END
END

private void GetSuscriptionetials(int Userid)
    {
        int SubscripID;
        Boolean HasSubscrip, HasSubscripLife;
        try
        {
            db1.sqlcmd = new SqlCommand("uspCheckSubscription");
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                db1.sqlcmd.CommandType = CommandType.StoredProcedure;
                db1.sqlcmd.Parameters.AddWithValue("@Userid", Userid);
                db1.sqlcmd.Parameters.Add("@HasSubscrip", SqlDbType.Bit);
                db1.sqlcmd.Parameters.Add("@HasSubscripLife", SqlDbType.Bit);
                db1.sqlcmd.Parameters.Add("@SubscripID", SqlDbType.Int);
                db1.sqlcmd.Parameters["@HasSubscrip"].Direction = ParameterDirection.Output;
                db1.sqlcmd.Parameters["@HasSubscripLife"].Direction = ParameterDirection.Output;
                db1.sqlcmd.Parameters["@SubscripID"].Direction = ParameterDirection.Output;
                db1.sqlcmd.Connection = db1.sqlcon;
                db1.sqlcon.Open();
                int success = Convert.ToInt32(db1.sqlcmd.ExecuteScalar());
                HasSubscrip = Convert.ToBoolean(db1.sqlcmd.Parameters["@HasSubscrip"].Value);
                HasSubscripLife = Convert.ToBoolean(db1.sqlcmd.Parameters["@HasSubscripLife"].Value);
                SubscripID = Convert.ToInt32(db1.sqlcmd.Parameters["@SubscripID"].Value);
                ViewState["SubscripID"] = SubscripID;
                ViewState["HasSubscrip"] = HasSubscrip;
                ViewState["HasSubscripLife"] = HasSubscripLife;
            }
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
        finally {
            db1.sqlcon.Close();
        }
    }