API GetPrices - Historie editací

Chrzaszcz v 15. 11. 2018, 10:20

2018-11-15T10:20:13Z

Zavadil v 24. 7. 2017, 16:32

2017-07-24T16:32:46Z

Chrzaszcz v 24. 7. 2017, 13:19

2017-07-24T13:19:28Z

Chrzaszcz v 24. 7. 2017, 11:50

2017-07-24T11:50:08Z

Chrzaszcz v 24. 7. 2017, 11:36

2017-07-24T11:36:15Z

Chrzaszcz v 24. 7. 2017, 11:34

2017-07-24T11:34:17Z

Chrzaszcz v 24. 7. 2017, 11:31

2017-07-24T11:31:43Z

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

@@ Řádka 1: / Řádka 1: @@
 '''API_GetPrices'''
   @CustomerID int - API_GetCustomers.ID,
   @ProductIDs table - API_GetProductGroups.ID
@@ Řádka 13: / Řádka 14: @@
   EXEC '''Api_getprices'''
   @CustomerID = 2,
   @ProductIDs = @ID
 ==== Notice ====
 Price calculation function uses own data type called IDsList (<code>dbo.IDsList</code>)

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

@@ Řádka 1: / Řádka 1: @@
 '''API_GetPrices'''
-@CustomerID int,
+ @CustomerID int - API_GetCustomers.ID,
+ @ProductIDs table - API_GetProductGroups.ID
 ''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

@@ Řádka 1: / Řádka 1: @@
-API_GetPrices (@CustomerID int, @ProductIDs table)
+'''API_GetPrices'''
-Example
+@CustomerID int,
 DECLARE @ID dbo.''IDSLIST''

@@ Řádka 9: / Řádka 9: @@
 SELECT TOP 1000 id
-FROM   api_getproductgroups WITH (nolock)
+FROM   api_getproductgroups
 WHERE  tecdocbrandname = 'WALKER'

@@ Řádka 12: / Řádka 12: @@
 FROM API_GetProductGroups WITH (NOLOCK)
 WHERE TecDocBrandName = 'WALKER'
 EXEC	API_GetPrices
 	@CustomerID = 2,
 	@ProductIDs = @ID