May 22, 2009 at 12:40 pm
Hi ,
one small problem:
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
May 22, 2009 at 12:43 pm
Would you please show us how you are using this procedure?
May 22, 2009 at 1:03 pm
ALTER Procedure dbo.UPdata
(
@e_Nplan char(20), /* e.g. 112a */
@e_Ncas char(20) /* e.g. 15,45 */
)
As
Update Cis_OP_NO
SET N_Cas100ks = convert(float,replace(@e_Ncas,',','.'))
Where N_Kplan = @e_Nplan
return
.... problem is that in my table is more than 1 record for N_Kplan ...but I dont know how to solve it
May 22, 2009 at 1:07 pm
peter478 (5/22/2009)
ALTER Procedure dbo.UPdata(
@e_Nplan char(20), /* e.g. 112a */
@e_Ncas char(20) /* e.g. 15,45 */
)
As
Update Cis_OP_NO
SET N_Cas100ks = convert(float,replace(@e_Ncas,',','.'))
Where N_Kplan = @e_Nplan
return
.... problem is that in my table is more than 1 record for N_Kplan ...but I dont know how to solve it
Sorry, but all you did is repost the code for your stored procedure. This doesn't tell us anything.
Please provide the DDL for the table Cis_OP_NO, sample data for the table (in a readily consumable format), how you are calling the stored procedure dbo.UPdata including the data being passed to procedure.
May 22, 2009 at 2:14 pm
There is not a subquery in the code you provided.
Please include the ALL code you are running that produces the error.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply