create function dbo.UniteRow(@PrimaykeyValue varchar(10))
returns varchar(100)
as
begin
declare @ReturnV varchar(1000)
set @ReturnV=''
select @ReturnV=@ReturnV+'; '+ItemName+': '+AllocAmt from View_PSLetter24_Sub where CBReceiptID=@PrimaykeyValue
set @ReturnV=stuff(@ReturnV,1,1,'')
return @ReturnV
end