All items with these criteria are: Thickness=SELECT Convert(Int, Thickness) TheField, Count(DISTINCT Product.ProductID) TheCount FROM Product with (NOLOCK) INNER JOIN ProductVariant with (NOLOCK) ON Product.ProductID = ProductVariant.ProductID WHERE Length=1 AND Convert(Int, Thickness) IS NOT NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
This web site best viewed at a resultion of 1024x768 or greater with FireFox 2.0 or Internet Explorer 7.0 or greater.
Site design and maintenance by TEK Consulting LLC
Shopping Cart
