1 select @relatedits = isnull(@relatedits+',','')+replace(cast(p.relateditems as varchar(8000)), ' ', '')+';'+s.ProductID
from dbo.product p with (nolock)
join dbo.Orders_ShoppingCart s with (NOLOCK)
on p.ProductID = s.ProductID where s.ordernumber = 100014 2 select p.Name, p.ProductID,pid=right(rp.items,len(rp.items)-charindex(';',rp.items)) from dbo.product p with (nolock)
join dbo.split(@relatedits, ',') rp
on p.productid = cast(left(rp.items,charindex(';',rp.items)-1) as int)
from dbo.product p with (nolock)
join dbo.Orders_ShoppingCart s with (NOLOCK)
on p.ProductID = s.ProductID where s.ordernumber = 100014 2 select p.Name, p.ProductID,pid=right(rp.items,len(rp.items)-charindex(';',rp.items)) from dbo.product p with (nolock)
join dbo.split(@relatedits, ',') rp
on p.productid = cast(left(rp.items,charindex(';',rp.items)-1) as int)
报错Conversion failed when converting the varchar value '22,24;' to data type int.
就是在select @relatedits = isnull(@relatedits+',','')+replace(cast(p.relateditems as varchar(8000)), ' ', '')+';'+s.ProductID
这个地方~~ 再帮帮忙 谢谢了