I have a query which contain table valued function. But when executing this attached error comming. How can I solve this?
SELECT bg.Description, im.ERPItemCode,
(select Opening,Topup1,Topup2,Topup3,
Returnsv,SaleQty,SaleVal from dbo.GetOpeningByRepAcc(@Date,@RepAccId,@Cente![enter image description here][2]rId,im.Id)),
(select Name from dbo.DistributionCenter where Id = @CenterId) as center,
(select Name from dbo.SalesRepAcc where Id = @RepAccId)as repacc
FROM BudgetGroup AS bg
INNER JOIN ItemMaster AS im ON bg.Id = im.BudgetGroupId
WHERE (bg.Active = 1)
Aucun commentaire:
Enregistrer un commentaire