Search Engine
Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.0 seconds and yielded 7 results.
[...] triggers a purchase order or work order. StandardCost money not null Standard cost of the product. ListPrice money not null Selling price. Size nvarchar(5) null Product size. SizeUnitMeasureCode nchar(3) null Unit of measure for Size column. WeightUnitMeasureCode nchar(3) null Unit of measure for Weight column. Weight decimal(8, 2) null Product weight. DaysToManufacture int not null Number of days required to manufacture the product. ProductLine nchar(2) null R = Road, M = Mountain, T = Touring, S = Standard Class nchar(2) null H = High, M = [...]
[...] [dbo].[ufnGetProductListPrice](@ProductID [int], @OrderDate [datetime])
RETURNS [money]
AS
BEGIN
DECLARE @ListPrice money;
SELECT @ListPrice = plph.[ListPrice]
FROM [Production].[Product] p
INNER JOIN [Production].[ProductListPriceHistory] plph
ON p.[ProductID] = plph.[ProductID]
AND p.[ProductID] = @ProductID
AND @OrderDate BETWEEN plph.[StartDate] AND COALESCE(plph.[EndDate], [...]
[...] StartDate datetime not null List price start date. EndDate datetime null List price end date ListPrice money not null Product list price. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_ProductListPriceHistory_ProductID_StartDate ProductID, StartDate Check Constraints Check Constraint Expression Description CK_ProductListPriceHistory_EndDate ( EndDate >= StartDate OR EndDate IS NULL) Check constraint EndDate >= StartDate OR EndDate IS NULL CK_ProductListPriceHistory_
[...] WITH [BOM_cte]([ProductAssemblyID], [ComponentID], [ComponentDesc], [PerAssemblyQty], [StandardCost], [ListPrice], [BOMLevel], [RecursionLevel]) -- CTE name and columns
AS (
SELECT b.[ProductAssemblyID], b.[ComponentID], p.[Name], b.[PerAssemblyQty], p.[StandardCost], p.[ListPrice], [...]
[...] WITH [BOM_cte]([ProductAssemblyID], [ComponentID], [ComponentDesc], [PerAssemblyQty], [StandardCost], [ListPrice], [BOMLevel], [RecursionLevel]) -- CTE name and columns
AS (
SELECT b.[ProductAssemblyID], b.[ComponentID], p.[Name], b.[PerAssemblyQty], p.[StandardCost], p.[ListPrice], [...]
[...] ComponentID PerAssemblyQty ProductAssemblyID Status Availability CostRate Class DaysToManufacture ListPrice ProductLine ReorderPoint SafetyStockLevel [...]
[...] @DealerDiscount money;
SET @DealerDiscount = 0.60 -- 60% of list price
SELECT @DealerPrice = plph.[ListPrice] * @DealerDiscount
FROM [Production].[Product] [...]