Career Path Thread: Money is happiness

The Something Awful Forums > Discussion > Ask/Tell > Business, Finance, and Careers > Career Path Thread: Money is happiness

Mary Fucking Poppins: Aug 1, 2002

Kim Jong Il posted:

SELECT *
FROM table1 t1 (this is saying where you're initially pulling the data from, and then renaming table1 to t1 for shorthand)
LEFT JOIN table t2 (nolock) on t2.id=t1.id
WHERE t1.year='2012' and t2.city='Boston'

When you left join a table and specify a filter on that table (t2.city='Boston'), you're effectively writing an inner join.

# ¿ Jul 3, 2013 03:12

Adbot: ADBOT LOVES YOU

# ¿ May 3, 2024 11:17

Mary Fucking Poppins: Aug 1, 2002

I'm a little confused about how pay works when compared to an independent contractor. I'm considering a job with a consulting company who would offer the position as an independent contractor or an employee of the consulting company itself. If they say that the job is $X per her and to increase that if pursuing as an independent contractor or decrease that if pursing as a full-time employee, how much does that generally slide in each direction? I'd more than likely pursue as a full-time employee, but I don't really have an idea of how much the annual salary would actually be. I'm intending on asking more about that with the recruiter, but the more information I have ahead of time the more comfortable I'd be.

# ¿ Jul 15, 2013 02:32

Mary Fucking Poppins: Aug 1, 2002

Ultimate Mango posted:

Do you want to pay for your own insurance and taxes? There are some people who prefer contracting and are set up to do that stuff on their own and feel like it is better. Others prefer being a corporate employee and getting regular benefits and such. You would have to look t taxes and benefits and such in your area of residence and compare the contractor rate less all that other stuff against the salary they offer (and other benefits).

The decision for you boils down to this: have you done contracting in the past and are you comfortable with that setup? If they answer isn't a resounding YES just take it as a corporate job.

Yeah, my intention is to take it as a full-time position mostly because I don't want the head-ache of doing taxes as an independent contractor. But I'm trying to get a gauge on how much the salary would be to see if it's worth it to leave my current position. Like I said, I can ask the recruiter, but I was already told $X/hr but lower if you're not a subcontractor. So if it's normal for people to automatically know that means $X - Y I'd rather not ask and risk looking dumb.

# ¿ Jul 15, 2013 03:23

The Something Awful Forums > Discussion > Ask/Tell > Business, Finance, and Careers > Career Path Thread: Money is happiness