API GetPrices - Historie editací

Chrzaszcz v 15. 11. 2018, 10:20

2018-11-15T10:20:13Z

← Starší verze		Verze z 15. 11. 2018, 10:20
Řádek 1:		Řádek 1:
	'''API_GetPrices'''		'''API_GetPrices'''

	@CustomerID int - API_GetCustomers.ID,		@CustomerID int - API_GetCustomers.ID,
			@UseEshopDiscount - Use Eshop Discount (0-OFF, 1-ON)
	@ProductIDs table - API_GetProductGroups.ID		@ProductIDs table - API_GetProductGroups.ID

Řádek 13:		Řádek 14:

	EXEC '''Api_getprices'''		EXEC '''Api_getprices'''
	@CustomerID = 2,		@CustomerID = 2,
			@UseEshopDiscount = 1,
	@ProductIDs = @ID		@ProductIDs = @ID

	==== Notice ====		==== Notice ====
	Price calculation function uses own data type called IDsList (<code>dbo.IDsList</code>)		Price calculation function uses own data type called IDsList (<code>dbo.IDsList</code>)

Zavadil v 24. 7. 2017, 16:32

2017-07-24T16:32:46Z

← Starší verze		Verze z 24. 7. 2017, 16:32
Řádek 15:		Řádek 15:
	@CustomerID = 2,		@CustomerID = 2,
	@ProductIDs = @ID		@ProductIDs = @ID

			==== Notice ====
			Price calculation function uses own data type called IDsList (<code>dbo.IDsList</code>)

Chrzaszcz v 24. 7. 2017, 13:19

2017-07-24T13:19:28Z

← Starší verze		Verze z 24. 7. 2017, 13:19
Řá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

Chrzaszcz v 24. 7. 2017, 11:50

2017-07-24T11:50:08Z

← Starší verze		Verze z 24. 7. 2017, 11:50
Řádek 1:		Řádek 1:
	API_GetPrices ~~(@CustomerID int, @ProductIDs table)~~		'''API_GetPrices'''

	Example		@CustomerID int,

			@ProductIDs table

			''Example:''

	DECLARE @ID dbo.''IDSLIST''		DECLARE @ID dbo.''IDSLIST''

Chrzaszcz v 24. 7. 2017, 11:36

2017-07-24T11:36:15Z

← Starší verze		Verze z 24. 7. 2017, 11:36
Řádek 9:		Řádek 9:
	SELECT TOP 1000 id		SELECT TOP 1000 id

	~~FROM api_getproductgroups WITH (nolock)~~		FROM api_getproductgroups

	WHERE tecdocbrandname = 'WALKER'		WHERE tecdocbrandname = 'WALKER'

Chrzaszcz v 24. 7. 2017, 11:34

2017-07-24T11:34:17Z

← Starší verze		Verze z 24. 7. 2017, 11:34
Řádek 1:		Řádek 1:
	API_GetPrices		API_GetPrices (@CustomerID int, @ProductIDs table)
	(
	@CustomerID int
	@ProductIDs table
	)

	Example		Example

	~~Declare~~ @~~ID dbo~~.~~IDsList~~		DECLARE @ID dbo.''IDSLIST''
	~~INSERT INTO @ID~~
	~~SELECT top 1000 ID~~
	~~FROM API_GetProductGroups WITH (NOLOCK)~~
	~~WHERE TecDocBrandName =~~ '~~WALKER~~'

	~~EXEC API_GetPrices~~		INSERT INTO @ID
	@~~CustomerID~~ = 2,
	@~~ProductIDs~~ = @ID		SELECT TOP 1000 id

			FROM api_getproductgroups WITH (nolock)

			WHERE tecdocbrandname = 'WALKER'

			EXEC '''Api_getprices'''

			@CustomerID = 2,

			@ProductIDs = @ID

Chrzaszcz v 24. 7. 2017, 11:31

2017-07-24T11:31:43Z

← Starší verze		Verze z 24. 7. 2017, 11:31
Řá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

Chrzaszcz: 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…“

2017-07-24T11:30:47Z

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…“

Nová stránka

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