Home Forums SQL Server 7,2000 T-SQL Error converting data type nvarchar to float RE: Error converting data type nvarchar to float

  • Hi ,

    one more thing:

    ALTER Procedure dbo.UPdata

    (

    @e_Nplan char(20),

    @e_Ncas char(20)

    )

    As

    Update Cis_OP_NO

    SET N_Cas100ks = convert(float,replace(@e_Ncas,',','.'))

    Where N_Kplan = @e_Nplan

    return

    Error message:

    Subquery returned more than 1 value. This is not premitted when the subquery follows =, =! , ....

    Could you give some suggests how to solve it?

    Thanks