/**//* function name:getLocationStrbyCode purporse:根據產品連接儲位代碼 author:Justin Lee create date:2004/10/7 modifer:Justin Lee modified date:2004/10/7 */ createfunction getLocationStrbyCode( @ProdCode varchar(20), @BillNo varchar(20) )returnsvarchar(8000) as begin declare @str varchar(8000) set @str='' select @str=@str+';'+LocationCode from[LD_RVNotifyItem]where BillNo= @BillNo and ProdCode = @ProdCode return(stuff(@str,1,1,'')) end