/*
function name:getLocationStrbyCode
purporse:根據產品連接儲位代碼
author:Justin Lee
create date:2004/10/7
modifer:Justin Lee
modified date:2004/10/7
*/
create function getLocationStrbyCode(
@ProdCode varchar(20),
@BillNo varchar(20)
)returns varchar(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
function name:getLocationStrbyCode
purporse:根據產品連接儲位代碼
author:Justin Lee
create date:2004/10/7
modifer:Justin Lee
modified date:2004/10/7
*/
create function getLocationStrbyCode(
@ProdCode varchar(20),
@BillNo varchar(20)
)returns varchar(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