|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,4) ) 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 = '1140X' AND (upper(f.web_text) = 'KERSHAW' or upper(f.orig_text) = 'KERSHAW' or upper(a.brand) = 'KERSHAW') 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|
Yes, You Need It
You know you need this tool.
If you camp, backpack, hike, or hunt, you know you need this. If you have to grab lunch between classes, you know you need this. If you eat lunch at your desk, you really know you need this. Of course, the Kershaw Ration spoon-and-fork tool is compact. But it's a compact tool that also offers a generously sized spoon—so you can get a real mouthful of that soup or chili you’re eating—as well as a fork with tines long enough to actually be useful.
As a convenient bonus, it also has a built-in carabiner, so it’s easy to clip to a backpack, briefcase, or purse to make sure you have it when you need it.
- Bottle opener
- Carabiner gate
- Steel: 3Cr13, bead-blasted finish
- Overall Length: 4.6 in. (11.7 cm)
- Weight: 1.3 oz. (36 g)
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review