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, 13: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
