BigEd76 wrote:"SELECT TOP 1 ..." ?

it's shit like this

Code: Select all

IDENTIFIER      ATTRIBUTE
-------------------------
100             AB
100             CD
100             EF
200             AB

Same client is like "nah there's no duplicates on this list." so yea

What does the full query look like?

I got this monstrosity to run

Code: Select all

update JM_NOVARTIS_WAVE2_MAY14 SMP
set EXP_SPEC = (
  select distinct EXP.SPEC_GRP
  from (
      select distinct EXP.MENUM10, EXP.SPEC_GRP
      from JM_NOV_EXPATCH_20140226 EXP
      JOIN JM_NOVARTIS_WAVE2_MAY14 SMP
      ON EXP.MENUM10 = SMP.MENUM10
      WHERE EXP.SPEC_GRP in
      ('CCM', 'EFM', 'EM', 'EN8', 'FP', 'FPG', 'GER',
      'GP', 'HOS', 'IFP', 'IM', 'IM7', 'MEM', 'MP',
      'PCC', 'PUD', 'N', 'N9', 'NS', 'NS9', 'P',
      'P9', 'PYG', 'PYN')
      and exp.menum10 <> '4954875012'
  ) EXP
  WHERE EXP.MENUM10 = SMP.MENUM10
);

If I understand that query, you're taking a daily file and comparing it to something from February and getting several specialty groups returned, then you're trying to update the daily file to set a specialty field to what could be any number of specialty groups, so it doesn't know which one you want to use. That query would be OK if MENUM10 and SPEC_GRP were tied together 1:1, but since they aren't, you're going to need more conditions on the highest WHERE.

never been to San Francisco?



Congrats - now you've got the general gist of it.

BigEd76 wrote:If I understand that query, you're taking a daily file and comparing it to something from February and getting several specialty groups returned, then you're trying to update the daily file to set a specialty field to what could be any number of specialty groups, so it doesn't know which one you want to use. I think you might need to return the EXP.MENUM10 in the second/higher subquery and add a second condition to the WHERE at the bottom

JM_NOV_EXPATCH_20140226 --client target list that was originally uploaded and matched in February
JM_NOVARTIS_WAVE2_MAY14 --table tracking recruitment results across 5 different studies for the same client

The SPEC_GRP in clause is there because, again, there are duplicates with different spec_grps.

In either case, it ran, I got it to work, and FFS people learn how to manage your fucking data before just taking a dump on a spreadsheet and emailing it off to someone

Need some advice regarding my little accident from yesterday... should I go through the claims process with my insurance company or with the at-fault driver's? First thing I did was open a claim with mine (state farm) on their website. Then I got a call from the representative saying I should go through the other driver's insurance company since it was their fault. So I opened a claim with them but haven't heard anything back. I called the adjuster a few minutes ago and she says she hasn't heard anything back from "the insured" so there's nothing they can do yet. Meanwhile my car is just sitting at my house because I can't bring it to a shop for an estimate and repairs until the adjuster gives me the okay. Shouldn't I be able to go through my own insurance company and have them deal with getting the claim stuff figured out with the other insurance company? Or would that make my premiums go up?

From what I understand, if you go through your insurance and they're able to get the amount from the at-fault insurance, then nothing happens to your premiums (unless your company suddenly thinks you're a risk to get hit again), but the best-case scenario would be for your insurance company to never know about it

Bucky wrote:Roomates find $41K CASH in couch from Salvation Army; track down owner and return it all

What would YOU do????

Lets be honest, they probably found like 100,000.

mickbayne wrote:Need some advice regarding my little accident from yesterday... should I go through the claims process with my insurance company or with the at-fault driver's? First thing I did was open a claim with mine (state farm) on their website. Then I got a call from the representative saying I should go through the other driver's insurance company since it was their fault. So I opened a claim with them but haven't heard anything back. I called the adjuster a few minutes ago and she says she hasn't heard anything back from "the insured" so there's nothing they can do yet. Meanwhile my car is just sitting at my house because I can't bring it to a shop for an estimate and repairs until the adjuster gives me the okay. Shouldn't I be able to go through my own insurance company and have them deal with getting the claim stuff figured out with the other insurance company? Or would that make my premiums go up?

If you go through your insurance, you probably have to pay the deductible. If you go through the ambulance insurance, you should have no deductible.

Thanks guys. I'll keep waiting for the other insurance company.

lethal wrote:

mickbayne wrote:Need some advice regarding my little accident from yesterday... should I go through the claims process with my insurance company or with the at-fault driver's? First thing I did was open a claim with mine (state farm) on their website. Then I got a call from the representative saying I should go through the other driver's insurance company since it was their fault. So I opened a claim with them but haven't heard anything back. I called the adjuster a few minutes ago and she says she hasn't heard anything back from "the insured" so there's nothing they can do yet. Meanwhile my car is just sitting at my house because I can't bring it to a shop for an estimate and repairs until the adjuster gives me the okay. Shouldn't I be able to go through my own insurance company and have them deal with getting the claim stuff figured out with the other insurance company? Or would that make my premiums go up?

If you go through your insurance, you probably have to pay the deductible. If you go through the ambulance insurance, you should have no deductible.

but then (eventually) you should get your deductible refunded by the at-fault operator's insurance company.

My insurance company, USAA (I qualified in Oklahoma in 1980) handles all that stuff. They better. Their clients are heavily armed.

Bucky wrote:

lethal wrote:

mickbayne wrote:Need some advice regarding my little accident from yesterday... should I go through the claims process with my insurance company or with the at-fault driver's? First thing I did was open a claim with mine (state farm) on their website. Then I got a call from the representative saying I should go through the other driver's insurance company since it was their fault. So I opened a claim with them but haven't heard anything back. I called the adjuster a few minutes ago and she says she hasn't heard anything back from "the insured" so there's nothing they can do yet. Meanwhile my car is just sitting at my house because I can't bring it to a shop for an estimate and repairs until the adjuster gives me the okay. Shouldn't I be able to go through my own insurance company and have them deal with getting the claim stuff figured out with the other insurance company? Or would that make my premiums go up?

If you go through your insurance, you probably have to pay the deductible. If you go through the ambulance insurance, you should have no deductible.

but then (eventually) you should get your deductible refunded by the at-fault operator's insurance company.

You're likely right. Only time I've ever been hit, both of us had geico and her car was worse off than mine, so she was sure to make the claim on her own car. Made it easy for me.

Allstate waives the deductible if another involved vehicle is also insured by Allstate. My recent 3-car crash- no other Allstate.

Bucky wrote:Allstate waives the deductible if another involved vehicle is also insured by Allstate. My recent 3-car crash- no other Allstate.

Well I hope you learned your lesson. Next time hit the gas and see if you can increase your odds.

swishnicholson wrote:

Bucky wrote:Allstate waives the deductible if another involved vehicle is also insured by Allstate. My recent 3-car crash- no other Allstate.

Well I hope you learned your lesson. Next time hit the gas and see if you can increase your odds.

HMMMMM. fair point there.

Got a flyer in the mail for a free haircut at a place that was more "sports bar than hair salon" and have been looking forward to it. The flyer says free drink and shoulder rub so I'm thinking beer and females because it's Friday and I'm feeling hedonistic. I get to the place and the drinks are water and it's a bunch of dudes. I'm slightly disappointed.

Haha haha, that's fucking awful.

what a shitty promo