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