NW WA Meet / BS Thread

@bobsuruncle I like all dark beers. If I can’t see through the glass I’ll drink it...

Can’t speak to durability yet it’s only been a few months. But my understanding was prep work was critical to having a good outcome. I flap disked all edges hoping the paint would stick better. Cleaning and etching the metal with metal prep went quick. I brushed on the POR-15. Turned out two coats was to thick for holes drilled in bumper. Sadly I had to scrap away all of the POR-15 and apply one thin coat of primer with a Qtip.
So I would recommend enlarging holes one size before applying all your paint.

 

No, you *should* be able to generate the results you need from one table. The correct query is just escaping me.

Basically, you need to select all customers who bought shoes, and then all customers who bought pants. Then, if they bought shoes, then 1, and if they bought pants, then 1. Then, select customers where Shoes + Pants = 2.

 

I mostly use Oracle and occasional SQL Server, so my heavy usage is sql thru Oracle and its reserved words and functions:

In my experience: the reserved word of "Between" will give inconsistent results unless the column definition is DATE or Number; Varchar, even though numeric data, produces inconsistencies.

to get distinct customer, you will have to run a subquery and join on customer num on outer table to inner table:

select distinct (fields you want to see)
from [dbo].[FactInternetSales] A
where A.CustomerKey in (select B.CustomerKey from [dbo].[FactInternetSales] B where A.CustomerKey = B.CustomerKey and B.ProductKey in (list your products in the condition here: "225" etc.)

 

like this:
select distinct (fields you want to see)
from [dbo].[FactInternetSales] A
where exists (select 1 from [dbo].[FactInternetSales] B where A.CustomerKey = B.CustomerKey and B.ProductKey in (list your B.products in the condition here: "225" etc.)
and A.ProductKey in (list your A.products in the condition here: "225" etc.)

 

Ben's brain is working better than mine today.

 

Thanks!

I am working on setting up materials planning for EU with Lewandowski algorithms for demand models... it'll make ya head spin...

 

Trucks, guns and nerds, I think I love this site

 

Does anyone have a 2bolt flanged wastegate they don’t want anymore?

 

CTRL+ALT+DELETE

 

CTRL + C for Unix

 

Command+Q

Apple is what I’ve grown up using in the early 90’s. Anything windows angers me to no end, it never seems to work as well as a Unix or Linux based system.

 

Anyone want close to 300FT give or take of 3/8 6x36 Wire rope? Its in good condition, don't think its been used.

 

"To start press any key", "where's the any key?"

 

Dude I think that worked magically. I owe you and @Capt. Obvious a beer sometime.

 

You’re not just giving it away are you?

 

@JDAM when/where was that first aid class?

 

Today is last day to sign up! Issaquah Sportsmans Club. Email the address below to sign up. They say to bring your kits so they can look them over.

Monday, March 25th

6:00PM—9:30PM

Issaquah Sportsmen’s Clubhouse
23600 SE Evans Street. Issaquah WA 98027

CPR/AED/First-Aid/Fire Extinguisher Class

Cost: $50/person

Instructors, Woodinville Fire Fighters and Paramedics


We are excited to offer these courses to the public. In one evening you can get certified. What better gift to give yourself and/or a loved one than to educate yourself on how and when to help others.

Please sign up by emailing isc.info@issaquahsportsmensclub.com before Friday, March 22nd. Seats fill up fast so get yours reserved today!

 

Where i work we have so many spools of cable its ridiculous.. We're doing some "spring cleaning" and its one of the spools we want to get rid of. especially since its a odd at 6 X 36 lay. we normally use 6 x 25.

 

Damn can’t make it. Was hoping it’d be on the weekend.

On a different note i made a EGR blockoff plate and part of an adapter for an external wastegate