API GetPrices: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| Řádek 1: | Řádek 1: | ||
API_GetPrices | API_GetPrices (@CustomerID int, @ProductIDs table) | ||
( | |||
@CustomerID int | |||
@ProductIDs table | |||
) | |||
Example | Example | ||
DECLARE @ID dbo.''IDSLIST'' | |||
INSERT INTO @ID | |||
SELECT TOP 1000 id | |||
FROM api_getproductgroups WITH (nolock) | |||
WHERE tecdocbrandname = 'WALKER' | |||
EXEC '''Api_getprices''' | |||
@CustomerID = 2, | |||
@ProductIDs = @ID | |||
Verze z 24. 7. 2017, 11:34
API_GetPrices (@CustomerID int, @ProductIDs table)
Example
DECLARE @ID dbo.IDSLIST
INSERT INTO @ID
SELECT TOP 1000 id
FROM api_getproductgroups WITH (nolock)
WHERE tecdocbrandname = 'WALKER'
EXEC Api_getprices
@CustomerID = 2,
@ProductIDs = @ID