What are you doing? that’s a question that you are probably asked dozens of time a day. How many of you use the Facebook status function each day? How many of you use it more than once each day? Well, this year the North Region Jaycees are trying something new and we will be using a free service named Twitter to communicate all kinds of one line answers, event postings, random thoughts, and newsflashes about articles recently added to the Region’s website www.

So the other day my former team member call me asking for help. She had inserted the same data into a table three or more times and needed to get rid of them. For those of you with duplications and need to delete them here’s a little statement i came up with and gave her. DELETE FROM TBL_Employees WHERE (EmpID IN (SELECT MAX(EmpID) AS Expr2 FROM TBL_Employees GROUP BY FirstName

Each year being in the Jaycees brings something exciting to do and well 2010 is no different. This year in addition to serving on my state’s board and the US Jaycees board I’ve decided to create my own personal challenge for myself. That is to be come a tenth degree Jaycee in the course of the year. The degree program is designed to build great leaders. It starts off at with the basics getting a person socially involved to develop the social and networking skills and then progress over time to the point of where the person is heading up committees, chapter, districts, and states.

From time to time i run into problems of where some new table appears on m server and starts eating up all my space. Well i came across this blog posting a while back that does a great job of explaining how to determine the table sizes in a database in SQL 2000 it works in 2005 too. check it out and let me know what you think. http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121/determing-sql-server-table-size.aspx

Earlier this month i attended my first SQL meetup called SQL Saturday #31 i’m not sure why it’s numbered 31 cause i realized they don’t go in order. But yeah so it was hosted in Elk Grove so it wasn’t to far away. I knew it was going to be a awesome day when i met this guy in the registration line who reads my site and learned a couple SQL tricks from it.

I got a request for a report the other day so I built this massive 90 line SQL statement to pull all the data requested. So I sent off a copy of the data report and the guy tells me that he needs the date formatted (YYYYMMDD) instead of (YYYY-MM-DD-HHMMSS) and then he was like is that going to be a problem and I was like ha not really. Give me a moment and I’ll send you a simple.