Quick & Simple Inner Join

Richard Lewis
A business partner approached me the other day looking to share information with my company. Since parts numbers are recycled more often than lame jokes in my business one of the things we needed the business partner to provide was the brand of the part. The business partner said that this would be difficult to do since they were unfamiliar with linking data across tables in any manner. After understanding a little about the setup of the partner’s tables I taught them to design a view linking the two primary tables where the data could be seen together through a view.

Meme 15 Why Did I Start Blogging

Richard Lewis
This month’s Meme15 assignment and the first was chosen by Jason Strate (Blog|Twitter) he posed the assignment of writing about why do I blog and why I started. I started blogging back in 2003 just about a one year after launching Gogorichie.com, back then it was the social network of its time along with AIM and YIM. As me and my high school friends went off to college we stayed in contact via our blogs.

T-SQL Tuesday 025 - My Favorite Little Trick

Richard Lewis
This month’s T-SQL Tuesday topic is from Allen White. He posed the question of what is my favorite little SQL trick. I can’t wait to see what tips the #SQLFamily write about. I discovered one of my favorite tricks last year, just a little background my first SQL version I started out administrating and developing on 8 years ago was SQL 2000 back then to get table statistics was no easy task.

Meme Monday: What SQLFamily Means To Me

Richard Lewis
I saw this topic a few weeks back on @sqlrockstar’s site but never got around to writing a post. I’ve been in working on databases for about 6 years now a mixture of Access, SQL, Teradata, and MySQL. So when I saw the topic thoughts began to flow through my brain. What does the SQL Family mean to me?? it means that there is a network of people with the same interest, challenged by the same problems as me.

Nothing But Nets News Flash !!!!!!!!!!!!!!!!!!!!

Richard Lewis
Great News Everyone, I talked to Anthony Colletti today via email. He’s in Brussels Belgium at the JCI World Congress and said that were *#3 in the WORLD* for JCI organizations in raising money for Nothing But Nets !!!!! just think how much more we can achieve by the end of the year. For every $10 we raise we save a life from Malaria donate at http://bit.ly/ut25Oh Richard Lewis 2011 Website Program Manager – United States Jaycees

Nothing But Nets Fundraising Update

Richard Lewis
What an awesome GA we had this past weekend!!! Saturday during Lunch Anthony Colletti spoke about how close we are the our 2011 Nothing But Nets goal and our chapters STEPPED UP big time…to the tune of $1051.00 in pledges and donations. A big thanks goes out to all those chapters Mount Prospect, Gurnee/Lindenhurst, Bolingbrook, Chatham, Woodstock, Lombard, and Woodridge. Once we receive all the checks we will be only $289 away from our goal !

Bringing the T.K.O

Richard Lewis
Last friday was exciting I announced my candidacy for 2012 Area One Vice President of the Illinois Jaycees. I believe that we can grow our area with outstanding Training held locally, We can use the Knowledge of our members and our networks to strengthen our area, and We can retain our members through all the Opportunities our organization have to offer. Like my page on Facebook at http://www.facebook.com/Voteforrichard and follow my campaign.

Jaycees and Politics

Richard Lewis
As Jaycee members we have a long history of driving change in our communities across the country and all through our grassroots skills and efforts. For example, when a group of young business men in the Los Angeles area were dissatisfied with their representation in congress they sought out a candidate and came across a young who was a Jaycee their first reaction was here is a young man who has been through the best training in the world.

The Founding Of The Abbeville Jaycees

Richard Lewis
Over the weekend I read another chapter of the book Young Men Can Change The World. I came across another great story this one of how the Abbeville Jaycees was founded. The story was a recount of the adventure of at the time U.S. Jaycees National Vice President Robert E. Condon who at the age of 29 also held the position of civil defense commissioner for the greater New York metro area.

Outstanding Young Farmers

Richard Lewis
Since 1954 Outstanding Young Farmers has been a signature program of the US Jaycees and believe it or not we’ve got very little to do with. now i know that’s hard to believe that the largest Jaycee state and is covered by 80% of farm land hasn’t Produce an Outstanding Young Farmer since 2008. Well that changes this year, because our states goal is to submit 5 outstanding candidates for this award.