Democract Senator's Daughter cranks up price of EpiPen
Comments
-
We have a few commies on here competing with Ozone but they're not quite as red.PurpleJ said:Surely there is a competing product that I could buy?
-
makes sense but I think the data would be more accurate if you used and innerjoin.OZONE said:
You could join them (they aren't really separate tables) using subqueries like this to return their respective rows as separate virtual tables:DeepSeaZ said:
SELECT *
FROM
( SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ' ) as P
FULL OUTER JOIN
( SELECT * FROM HardcoreHusky.Members WHERE Name = 'Splooge' ) as S
But unless they share a common key or attribute on which to join, you will just get a cartesian product -- AND NOBODY wants a cartesian product of PurpleJ or Splooge, so it would be best to use a union to just show their rows as follows:
INSERT INTO HardcoreHusky.Junk
SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ'
UNION ALL
SELECT * FROM HardcoreHusky.Members WHERE Name = 'Splooge'
Leave off the INSERT clause if you actually want to see the rows instead of putting them where they belong. -
Accuracy depends on what data you want. Again, is there a key or attribute in the table that joins Purp to Splooge? If not, then there is nothing to join, which is when you'd use the union instead.DeepSeaZ said:
makes sense but I think the data would be more accurate if you used and innerjoin.
OZONE said:
You could join them (they aren't really separate tables) using subqueries like this to return their respective rows as separate virtual tables:DeepSeaZ said:
SELECT *
FROM
( SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ' ) as P
FULL OUTER JOIN
( SELECT * FROM HardcoreHusky.Members WHERE Name = 'Splooge' ) as S
But unless they share a common key or attribute on which to join, you will just get a cartesian product -- AND NOBODY wants a cartesian product of PurpleJ or Splooge, so it would be best to use a union to just show their rows as follows:
INSERT INTO HardcoreHusky.Junk
SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ'
UNION ALL
SELECT * FROM HardcoreHusky.Members WHERE Name = 'Splooge'
Leave off the INSERT clause if you actually want to see the rows instead of putting them where they belong. -
Is it as interesting as Martin Shkreli endorsing Trump?HoustonHusky said:Kinda crazy story...no clue how this minor detail isn't being talked about. The CEO of Mylan is Heather Bresch, who happens to be the daughter of WV Democratic Senator Joe Manchin (wonder who helps sponsor some of the govt requirements for the Epipen use...). She also managed to up her own salary something like 900% while cranking up the price.
http://www.cnn.com/2016/08/23/health/epipen-price-mylan-prescription-drugs-increase/index.html
http://www.forbes.com/sites/kellyphillipserb/2016/08/24/that-400-epipen-price-hike-could-hit-your-wallet-even-if-you-dont-need-one/2/#23084cf84176
Small beans compared to the Clinton Foundation, but interesting none-the-less...
http://www.nydailynews.com/news/national/pharma-bro-martin-shkreli-endorses-donald-trump-article-1.2651758
"Shkreli, who is currently awaiting trial for securities fraud, said later that “all you people who don't like trump are jealous, stupid and poor! don't make me laugh!”
"
-
Great post. I laughed. So to put it in dork so the geeks can get some use and excitement.Swaye said:I'm sitting at my IBM 386 about to finger blast my ass while looking at midget porn. I thought we were all supposed to share. No?
SELECT *
FROM hot.midgets WHERE height < 49 AND weight > 250
Looks like the SQL derail is alive and well -
Why do you fags hate patents? Injecting with a vial of epinephrine and a syringe is always an option if you're poor
HTH -
NTD, BBttu_85 said:
Great post. I laughed. So to put it in dork so the geeks can get some use and excitement.Swaye said:I'm sitting at my IBM 386 about to finger blast my ass while looking at midget porn. I thought we were all supposed to share. No?
SELECT *
FROM hot.midgets WHERE height < 49 AND weight > 250
Looks like the SQL derail is alive and well -
Work for a company that still has shit floating around on VSAM and IDMS then pop off
-
Some Kind of Computer Stuff Superiority Guy.OZONE said:
Actually, companies with money that know what they are doing tend to use Oracle or Teradata or Netteza or DB2, etc.TierbsHsotBoobs said:
SQL Server is what companies with money typically use.ttu_85 said:
So you must be a Dbase III guy.TierbsHsotBoobs said:
MySql?ttu_85 said:
Hahaha, oh good lord this is getting good. Lets see. I am setting at my desk running test on a MySql database 34 miles north of Austin Texas. And where are you ? Has 8th grade started in Washington state yet? Still out for summer break ?.dflea said:
Where the fuck do you think you are, Texan?ttu_85 said:
Maybe if you are a faggot ????. Another 8th grade level intellect on display. Care to offer an interesting insightful rebuttal. I bet thats to much to ask .dflea said:
Interesting?HoustonHusky said:Kinda crazy story...no clue how this minor detail isn't being talked about. The CEO of Mylan is Heather Bresch, who happens to be the daughter of WV Democratic Senator Joe Manchin (wonder who helps sponsor some of the govt requirements for the Epipen use...). She also managed to up her own salary something like 900% while cranking up the price.
http://www.cnn.com/2016/08/23/health/epipen-price-mylan-prescription-drugs-increase/index.html
http://www.forbes.com/sites/kellyphillipserb/2016/08/24/that-400-epipen-price-hike-could-hit-your-wallet-even-if-you-dont-need-one/2/#23084cf84176
Small beans compared to the Clinton Foundation, but interesting none-the-less...
Maybe if you're a faggot.
CHRIST.
SQL Server is for companies with money that don't know what they are doing and so some MSFT consultant points them at SQL Server.
Source: I was a SQL Server dev at MSFT for 8 years, and have been doing SQL on various platforms for 20 years. -
I don't know what any of this means but it had upvotes so I went with the crowd.whlinder said:Work for a company that still has shit floating around on VSAM and IDMS then pop off
#lemming
