API GetPrices: Porovnání verzí
Z Podpora.nextis.cz
Řádka 1: | Řádka 1: | ||
− | API_GetPrices | + | '''API_GetPrices''' |
− | Example | + | @CustomerID int, |
+ | |||
+ | @ProductIDs table | ||
+ | |||
+ | ''Example:'' | ||
DECLARE @ID dbo.''IDSLIST'' | DECLARE @ID dbo.''IDSLIST'' |
Verze z 24. 7. 2017, 12:50
API_GetPrices
@CustomerID int,
@ProductIDs table
Example:
DECLARE @ID dbo.IDSLIST
INSERT INTO @ID
SELECT TOP 1000 id
FROM api_getproductgroups
WHERE tecdocbrandname = 'WALKER'
EXEC Api_getprices
@CustomerID = 2,
@ProductIDs = @ID