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, | @CustomerID int - API_GetCustomers.ID, | ||
@ProductIDs table - API_GetProductGroups.ID | |||
@ProductIDs table | |||
''Example:'' | ''Example:'' | ||
DECLARE @ID dbo.''IDSLIST'' | DECLARE @ID dbo.''IDSLIST'' | ||
INSERT INTO @ID | |||
INSERT INTO @ID | SELECT TOP 1000 id | ||
FROM api_getproductgroups | |||
SELECT TOP 1000 id | WHERE tecdocbrandname = 'WALKER' | ||
FROM api_getproductgroups | EXEC '''Api_getprices''' | ||
@CustomerID = 2, | |||
WHERE tecdocbrandname = 'WALKER' | @ProductIDs = @ID | ||
EXEC '''Api_getprices''' | |||
@CustomerID = 2, | |||
@ProductIDs = @ID | |||
Verze z 24. 7. 2017, 13:19
API_GetPrices
@CustomerID int - API_GetCustomers.ID, @ProductIDs table - API_GetProductGroups.ID
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