... hit post too soon 🙂

if object_id('proc_update_batch') is not null drop procedure proc_update_batch;

go

create procedure proc_update_batch

@batchNo int,

@value varchar(10)

as

declare @check char,

@startPos int,

@endPos int,

@PublicationList varchar(1000)

set @PublicationList = (select PublicationList from batch...

Agree with Gail 100%.

but here is a quick solution to your problem...

update Batch

set PublicationList = PublicationList + ', 999'

where BatchNo = 1;

if object_id('fn_list') is not null drop function fn_list;

go

create function sp_list

(

@prod varchar(100)

)

returns varchar(8000)

as

begin

declare @list varchar(8000)

select @list = isnull(@list ,'') + case when isnull(@list ,'') <> '' then ' '...