API GetPrices: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
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…“ |
Bez shrnutí editace |
||
| Řádek 12: | Řádek 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, 11: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