API GetPrices: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 15: | Řádka 15: | ||
@CustomerID = 2, | @CustomerID = 2, | ||
@ProductIDs = @ID | @ProductIDs = @ID | ||
| + | |||
| + | ==== Notice ==== | ||
| + | Price calculation function uses own data type called IDsList (<code>dbo.IDsList</code>) | ||
Verze z 24. 7. 2017, 17:32
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
Notice
Price calculation function uses own data type called IDsList (dbo.IDsList)
