Out Of Stock
|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 = '17103' AND (upper(f.web_text) = 'A-ZOOM' or upper(f.orig_text) = 'A-ZOOM' or upper(a.brand) = 'A-ZOOM') 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|
Our extremely popular A-Zoom Snap Caps are the best choice for safety training, function testing and dry firing practice. Their rugged design has proven to withstand thousands of dry fires while still protecting the firing pin. One drawback with dry firing snap caps however is when they are used in striker fire type pistols. These firearms require that the slide be drawn back to cock the pistol, which then extracts and ejects the snap cap from the pistol. Our new StrikerCaps solve this problem. StrikerCaps are made without a rim and are equipped with a centering o-ring which grips the chamber walls and keeps the snap cap in place in the chamber. Once it is chambered, simply rack the slide to cock the pistol. StrikerCaps will absorb the firing pin hit just like standard A-Zooms, however will stay in place for quicker, easier dry fire practice.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$19.99 to $22.99
$24.97 to $39.99