API GetPrices: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| Řádek 9: | Řádek 9: | ||
SELECT TOP 1000 id | SELECT TOP 1000 id | ||
FROM api_getproductgroups | |||
WHERE tecdocbrandname = 'WALKER' | WHERE tecdocbrandname = 'WALKER' | ||
Verze z 24. 7. 2017, 11: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