Profile

Cover photo
Paul Basehore
Works at The Rock Church
Attends Georgia School of Ministry
Lives in Valdosta, Georgia
2,421 followers|574,560 views
AboutPostsPhotosVideosReviews

Stream

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?!
1
Adam “Godlypus” Boenig's profile photo
 
I was haring this guy all day yesterday
Add a comment...

Paul Basehore

Shared publicly  - 
 
OK, this is cool.
 
Solar system moving thru space. Pretty neat visual.
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

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. 
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  - 
 
I lol'd. #dbahumor  
6
1
Derrick Devine's profile photoLuke Brady's profile photo
Add a comment...
Have him in circles
2,421 people
H.C. Armstrong's profile photo
HORACE POSTCODE's profile photo
Katy Davies's profile photo
Stephen OldPaths (Publications)'s profile photo
Litany Bergeron's profile photo
Zak Rent A Car's profile photo
movies 19+'s profile photo
Sarah Tun's profile photo
DORA and FRIENDS's profile photo

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  - 
 
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.
8
Florian Lang's profile photoTom Ziesmer's profile photoPaul Basehore's profile photoTerrence Gordon's profile photo
15 comments
 
+Tom Ziesmer According to the EPA and European Food Safety Authority, Roundup isn't all that bad.. Also, human toxicity for roundup has been observed from 85ml to 200ml so in theory a teaspoon of roundup would be uncomfortable, but unlikely to kill. Pesticides are much more of a problem, as 9 of the 12 most dangerous and persistent chemicals are pesticides.
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...

Paul Basehore

Shared publicly  - 
 
This is brilliant! I want this blade...
 
I'm not a woodworker, but this was fascinating to me.  Great idea.  
1
Extra Mile Boys's profile photo
 
I see what you mean. The video demonstrated it well.
Add a comment...
People
Have him in circles
2,421 people
H.C. Armstrong's profile photo
HORACE POSTCODE's profile photo
Katy Davies's profile photo
Stephen OldPaths (Publications)'s profile photo
Litany Bergeron's profile photo
Zak Rent A Car's profile photo
movies 19+'s profile photo
Sarah Tun's profile photo
DORA and FRIENDS'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 - 5 months ago
reviewed 5 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 - 2 years ago
reviewed 2 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