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.
[...] 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]
[...]
[...] 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 [...]
[...] 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 [...]
[...] 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_
[...] 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 [...]
[...] 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 [...]
[...] 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 [...]
[...] 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 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 [...]
[...] b.[ComponentID] = p.[ProductID]
WHERE b.[ProductAssemblyID] = @StartProductID
AND @CheckDate >= b.[StartDate]
AND @CheckDate = b.[StartDate] [...]
[...] element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Emp.StartDate)[1]', 'nvarchar(20)') ,'Z', ''), 101) AS [Emp.StartDate] [...]
[...] element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Edu.StartDate)[1]', 'nvarchar(20)') ,'Z', ''), 101) AS [Edu.StartDate] [...]
[...] ,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] [...]
[...] b.[ProductAssemblyID] = p.[ProductID]
WHERE b.[ComponentID] = @StartProductID
AND @CheckDate >= b.[StartDate]
AND @CheckDate = b.[StartDate] [...]
[...] {Wanted} BirthDate Gender HireDate MaritalStatus SickLeaveHours VacationHours EndDate StartDate PayFrequency Rate (table) EmailPromotion [...]
[...] p.[ProductID] = pch.[ProductID]
AND p.[ProductID] = @ProductID
AND @OrderDate BETWEEN pch.[StartDate] AND COALESCE(pch.[EndDate], CONVERT(datetime, [...]
[...] p.[ProductID] = plph.[ProductID]
AND p.[ProductID] = @ProductID
AND @OrderDate BETWEEN plph.[StartDate] AND COALESCE(plph.[EndDate], CONVERT(datetime, [...]
[...] p.[ProductID] = plph.[ProductID]
AND p.[ProductID] = @ProductID
AND @OrderDate BETWEEN plph.[StartDate] AND COALESCE(plph.[EndDate], CONVERT(datetime, [...]
[...]
,c.[Suffix]
,s.[Name] AS [Shift]
,d.[Name] AS [Department]
,d.[GroupName]
,edh.[StartDate]
,edh.[EndDate]
FROM [HumanResources].[Employee] [...]