This thread has been dormant for a while. Has anyone tried the Knotty Brunette at Twin Peaks? A good dark beer along the lines of Newcastle Nut Brown....

Something else to point out:

SET @EndDate = '2013-02-13 00:00:00.000'

Midnight (00:00:00.000) is the beginning of the day, not the end. You're essentially getting data from Jan. 1st through Feb. 12th....

You didn't indicate where you are located, but if you don't report actual hours worked, you may be opening yourself, the consulting company you work for, and the client up...

Four years ago I was in a Data Admin group that got tired of being called to fix problems in these rogue installs. The Manager got a bright idea...

Boy, some of you are wishin' and hopin' that all the bad in the world will go away just because you think it should be so. The purpose of...

NuNn DaddY (2/1/2013)

---

The following design for the table doesn't seem to make sense as the CompanyID is repeated and could allow for an employee of one company to be listed...

Back in the Dark Days of mainframes, VSAM, and JCL, a DBA was the guy getting called at 2:00am when something went poof. A DA was a Data Analyst...

And there's no way to limit what...

When I worked at The Major US Motorcycle Manufacturer the salaried employees were warned during our orientation to never leave our workstations unlocked when we stepped away. Seems that...

OP: Do you know what sentiment analysis actually is? ("Generally speaking, sentiment analysis aims to determine the attitude of a speaker or a writer with respect to some...

^^^Ha!

Maybe if they'd gone with data culottes instead...

Also, hopefully you've considered if there is any private data (names, addresses, DOBs, etc.) in the Prod database that would have to be scrubbed before landing in a potentially unsecure...

Posting the same question multiple times doesn't help you get to the right answer, it just fragments the responses you get.

You don't store dates in SQL Server formatted as anything....

Wasn't sure about the input format, especially the "-Mon-" segment. Maybe...

DECLARE @Dob TABLE (birth VARCHAR(15))

INSERT INTO @Dob

SELECT '24-Oct-2012'

UNION ALL

SELECT '01-Jan-2011'

...

Excellent article, and I hope it gets a lot of "eye time" across the interwebs.

But it can be a bit irritating to find the same sort of mistake a dozen...