Hornady 45 CAL Bullet .458 300GR Hollow Point
|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 = '4500' AND (upper(f.web_text) = 'HORNADY' or upper(f.orig_text) = 'HORNADY' or upper(a.brand) = 'HORNADY') 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|
Hornadys's traditional line of bullets feature exposed lead tips for controlled expansion and hard hitting terminal performance. Most have their pioneering secant ogive design-one of the most ballistically efficient profiles ever developed. Most feature their exclusive InterLock® design--a raised ring inside the jacket that is embedded in the bullet's core that keeps the core and jacket locked together during expansion to retain mass and energy.
SECANT OGIVE DESIGN
Pioneered by Hornady® for use in hunting bullets, this technology broke new ground in ballistic engineering and is now used in bullets for everything from match to varmint shooting.
The secant ogive is a geometrically developed design that creates the most ballistically efficient profile, yet retains the optimum bearing surface. The combination of the slender point and increased bearing surface results in lower drag, increased stability, flatter trajectories, and amazing accuracy.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review