NW WA Meet / BS Thread

That’s right I forgot he received the green light for his frame replacement.

 

I can pickup that crash bar this weekend if possible.

 

Done and done

 

Feck, just realized Im gonna need some factory rear shackles also since I've got a flip kit. Can't seem to find mine, or remember where they went.

@utroda do you still have your stock shackles and willing to part with them?


Still no word on an ETA for my frame, but going over the list of parts they ordered, it appears they ordered the wrong brake lines. They have part numbers listed for an ACLB w/vsc on order not a DCSB w/vsc. The part numbers are different for each.

 

I just coated my bumper. Use painters plastic hanging from the ceiling. Then I just roll it up when it is not needed. The plastic also did a great job holding some heat in my garage so the metal temp stayed above 60 degrees.
For coating I choose POR-15 full treatment then just rattle can top coat.

 

I have stock shackles you can have. Trade for beer???
I recently upgraded the stock hanger and got some greaseable shackles.

 

You're my fucking hero. What kind of beer do you like? I've got one archive's original kits too, but they won't transfer it over to the new frame.

 

I only wash mine 2-3 times a year... thanks plastidip

 

Thinking about using POR on my bumpers here soon, let me know your results

 

Dibs on archive kit?

 

Make sure you don't put it a cup and drink it by mistake. Someone did that at a mod day (I won't name names).

 

Okay SQL gurus @Yetimetchkangmi @Capt. Obvious

I'm stuck on this question.

Find customers who have ordered a product from BOTH the pants and the shoes categories. Display the customer ID, first name, last name, and email address.

I've checked other tables and I see pants are product keys 223-225 and shoes are 462-470.

I created this query

select CustomerKey,
ProductKey
from [dbo].[FactInternetSales]
where ProductKey between 223 and 225 or ProductKey between 462 and 470

and have this result



My question is how do i select distinct customer keys that have BOTH productkeys from the ranges between 223-225 and 462 and 470? For example, customerkey 11091 is what i'm looking for since it has both product keys 225 and 467.

If I change the where to AND instead of OR, I know that won't work since it's only looking at one row. I think I need to run a subquery that groups the customer key? But not sure exactly how. I don't think I need to do a join as all the data I need is in this one table.

 

Oh I'll be putting it on the new frame eventually.

 

hahah I wash mine once in every two years...

 

I let the rain wash it >.> But i have a gravel driveway so wash it and leave once and its dirty again

Well I do go under it in the spring/fall and wash the underside of accumulated crap.

 

sorry man i don't

 

Ya, every summer I try to sand and paint rusty spots on my frame and body.

 

I used POR on my sliders and rattle canned it up top. Still came off when they hit a tree and wore off a bit in the area that I step into the truck at.

 

Try

select CustomerKey,
ProductKey
from [dbo].[FactInternetSales]
,CASE
WHEN [ProductKey]='223' Then 'Shoes'
WHEN [ProductKey]='224' Then 'Shoes'
WHEN [ProductKey]='225' Then 'Shoes'
WHEN [ProductKey]='462' Then 'Pants'
WHEN [ProductKey]='463' Then 'Pants'
WHEN [ProductKey]='464' Then 'Pants'
WHEN [ProductKey]='465' Then 'Pants'
WHEN [ProductKey]='466' Then 'Pants'
WHEN [ProductKey]='467' Then 'Pants'
WHEN [ProductKey]='468' Then 'Pants'
WHEN [ProductKey]='469' Then 'Pants'
WHEN [ProductKey]='470' Then 'Pants'
END as 'ProductType'
,where ProductKey between 223 and 225 or ProductKey between 462 and 470

GROUP BY
CustomerKey,
ProductType,
HAVING (COUNT *)>1

Edit: I think you might need a subquery. The query above would also return customers who bought two pairs of shoes and no pants.

 

So you think even though I can generate these results from 1 table, I might need to pull in another table like the product table (I'm using the free database examples in SSMS17)? Ugh.