Profile

Cover photo
Paul Basehore
Works at The Rock Church
Attends Georgia School of Ministry
Lives in Valdosta, Georgia
2,418 followers|576,923 views
AboutPostsPhotosVideosReviews

Stream

Paul Basehore

Shared publicly  - 
1
Add a comment...

Paul Basehore

Shared publicly  - 
 
This is awesome!
 
Stayin’ Alive: Metal Cover is your #MondayMotivation  earworm
I dunno what's better... a Staylin' Alive metal cover, or the fact that he's acting most of it out on what appear to be a toddler girl size drum set, guitar, and mic?!
3 comments on original post
1
Adam “Godlypus” Boenig's profile photo
 
I was haring this guy all day yesterday
Add a comment...

Paul Basehore

Shared publicly  - 
 
Why are GMOs Bad?

Why are GMOs bad? They aren’t. They just aren’t, not intrinsically, and certainly not for your health. We’ve been eating them for decades with no ill effects, which makes sense, because a genetically modified organism is simply an organism, like every other organism, produces hundreds of thousands of proteins, but one or two of them are proteins that were chosen specifically by humans.

This. Knowledge is power, and it's always wise to research claims -- especially those made about food -- before jumping on a bandwagon. We've been "genetically modifying" food for centuries. Originally, we did it through selective breeding, now we do it in a lab. Same concept.
16
Randal Skefingtonidis's profile photoHitch Medberg's profile photoKelly S's profile photoJoe Blow's profile photo
19 comments
 
+Paul Basehore yeah GMOs are safe but the cancer rate is still increasing!? make sense ...damn you're a SLAVE!
Add a comment...

Paul Basehore

Troubleshooting/Help  - 
 
Hey gang, I need help with a query.

I'm trying to write a report on all active cases for one of our courts. The way the data is set up in the table, though, looks like this:

Case# | Party Type | Name
12345 | Defendant | John Smith
12345 | Plaintiff     | Jane Doe

I need to write my query so those two rows can show up like two fields in my results, something like this:

Case# | Plaintiff   | Defendant
12345 | Jane Doe | John Smith

I know I could do this with a stored procedure, but that seems like overkill for such an otherwise-simple query. Any thoughts?
1
Martin Greaves's profile photoJudd Goswick's profile photoDaniel Decasse's profile photoPaul Basehore's profile photo
11 comments
 
Hey guys, I took all of your advice and figured out a query! I thought you guys would like to see it. I changed the names of the tables and fields to protect our data, but the structure is the important thing. I had to get a bit creative because SSRS requires the contents of my STUFF command to have an alias, which screwed up the FOR XML PATH. I also had to add a bunch of L- and RTRIMS to eliminate extra white space if the plaintiff/defendant is a business, not a person.

SELECT DISTINCT c.OriginalRecord, REPLACE(REPLACE(RTRIM(STUFF
                             ((SELECT DISTINCT ', ' + LTRIM(RTRIM(RTRIM(CP_NAME_FIRST) + ' ' + RTRIM(CP_NAME_MIDDLE) + ' ' + RTRIM(CP_NAME_LAST) + ' ' + RTRIM(CP_NAME_SUFFIX))) AS Expr1
                                 FROM            pcss.CaseParty AS p
                                 WHERE        (PARTY_TYPE = 'PLT') AND (OR = c.OriginalRecord) FOR XML PATH('')), 1, 2, '')), 'xpr1>, ', ''), '</Expr1>', '') AS 'Plaintiff', REPLACE(REPLACE(RTRIM(STUFF
                             ((SELECT DISTINCT ', ' + LTRIM(RTRIM(RTRIM(CP_NAME_FIRST) + ' ' + RTRIM(CP_NAME_MIDDLE) + ' ' + RTRIM(CP_NAME_LAST) + ' ' + RTRIM(CP_NAME_SUFFIX))) AS Expr1
                                 FROM            pcss.CaseParty AS d
                                 WHERE        (PARTY_TYPE = 'DEF') AND (OR = c.OriginalRecord) FOR XML PATH('')), 1, 2, '')), 'xpr1>, ', ''), '</Expr1>', '') AS 'Defendant', c.FileDate, c.CaseStatus
FROM            Case AS c INNER JOIN
                         CaseParty AS cp ON c.OriginalRecord = cp.OriginalRecord AND c.Court = cp.Court
WHERE        (c.Court = 'LCM')
ORDER BY FileDate
Add a comment...

Paul Basehore

Shared publicly  - 
 
Can't hurt.
 
You spoke. We listened. 
254 comments on original post
1
Add a comment...

Paul Basehore

Shared publicly  - 
 
Saw something similar as a T-shirt, tweaked it a bit, and had to share! #dbalife  
5
Ben E. Brady's profile photo
 
OMG... I needed this sign 10 years ago...
Add a comment...

Paul Basehore

Shared publicly  - 
 
Why programming sucks

Every programmer occasionally, when nobody's home, turns off the lights, pours a glass of scotch, puts on some light German electronica, and opens up a file on their computer. It's a different file for every programmer. Sometimes they wrote it, sometimes they found it and knew they had to save it. They read over the lines, and weep at their beauty, then the tears turn bitter as they remember the rest of the files and the inevitable collapse of all that is good and true in the world.
This file is Good Code. It has sensible and consistent names for functions and variables. It's concise. It doesn't do anything obviously stupid. It has never had to live in the wild, or answer to a sales team. It does exactly one, mundane, specific thing, and it does it well. It was written by a single person, and never touched by another. It reads like poetry written by someone over thirty.

Truly brilliant...
1
1
EMILIO MORILLAS's profile photo
Add a comment...

Paul Basehore

Shared publicly  - 
 
That moment when you see the reason your sole Linux server isn't mounting a drive properly is because it's listed in fstab as cifs, even though it's actually smb -- and has been since the server was installed
1
Add a comment...

Paul Basehore

Shared publicly  - 
 
OK, this is cool.
 
Solar system moving thru space. Pretty neat visual.
1 comment on original post
6
Thomas Sanjurjo's profile photoIyesni wayúšičA's profile photo
2 comments
 
Thanks +Thomas Sanjurjo​ that's good to know.
Add a comment...

Paul Basehore

Shared publicly  - 
 
CSS is terrible, and is proof that evil is still at work in our world.
That is all. #webdeveloperproblems  
3
Paul Basehore's profile photoJake Weisz's profile photo
3 comments
 
+Paul Basehore I don't know why people ever switched. Tables do exactly what you tell them to. 
Add a comment...

Paul Basehore

Shared publicly  - 
 
Now this is what I'm talking about! #bestofbothworlds   #windowsdeveloperonmac  
1
Add a comment...

Paul Basehore

Shared publicly  - 
 
This made me inordinately happy...
3
Jeremy Hodges's profile photo
 
I have a feeling +Danny Matchniff needs to see this.
Add a comment...
People
In his circles
2,657 people
Have him in circles
2,418 people
Brian Martinez's profile photo
Dark chris's profile photo
Koushick Sarkar's profile photo
Marina Mednik-Vaksman's profile photo
Samuel David's profile photo
ANTHONY JOHNSON's profile photo
Tran Quoc Hung's profile photo
Sam Wang's profile photo
Stephen OldPaths (Publications)'s profile photo
Education
  • Georgia School of Ministry
    Certificate of Ministry, 2013 - present
  • Mercer University
    Technical Communications, 2003 - 2007
Basic Information
Gender
Male
Other names
PJ, Opie
Story
Tagline
Self-described Google fanboy.
Introduction
Married to the woman of my dreams! We have a darling little girl and two sweet little boys who already have me wrapped around their fingers.

I was born to an engineer's family, so I'm very much a technophile. I wrote my first computer program in AmigaBASIC when I was 8, and I was able to touch-type before I learned how to write in cursive. Ever since, I've been learning as much as possible about computers and mobile devices. I currently work for my local county government as the database administrator and web interactive programmer.

I am a Christian, and I refuse to hide that fact. I would not have gotten where I am today without God's influence in my life. I thank Him every day for my many blessings, including my wife and children. I volunteer as the Youth Pastor for my church. I never thought I would ever enter the ministry -- but God had other plans!
Work
Occupation
Programmer, Youth Pastor
Employment
  • The Rock Church
    Youth Pastor, 2013 - present
  • Lowndes County Board of Commissioners
    Database Administrator, 2014 - present
  • ClientTell
    Implementation Specialist, 2011 - 2014
  • Hoshizaki America, Inc.
    Programmer/Analyst, 2007 - 2011
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Valdosta, Georgia
Previously
Newnan, Georgia - Sanford, Florida - Hampstead, New Hampshire - York, South Carolina - Macon, Georgia
Links
Contributor to
Always good service, even when things go wrong. They've "gone to bat" with the home owners to help us with repair situations, and have worked with us if our payday schedule made our rent one day late (more than that, though, and we paid the fees).
Public - 6 months ago
reviewed 6 months ago
Wow. Fall off the bone fried chicken with breading to die for. Excellent service; real friendly staff with down-home charm. Decor is understated with a country touch.
Food: ExcellentDecor: Very GoodService: Very Good
Public - 2 years ago
reviewed 2 years ago
The food was very good, but I felt overpriced. $27 for a fish filet, 12 shrimp, and 6 oysters with two vegetables seems a bit high to me. Definitely better than chain restaurants, though. Would recommend.
Food: Very GoodDecor: Very GoodService: Good
Public - 2 years ago
reviewed 2 years ago
Diamond in the rough. Outdoor seating provides excellent atmosphere. Very generous portion sizes at reasonable prices. Highly recommended!
Food: ExcellentDecor: ExcellentService: Excellent
Public - 3 years ago
reviewed 3 years ago
7 reviews
Map
Map
Map
The steak was good, but nothing really special. It's one of the rare restaurants that actually gives you a rare steak when you order it rare. The steak didn't have much flavor to it, but I added a bit of salt and it got better. Melt-in-your-mouth tender, which isn't easy to do for many steakhouses. Our server was awesome, though! Jamie was extremely patient with us since we had our infant daughter in tow. He helped us out and even got us some milk for her bottle. Overall, it's good, but a little pricey.
• • •
Food: Very GoodDecor: Very GoodService: Excellent
Public - 2 years ago
reviewed 2 years ago
Excellent food for cheap. Fast food, yes, but it's different than your normal burger and fries. Even their "half-size" meals will fill you up nicely for lunch.
Food: Very GoodDecor: GoodService: Very Good
Public - 2 years ago
reviewed 2 years ago
They advertise the "Best burgers on the planet", and they don't disappoint! Amazing burgers. The portions are very generous -- to the point where it's sometimes difficult to finish your meal. The burgers are always very juicy, but not greasy. They also serve hot dogs, chicken sandwiches, and other sandwiches, but they are most well-known for their burgers. The dining room and visible parts of the kitchen are always clean. There is a large poster of the original "Slap Daddy" on one wall, and a TV hanging from the ceiling; other than that, there isn't much in the way of decoration. There are many windows, though, that make up for it. The service is fast considering each sandwich is made to order. The staff are always polite and helpful. We have never had an issue with any of our meals.
• • •
Food: ExcellentDecor: Very GoodService: Excellent
Public - 3 years ago
reviewed 3 years ago