Welcome to my online portfolio, the complement/substitute for my resume. The opinions included herein are my own and do not reflect those of any client or employer, past or present. Please check out the new site: http://danieljohnsonjr.com

Thursday, August 28, 2008

Awesome time at LinkedCincinnati LIVE last night



Mobile post sent by danieljohnsonjr using Utterzreply-count Replies.

-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read

Related tags:

Wednesday, August 27, 2008

LinkedCincinnatiLIVE Tonight!


Tonight I and over 200 other folks from the Greater Cincinnati area will be meeting together for LinkedCincinnatiLIVE (more details below). I am so glad, too, that my schedule freed up at the last minute for me to do so. I hope to connect with as many of you as possible.

Here is a recent picture of me, in case you're looking to connect:

LinkedCincinnati LIVE - Details

If you have not signed up for LinkedCincinnatiLIVE tonight, August 27th, you need to do so right away! Over 200 attendees have pre-registered, and we’ve got some seriously incredible items up for grabs in the silent auction.

For those in the local recruiting community, we have a FULL ADMISSION ticket to SourceCon 2008 in Atlanta in just one week for auction, a FULL ACCESS ticket to ERE’s Fall Expo in Hollywood Beach, FL at the end of October, AND a ticket to RecruitFest coming up in Toronto on Sept. 19th. The RecruitFest ticket is worth $220, the SourceCon admission ticket at $1,195 and the ERE Fall Expo ticket at over $2,000. You’ll want to make sure to come to LinkedCincinnatiLIVE and put your bid in for one of these can’t-miss events!

In addition to these event tickets, we have some really cool things that will be on the auction tables, including:

  • Design/promotional/marketing consulting services
  • Recruiting services
  • SEO consulting services
  • DBA services
  • Skin consultation services
  • A B&B weekend package in WV
  • A guided upland hunting trip
  • Books written by some of our attendees
  • A private flight tour from a local pilot
  • …and much more!
The silent auction is optional participation, and money raised from these auctioned items will go to help fund an aid trip to South Africa being taken by two LinkedCincinnati members, Jennifer McClure and Amybeth Hale. The $5 door cover will go to offset the facility rental and refreshments and will enter you into a raffle drawing during the course of the event. Cash bar will be available: soft drinks: $1.95, beer: $3.25-$3.75, wine: $5.00, cocktails: $5.50+.

Our auction items range in cost from around $10 all the way up to $3500 so there is something for everyone to check out. Business owners and managers, consider bidding on some of the consultative services for your company.

Don’t miss this opportunity to meet other local professionals in the Cincinnati area (and beyond – there are people from as far away as Florida attending!). Bring your business cards and get ready to mingle! Hope to see you there!

-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read

Related tags:

Wednesday, August 20, 2008

Special Date Functions in SQL, Part 1

For our internal dashboard work, we're looking at metrics for the previous month. While I could create a SQL Server stored procedure to pass these dates from a user form, I really want to create a SQL view that will show last month's information. That way, whenever the view is opened, it always shows data for last month.

I know in VB that there are FirstDayOfMonth and LastDayOfMonth functions, but I've been unable to find similar functions in SQL. In my research, I've found "Date and Time Manipulation in SQL Server 2000" helpful. I came up with this SQL:


SELECT
CAST(CONVERT(CHAR(10), DATEADD(dd,-(DAY(GETDATE())-1),GETDATE()),101) AS smalldatetime) AS StartDate,
CAST(CONVERT(CHAR(10), DATEADD(dd,-(DAY(DATEADD(mm,1,GETDATE()))),DATEADD(mm,1,GETDATE())),101) AS smalldatetime) AS EndDate,
CAST(CONVERT(CHAR(10), DATEADD(dd,-(DAY(DATEADD(mm,-1,GETDATE()))-1),DATEADD(mm,-1,GETDATE())),101) AS smalldatetime) AS PrevMonthStartDate,
CAST(CONVERT(CHAR(10), DATEADD(dd,-(DAY(DATEADD(mm,1,GETDATE()))),GETDATE()),101) AS smalldatetime) AS PrevMonthEndDate
It returns these results:
StartDateEndDatePrevMonthStartDatePrevMonthEndDate
2008-08-01 00:00:002008-08-31 00:00:002008-07-01 00:00:002008-07-31 00:00:00
The SQL seems a bit convoluted, especially since I'm going to be using the start and end dates as criteria in a WHERE clause. So, I'm going to create a User-Defined Function (UDF) for each. I'll share scripts for those in a follow-up post.

-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read

Related tags: