Current Criteria (Reset)
1138 products found, 1138 variants found. Show All Items
 | Shape=Round |
| Condition=Other |
| Length=48 |
Jump To: Material Grade Finish
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 Shape='Round' and Condition='Other' and Length=48 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
Material
 Alloy {76} |  Aluminum {139} |  Brass {42} |  Bronze {37} |  Cast Iron {22} |
 Copper {17} |  Stainless Steel {293} |  Steel {355} |  Tool Steel {157} |
Grade
Finish
| Cold Finished {244} | De-Carb Free {157} | Hot Finished {22} | Hot Rolled {138} |
| Other {528} | Turned Grnd & Polished {49} |