API GetPrices: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 1: | Řádka 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, 12: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
