API GetPrices: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 9: | Řádka 9: | ||
SELECT TOP 1000 id | SELECT TOP 1000 id | ||
| − | + | FROM api_getproductgroups | |
WHERE tecdocbrandname = 'WALKER' | WHERE tecdocbrandname = 'WALKER' | ||
Verze z 24. 7. 2017, 12:36
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
