Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

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.



Filter by Category


This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.0 seconds and yielded 19 results.

Sales SalesOrderHeader (table) — 10.9%

[...] SalesPerson SalesYTD when SubTotal is updated IF UPDATE([SubTotal]) BEGIN DECLARE @StartDate datetime, @EndDate datetime SET @StartDate = [dbo].[ufnGetAccountingStartDate](); SET @EndDate = [dbo].[ufnGetAccountingEndDate](); UPDATE [Sales].[SalesPerson] SET [Sales].[SalesPerson].[SalesYTD] = (SELECT SUM([Sales].[SalesOrderHeader].[SubTotal]) FROM [Sales].[SalesOrderHeader] WHERE [Sales].[SalesPerson].[SalesPersonID] = [Sales].[SalesOrderHeader].[SalesPersonID] [...]

Production BillOfMaterials (table) — 9.1%

[...] Product.ProductID. ComponentID int not null Component identification number. Foreign key to Product.ProductID. StartDate datetime not null (getdate()) Date the component started being used in the assembly item. EndDate datetime null Date the component stopped being used in the assembly item. UnitMeasureCode nchar(3) not null Standard code identifying the unit of measure for the quantity. BOMLevel smallint not null Indicates the depth the component is from its parent (AssemblyID). PerAssemblyQty decimal(8, 2) not null ((1.00)) Quantity of the component needed to create [...]

HumanResources EmployeeDepartmentHistory (table) — 9.1%

[...] tinyint not null Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID. StartDate datetime not null Date the employee started work in the department. EndDate datetime null Date the employee left the department. NULL = Current department. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID EmployeeID, DepartmentID, ShiftID, StartDate Indexes [...]

Sales SalesTerritoryHistory (table) — 9.1%

[...] TerritoryID int not null Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID. StartDate datetime not null Date the sales representive started work in the territory. EndDate datetime null Date the sales representative left work in the territory. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_SalesTerritoryHistory_SalesPersonID_

Production ProductListPriceHistory (table) — 9.1%

[...] Description ProductID int not null Product identification number. Foreign key to Product.ProductID 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 [...]

Production ProductCostHistory (table) — 9.1%

[...] Description ProductID int not null Product identification number. Foreign key to Product.ProductID StartDate datetime not null Product cost start date. EndDate datetime null Product cost end date. StandardCost money not null Standard cost of the product. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_ProductCostHistory_ProductID_StartDate ProductID, StartDate Check Constraints Check Constraint Expression [...]

Production WorkOrder (table) — 5.5%

[...] Quantity built and put in inventory. ScrappedQty smallint not null Quantity that failed inspection. StartDate datetime not null Work order start date. EndDate datetime null Work order end date. DueDate datetime not null Work order due date. ScrapReasonID smallint null Reason for inspection failure. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_WorkOrder_WorkOrderID WorkOrderID Indexes Index Type Columns IX_WorkOrder_ProductID ProductID IX_WorkOrder_ScrapReasonID [...]

Sales SpecialOffer (table) — 5.5%

[...] category. Category nvarchar(50) not null Group the discount applies to such as Reseller or Customer. StartDate datetime not null Discount start date. EndDate datetime not null Discount end date. MinQty int not null ((0)) Minimum discount percent allowed. MaxQty int null Maximum discount percent allowed. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns [...]

public statisticsreport (table) — 5.5%

[...] public.statisticsreport Columns Column Data Type Nullable Default Description id integer not null startdate timestamp with time zone not null enddate timestamp with time zone not null name varchar(63) not null description varchar(255) not null jobstarteddate timestamp with time zone not null jobcompleteddate timestamp with time zone not null purgedate timestamp with time zone not null Primary Key Primary Key Columns pk_statisticsreport_id id Indexes Index Type Columns statisticsreport_name name statisticsreport_purgedate [...]

dbo uspGetBillOfMaterials (procedure) — 3.6%

[...] b.[ComponentID] = p.[ProductID] WHERE b.[ProductAssemblyID] = @StartProductID AND @CheckDate >= b.[StartDate] AND @CheckDate = b.[StartDate] [...]

HumanResources vJobCandidateEmployment (view) — 3.6%

[...] element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume"; (Emp.StartDate)[1]', 'nvarchar(20)') ,'Z', ''), 101) AS [Emp.StartDate] [...]

HumanResources vJobCandidateEducation (view) — 3.6%

[...] element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume"; (Edu.StartDate)[1]', 'nvarchar(20)') ,'Z', ''), 101) AS [Edu.StartDate] [...]

HumanResources vEmployeeDepartment (view) — 3.6%

[...] ,c.[Suffix] ,e.[Title] AS [JobTitle] ,d.[Name] AS [Department] ,d.[GroupName] ,edh.[StartDate] FROM [HumanResources].[Employee] e INNER JOIN [Person].[Contact] c ON c.[ContactID] = e.[ContactID] INNER JOIN [HumanResources].[EmployeeDepartmentHistory] edh ON e.[EmployeeID] = edh.[EmployeeID] INNER JOIN [HumanResources].[Department] d ON edh.[DepartmentID] = d.[DepartmentID] WHERE GETDATE() BETWEEN edh.[StartDate] [...]

dbo uspGetWhereUsedProductID (procedure) — 3.6%

[...] b.[ProductAssemblyID] = p.[ProductID] WHERE b.[ComponentID] = @StartProductID AND @CheckDate >= b.[StartDate] AND @CheckDate = b.[StartDate] [...]

WikiMarkup — 1.8%

[...] {Wanted} BirthDate Gender HireDate MaritalStatus SickLeaveHours VacationHours EndDate StartDate PayFrequency Rate (table) EmailPromotion [...]

dbo ufnGetProductStandardCost (function) — 1.8%

[...] p.[ProductID] = pch.[ProductID] AND p.[ProductID] = @ProductID AND @OrderDate BETWEEN pch.[StartDate] AND COALESCE(pch.[EndDate], CONVERT(datetime, [...]

dbo ufnGetProductListPrice (function) — 1.8%

[...] p.[ProductID] = plph.[ProductID] AND p.[ProductID] = @ProductID AND @OrderDate BETWEEN plph.[StartDate] AND COALESCE(plph.[EndDate], CONVERT(datetime, [...]

dbo ufnGetProductDealerPrice (function) — 1.8%

[...] p.[ProductID] = plph.[ProductID] AND p.[ProductID] = @ProductID AND @OrderDate BETWEEN plph.[StartDate] AND COALESCE(plph.[EndDate], CONVERT(datetime, [...]

HumanResources vEmployeeDepartmentHistory (view) — 1.8%

[...] ,c.[Suffix] ,s.[Name] AS [Shift] ,d.[Name] AS [Department] ,d.[GroupName] ,edh.[StartDate] ,edh.[EndDate] FROM [HumanResources].[Employee] [...]

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.