SOCKS FOR HEROES
|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 = 'SOCKS-NT' AND (upper(f.web_text) = 'TURNER`S OUTDOORSMAN' or upper(f.orig_text) = 'TURNER`S OUTDOORSMAN' or upper(a.brand) = 'TURNER`S OUTDOORSMAN') 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|
MEMORIAL DAY SOCK DRIVE
While many have been reading about the recent Troop Drawdowns, the United States still has Troops deployed in harm’s way in Afghanistan, Iraq and the Middle East. These men and women live under conditions that would make the average American Citizen cringe. They do it without complaint regardless of the discomfort and danger.
Well the infantry spends all of their time on their feet. They have no laundry facilities, so they have to wash their socks in the canals and air dry them. While in California, this would be no problem, but where they are located, the sand and grit gets into them and make them unusable within a couple of days. Speaking to over 100 field Marines, the answer was uniform: “Send us Socks.”
Who We’re Helping
Currently we are supplying 2 Marine Infantry Battalions, a number of Marine support units and many Army Units. Your help will go a long way in making their deployments a little easier by taking one more worry off of the Marines’ minds, and letting them focus on the big job in front of them.
100% of the proceeds goes to "Socks for Heroes".
Thank you for your generosity!
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review