Blogging « Just A Bunch Of Gogorichie

Quick & Simple Inner Join

Filed in Blogging | SQL | Work Leave a comment

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. Since their tables where normalized all they needed was an INNER JOIN statement to make this happen. Below is a sample of the statement i wrote for the partner.

SELECT Inventory.[Prt#], Cross.Brand, Inventory.[OH-QTY], Inventory.Desc, Inventory.[Alloc-QTY], Inventory.[Pkg-QTY], Inventory.Cost, Inventory.Lstupdt

FROM [Cross] INNER JOIN Inventory ON Cross.[Brand-ID] = Inventory.[Brand-ID]

See what I mean by quick and simple inner join.

15Dec

#Meme15 Why Did I Start Blogging

Filed in Blogging | SQL 1 Comment

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. You know this topic made me go back to the very beginning and read my very first blog posting. It brought up memories of living in LA and the good times I had out there. Wait most of those post were written after coming home from a night out so a lot of the postings were run but all fun.

These days I still blog for many different reasons. I put together for my top reasons why and here’s what I came up with.

Documenting key moments in my life still. 2010 In Review
Sharing a solution to a problem that I’ve come across while programming. USING DATEDIFF TO CONTROL CONTENT
Share my opinion on a product or tool. THE DAY AFTER THE 120 DAYS ARE UP
Share my thoughts with the world and advice. HOW TO SPEND 10 DOLLARS

After all these years of blogging i still have fun and love sharing stuff on my blog.

05Dec

Meme Monday: All I Want For Christmas

Filed in Blogging | Microsoft | SQL | Windows Home Server | Xbox 360 1 Comment

Thomas LaRock (blog|Twitter) came up with another fun topic to write about this month. What I want from Microsoft for Christmas I can’t wait to see what all my #sqlfamily peeps write about.

Well this is an interesting topic cause I’m not a devoted fan of Microsoft products. I do have my favorites Xbox 360, Windows Home Server at home and SQL 2000,2005,2008 and Express at work. I can do without office products, and the OS’s and oh yes I said Express, it’s my secret little favorite local database tool. At work getting stuff done with Access only would kill me so I cache what I need locally using SQL Express, design tables there and do a lot of data cleansing using and I mean a lot of freaking cleansing. But yeah all want I want for christmas from Santa Ballmer and Microsoft is a great reason to upgrade all my home computers to Windows 8. That’s simple enough right ????? maybe Santa will bring that oh and Roku box for my wife.

25Nov

Meme Monday: What #SQLFamily Means To Me

Filed in Blogging | SQL Leave a comment

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. Now with my discovery of twitter, hence the hashtag I’ve been able to discovered the family and discovered local events such as the user groups in Chicago and SQL Saturday’s events and many others including a yearly cruise. Now when i need help with programming question I can turn to the #sqlfamily, the people are so cool that when its someone’s birthday or other special occasion they get acknowledged by the #sqlfamily or even a sad event the family member off words of comfort.

04Apr