API GetPrices: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „API_GetPrices ( @CustomerID int @ProductIDs table ) Example Declare @ID dbo.IDsList INSERT INTO @ID SELECT top 1000 ID FROM API_GetProductGroups WIT…“) |
|||
| Řádka 12: | Řádka 12: | ||
FROM API_GetProductGroups WITH (NOLOCK) | FROM API_GetProductGroups WITH (NOLOCK) | ||
WHERE TecDocBrandName = 'WALKER' | WHERE TecDocBrandName = 'WALKER' | ||
| − | |||
EXEC API_GetPrices | EXEC API_GetPrices | ||
@CustomerID = 2, | @CustomerID = 2, | ||
@ProductIDs = @ID | @ProductIDs = @ID | ||
Verze z 24. 7. 2017, 12:31
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
