Quote from: razgueado on September 25, 2015, 03:39:42 PMQuote from: A Friend of Charlie on September 25, 2015, 03:33:31 PMQuote from: razgueado on September 25, 2015, 03:30:30 PMIt took a day-and-a-half of banging my head on the desk, but I figured out how to write this damned query. Sheesh.SQL?Yeah. Had to select which of one or more children of a particular guardian has the birthdate closest to the guardian's enroll date.Sounds like the same stuff I do, lots of medical SQLs for the important people.
Quote from: A Friend of Charlie on September 25, 2015, 03:33:31 PMQuote from: razgueado on September 25, 2015, 03:30:30 PMIt took a day-and-a-half of banging my head on the desk, but I figured out how to write this damned query. Sheesh.SQL?Yeah. Had to select which of one or more children of a particular guardian has the birthdate closest to the guardian's enroll date.
Quote from: razgueado on September 25, 2015, 03:30:30 PMIt took a day-and-a-half of banging my head on the desk, but I figured out how to write this damned query. Sheesh.SQL?
It took a day-and-a-half of banging my head on the desk, but I figured out how to write this damned query. Sheesh.
Quote from: razgueado on September 25, 2015, 04:17:52 PMQuote from: A Friend of Charlie on September 25, 2015, 03:42:36 PMQuote from: razgueado on September 25, 2015, 03:39:42 PMQuote from: A Friend of Charlie on September 25, 2015, 03:33:31 PMQuote from: razgueado on September 25, 2015, 03:30:30 PMIt took a day-and-a-half of banging my head on the desk, but I figured out how to write this damned query. Sheesh.SQL?Yeah. Had to select which of one or more children of a particular guardian has the birthdate closest to the guardian's enroll date.Definitely not my forte. I was dealing with a proxy server issue. Gee, I hate Windows.Would have been easy in a properly normalized database, or if I could just write some C# code. As it was, this was all coming from one query, and my query had to replace another query and have the same fields but return the index child correctly. So, required a self-join to an aggregate query, and one of the join conditions had to be the return value of an aggregate function. Total fuster-cluck. But I did it.Should we just not an act like we have a fukkin' clue what the hell he's talking about?
Quote from: A Friend of Charlie on September 25, 2015, 03:42:36 PMQuote from: razgueado on September 25, 2015, 03:39:42 PMQuote from: A Friend of Charlie on September 25, 2015, 03:33:31 PMQuote from: razgueado on September 25, 2015, 03:30:30 PMIt took a day-and-a-half of banging my head on the desk, but I figured out how to write this damned query. Sheesh.SQL?Yeah. Had to select which of one or more children of a particular guardian has the birthdate closest to the guardian's enroll date.Definitely not my forte. I was dealing with a proxy server issue. Gee, I hate Windows.Would have been easy in a properly normalized database, or if I could just write some C# code. As it was, this was all coming from one query, and my query had to replace another query and have the same fields but return the index child correctly. So, required a self-join to an aggregate query, and one of the join conditions had to be the return value of an aggregate function. Total fuster-cluck. But I did it.
Quote from: razgueado on September 25, 2015, 03:39:42 PMQuote from: A Friend of Charlie on September 25, 2015, 03:33:31 PMQuote from: razgueado on September 25, 2015, 03:30:30 PMIt took a day-and-a-half of banging my head on the desk, but I figured out how to write this damned query. Sheesh.SQL?Yeah. Had to select which of one or more children of a particular guardian has the birthdate closest to the guardian's enroll date.Definitely not my forte. I was dealing with a proxy server issue. Gee, I hate Windows.
Quote from: CigarGuy87 on September 25, 2015, 05:10:33 PMQuote from: razgueado on September 25, 2015, 03:39:42 PMQuote from: A Friend of Charlie on September 25, 2015, 03:33:31 PMQuote from: razgueado on September 25, 2015, 03:30:30 PMIt took a day-and-a-half of banging my head on the desk, but I figured out how to write this damned query. Sheesh.SQL?Yeah. Had to select which of one or more children of a particular guardian has the birthdate closest to the guardian's enroll date.Sounds like the same stuff I do, lots of medical SQLs for the important people.Cigar smokers?
Quote from: Travellin Dave on September 25, 2015, 04:54:06 PMQuote from: razgueado on September 25, 2015, 04:17:52 PMQuote from: A Friend of Charlie on September 25, 2015, 03:42:36 PMQuote from: razgueado on September 25, 2015, 03:39:42 PMQuote from: A Friend of Charlie on September 25, 2015, 03:33:31 PMQuote from: razgueado on September 25, 2015, 03:30:30 PMIt took a day-and-a-half of banging my head on the desk, but I figured out how to write this damned query. Sheesh.SQL?Yeah. Had to select which of one or more children of a particular guardian has the birthdate closest to the guardian's enroll date.Definitely not my forte. I was dealing with a proxy server issue. Gee, I hate Windows.Would have been easy in a properly normalized database, or if I could just write some C# code. As it was, this was all coming from one query, and my query had to replace another query and have the same fields but return the index child correctly. So, required a self-join to an aggregate query, and one of the join conditions had to be the return value of an aggregate function. Total fuster-cluck. But I did it.Should we just not an act like we have a fukkin' clue what the hell he's talking about?I don't have to act I don't know WTF he is talking about except welfare which is more than I wanted to know anyway.
I feel like I just got out of the ring with Floyd Mayweather.
Hey, Tex...what's your opinion of Dan Post boots? Finally time to order a new pair, Lucchese doesn't have what I want for under $1200 and Dan Post does. Any thoughts from a Texan?
Quote from: Texas Redfish on September 25, 2015, 05:35:16 PMI feel like I just got out of the ring with Floyd Mayweather.Time for drugs.
Quote from: razgueado on September 25, 2015, 05:45:02 PMHey, Tex...what's your opinion of Dan Post boots? Finally time to order a new pair, Lucchese doesn't have what I want for under $1200 and Dan Post does. Any thoughts from a Texan?You're an IT guy in the NW. Aren't you supposed to wear Crocs?
Quote from: Threebean on September 25, 2015, 05:48:55 PMQuote from: razgueado on September 25, 2015, 05:45:02 PMHey, Tex...what's your opinion of Dan Post boots? Finally time to order a new pair, Lucchese doesn't have what I want for under $1200 and Dan Post does. Any thoughts from a Texan?You're an IT guy in the NW. Aren't you supposed to wear Crocs? Uh-huh. Uh-huh. Not gonna happen.But you can't judge by me anyhow. Most of the time, I dress like it's 1955.
Quote from: Texas Redfish on September 25, 2015, 05:35:16 PMI feel like I just got out of the ring with Floyd Mayweather.Makes sense, you guys are probably the same weight class