Table 'Production.ProductListPriceHistory', Changes in the list price of a product over time.

Table 'Production.ProductListPriceHistory', Changes in the list price of a product over time.

Property NameProperty Value
Records395
Fields5
Record size (bytes) w/o BLOBs73

Field statistics for 'ProductID' int

Field propertyProperty Value
Minimum value707
Maximum value999
Average value828.72911392405058
Values variance7490.2183126646851
Unique values293

Field statistics for 'StartDate' datetime

Field propertyProperty Value
Minimum value2001-07-01 00:00:00.000
Maximum value2003-07-01 00:00:00.000
Unique values3

Field statistics for 'EndDate' datetime

Field propertyProperty Value
Minimum value2002-06-30 00:00:00.000
Maximum value2003-06-30 00:00:00.000
Unique values2

Field statistics for 'ListPrice' money(19,4)

Field propertyProperty Value
Minimum value2.2900
Maximum value3578.2700
Average value747.66176227848007
Values variance703431.8663296107
Unique values120

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value2002-06-30 00:00:00.000
Maximum value2003-06-30 00:00:00.000
Unique values3