Store Procedure

[brettokumar]

hi i am using a store procedure for passing number of value and using two parameter one is value and another one is id use to update table my store procedure like below coding but this store procedure is created but when i am execute this sp it display error like this : Conversion failed when converting the varchar value '1,2,7,8,12' to data type int. my coding is like: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER procedure [dbo].[sp_txtSplit_Summa1](@sp_Visible varchar(1000), @sp_CRID Varchar(100), @sp_Delimiter char(1)=',') as begin set nocount on declare @Item varchar(1000) declare @ItemID varchar(100) while (charIndex(@sp_Delimiter,@sp_Visible,0)<>0 and charIndex(@sp_CRID,@sp_Visible,0)<>0) begin select @Item= rtrim(ltrim(substring(@sp_Visible,1,CharIndex(@sp_Delimiter,@sp_Visible,0)-1))), @ItemID=rtrim(ltrim(substring(@sp_CRID,1,CharIndex(@sp_Delimiter,@sp_CRID,0)-1))), @sp_Visible=rtrim(ltrim(substring(@sp_visible,charindex(@sp_delimiter,@sp_Visible,0)+1,len(@sp_Visible)))), @sp_CRID=rtrim(ltrim(substring(@sp_visible,charindex(@sp_delimiter,@sp_CRID,0)+1,len(@sp_CRID)))) if len(@Item)>0 select (@item) select (@ItemID) update summa1 set age= (select @Item ) where sno= (select @ItemID ) end if len(@sp_Visible)>0 update summa1 set age= (select @sp_Visible) where sno= (select@sp_CRID) select (@item) select (@ItemID) select * from summa1 return end --CAST(CAST(@myval AS varbinary(20)) AS decimal(10,5)) exec sp_txtSplit_Summa1 '21,22,333,444,555','1,2,7,8,12',','

with regards, bretto

[SomeGuyThatIsMe]

the problem is in the second update if i'm reading this correctly, @sp_CRID is a comma delimited list if integers which must be treated as a string. andi'm guessing the sno column is an int.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.