September 20, 2016 at 4:28 am
jasona.work (9/19/2016)
Jeff Moden (9/19/2016)
More like "people" season. Some people just don't get it. See the following where what someone is doing actually could kill people. I've confirmed Sergiy's findings with the given test data.http://www.sqlservercentral.com/Forums/Topic1818451-3077-1.aspx
Medical profession and system is going to hell in a handbasket. I remember being in the hospital for my heart and they took my blood pressure. It was 90 over 60. The nurse handed me a cupful of pills and so I asked what they were. Two of the pills were to lower my blood pressure. I'd probably have died if I'd taken them. :Whistling:
I have to wonder how many flawed systems such as the one in that post, are out there "in the wild." Especially with the rush for practices to get on EHRs / EMRs about 3-4 years ago (practices, if I recall, would get a payment from the Gov if they went to an EHR and got certified in a fairly short amount of time, which led to a rush of companies pushing out EHR systems.) So, you had companies either "whipping up" something in a very short time, shoehorning features to qualify into an existing product, or jumping into using back-end software they had little or no experience with.
There's two industries that really, really need to be as close to bullet-proof as possible with their systems:
1. Drs / hospitals
2. Self-driving cars
Can you imagine what would end up on the roads if the NHTSA announced incentives for companies who could show "meaningful use" of self-driving cars / trucks? You'd have companies home-brewing bolt-on kits to "drive" these things (using what pretty much happened with the EHR incentives) with almost no testing...
My first job, 20+ years ago, was working on air traffic control systems. Specifically, something called a "short term conflict alert" system, ie something to make sure the dots don't bang into each other... Bullet-proof, jumbo-jet-proof... 😉
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 20, 2016 at 5:30 am
Jeff Moden (9/19/2016)
More like "people" season. Some people just don't get it. See the following where what someone is doing actually could kill people. I've confirmed Sergiy's findings with the given test data.http://www.sqlservercentral.com/Forums/Topic1818451-3077-1.aspx
Medical profession and system is going to hell in a handbasket. I remember being in the hospital for my heart and they took my blood pressure. It was 90 over 60. The nurse handed me a cupful of pills and so I asked what they were. Two of the pills were to lower my blood pressure. I'd probably have died if I'd taken them. :Whistling:
YIKES! I wonder how many people take drugs like that without asking or without being told.
Your bp is about the same as mine. I keep freaking out the blood alliance when I go to donate. 90 over 60 is their low cut off and I have to tell them this is my normal so they don't turn me away.
September 20, 2016 at 5:43 am
Jeff Moden (9/19/2016)
Interesting on both. I'd love to see the trigger code for those.
I have to ask the person who designed it if he minds it being shared. Usually, he doesn't like code he designed being passed out on the internet, though.
Not that the code itself is really that difficult. Anyone could probably figure it out after a little testing, but I have to respect the authorship and ownership here.
September 20, 2016 at 5:47 am
And here's your ranch error of the day for those who like farming, being a rancher, or cows.
Beware the cows, for they are clever and will get even for all the tipping that has been done to them.
September 20, 2016 at 5:59 am
David Burrows (9/19/2016)
Ed Wagner (9/19/2016)
ChrisM@Work (9/19/2016)
Eirikur Eiriksson (9/18/2016)
Now where is that crystal ball again?😎
You're going to need a pair of those. The OP (or should that be "perp"?) has been posting for over three years yet somehow avoided creating a single table in that time 🙂
My compliments on the way you handled it. Maybe an alternative identity for SS.
+1
My solution would involve joining the table to itself but since the OP said it was a huge table I refrained as the performance would be horrendous.
So I will defer to the experts 😀
And just for fun, a basic (not knowing full data profile) rough and ready solution on a 12 million row heap took 8.5 minutes on my SQL2008R2 dev server.
😎
Far away is close at hand in the images of elsewhere.
Anon.
September 20, 2016 at 8:43 am
So today at work, they had a car cruise around the property for employees. Staff could sign their cars up for either static display or to be part of the cruise (which included being in the static display.) Saw plenty of cool cars, LOTS of American muscle (Corvettes and Mustangs galore,) one Ferrari Testarossa, a bunch of Willys', a Bradley and an Abrams...:-D
I'm thinking if they do this again next year, I'll put my car on the list for the cruise (Subaru BRZ)
September 20, 2016 at 8:44 am
Brandie Tarvin (9/20/2016)
Jeff Moden (9/19/2016)
More like "people" season. Some people just don't get it. See the following where what someone is doing actually could kill people. I've confirmed Sergiy's findings with the given test data.http://www.sqlservercentral.com/Forums/Topic1818451-3077-1.aspx
Medical profession and system is going to hell in a handbasket. I remember being in the hospital for my heart and they took my blood pressure. It was 90 over 60. The nurse handed me a cupful of pills and so I asked what they were. Two of the pills were to lower my blood pressure. I'd probably have died if I'd taken them. :Whistling:
YIKES! I wonder how many people take drugs like that without asking or without being told.
Your bp is about the same as mine. I keep freaking out the blood alliance when I go to donate. 90 over 60 is their low cut off and I have to tell them this is my normal so they don't turn me away.
That would probably never happen in Mexico. The hospital wouldn't have any pills. :hehe:
September 20, 2016 at 9:50 am
New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26
But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read better and it would just annoy me as it is. I might just have to get it printed elsewhere.
September 20, 2016 at 9:56 am
BrainDonor (9/20/2016)
New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read better and it would just annoy me as it is. I might just have to get it printed elsewhere.
Yep, that should be a comma.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
September 20, 2016 at 9:58 am
BrainDonor (9/20/2016)
New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read better and it would just annoy me as it is. I might just have to get it printed elsewhere.
Yes, it should be a comma. The first part is a dependent clause, which means that it does not express a complete thought and cannot stand on its own.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
September 20, 2016 at 10:48 am
drew.allen (9/20/2016)
BrainDonor (9/20/2016)
New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read better and it would just annoy me as it is. I might just have to get it printed elsewhere.
Yes, it should be a comma. The first part is a dependent clause, which means that it does not express a complete thought and cannot stand on its own.
Drew
Guess they weren't thinking.
September 20, 2016 at 10:50 am
BrainDonor (9/20/2016)
New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read better and it would just annoy me as it is. I might just have to get it printed elsewhere.
One of my all-time favorites: http://www.thinkgeek.com/product/595d/
September 20, 2016 at 11:09 am
Phil Parkin (9/20/2016)
BrainDonor (9/20/2016)
New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read better and it would just annoy me as it is. I might just have to get it printed elsewhere.
Yep, that should be a comma.
No, a comma is nearly as bad as a full stop, no punctuation is needed at that point.
Tom
September 20, 2016 at 12:19 pm
TomThomson (9/20/2016)
Phil Parkin (9/20/2016)
BrainDonor (9/20/2016)
New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read better and it would just annoy me as it is. I might just have to get it printed elsewhere.
Yep, that should be a comma.
No, a comma is nearly as bad as a full stop, no punctuation is needed at that point.
Actually the editor in me is rewriting the whole sentence(s).
It would be great if the next trend could be thinking.
The next trend should be thinking!
Thinking is the next trend!
Etcetera, etcetera, etcetera.
September 20, 2016 at 1:10 pm
TomThomson (9/20/2016)
Phil Parkin (9/20/2016)
BrainDonor (9/20/2016)
New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read better and it would just annoy me as it is. I might just have to get it printed elsewhere.
Yep, that should be a comma.
No, a comma is nearly as bad as a full stop, no punctuation is needed at that point.
Without punctuation, the meaning becomes: "If the next trend could be 'thinking that would be great'". Presumably not the intention.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 15 posts - 55,891 through 55,905 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply