Buck Knives 840 Sprint, Grey
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = '840GYS1/12868' AND (upper(f.web_text) = 'BUCK' or upper(f.orig_text) = 'BUCK' or upper(a.brand) = 'BUCK') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
The Buck Knives 840 Sprint Select is the perfect lightweight, everyday carry knife. The 840 Sprint Select features ball bearing technology that allows this folding knife to open smooth and rapidly when you engage the flipper on the top of the knife. A sturdy liner lock safely secures the blade open while in use. The knife folds closed to 4 3/8” (11.1 cm) to easily fit into your pocket. The satin finished, drop point blade is made of razor sharp 420HC steel ideal for a variety of everyday task. The lightweight, ergonomic handle is made of glassed filled nylon comes in different colors to suit your style. This knife is easy to carry with the convenient deep pocket clip. The 840 Sprint Pro is perfect for someone that wants a modern, lightweight, everyday carry knife with a high end ball bearing opening system.
Blade Thickness: 0.120"
No reviews have been written for this product.
Be the first one! – Write a Review