Print

[razgueado]

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.

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.

F'n index children, amiright?

F'n A right.

[razgueado]

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.

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.

F'n index children, amiright?

And it's worth pointing out, for Tex's sake, that this is all a bunch of welfare data.  Pure communist database.

[Travellin Dave]

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.

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?

[Travellin Dave]

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.

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.

F'n index children, amiright?

And it's worth pointing out, for Tex's sake, that this is all a bunch of welfare data.  Pure communist database.

That part we could have guessed.

[A Friend of Charlie]

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.

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.

F'n index children, amiright?

LMFAO!  Thanks, Mark.

[Threebean]

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.

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?

What do you mean, I got it.  Well, the fuster-cluck part, anyway.

[A Friend of Charlie]

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.

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.

F'n index children, amiright?

And it's worth pointing out, for Tex's sake, that this is all a bunch of welfare data.  Pure communist database.

What happens if they don't have a child?

[A Friend of Charlie]

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.

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 knew exactly what he was talking about but wouldn't have the first clue as how to solve the problem.  The correct response is, "good job Raz".

[razgueado]

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.

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.

F'n index children, amiright?

And it's worth pointing out, for Tex's sake, that this is all a bunch of welfare data.  Pure communist database.

What happens if they don't have a child?

Well, since this is a database of information about mothers, infants, and early childhood home visits, not having a child is not a business case I have to deal with.

[Threebean]

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.

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.

F'n index children, amiright?

And it's worth pointing out, for Tex's sake, that this is all a bunch of welfare data.  Pure communist database.

What happens if they don't have a child?

Then you write the code to return a "GFY". 

[A Friend of Charlie]

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.

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.

F'n index children, amiright?

And it's worth pointing out, for Tex's sake, that this is all a bunch of welfare data.  Pure communist database.

What happens if they don't have a child?

Well, since this is a database of information about mothers, infants, and early childhood home visits, not having a child is not a business case I have to deal with.

How about if the welfare recipient simply identifies themselves as a mother of an infant?

[CigarGuy87]

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.

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.

[A Friend of Charlie]

I'm calling it a day.  Ciao.

[Threebean]

I'm calling it a day.  Ciao.

Have a great evening, Mr. Mayor.  Hope you get to do something mayoral, like smoke a cigar.

[razgueado]

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.

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.

F'n index children, amiright?

And it's worth pointing out, for Tex's sake, that this is all a bunch of welfare data.  Pure communist database.

What happens if they don't have a child?

Well, since this is a database of information about mothers, infants, and early childhood home visits, not having a child is not a business case I have to deal with.

How about if the welfare recipient simply identifies themselves as a mother of an infant?

We shoot them.

Okay, we don't.  Again, this is tracking home visits by nurses or other social workers.  If the nurse or social worker doesn't see the child, the home visit isn't completed and doesn't count.