I just wonder why we are not farther along with biometrics.

This completely depends on your data. Sometimes it's obvious that a single column is unique and determines the record. Other times, there is no obvious combination to make up a...

This is something I think about quite a lot these days. I am about 2.5 years away from traditional retirement age, but I have no desire to retire. Yet, it...

What error is being returned?

You only need to backup that which you cannot afford to lose.

Minimum upgrade point will depend on your migration cycle and where you are from a timing perspective. If you just migrated to 2016, you may not be ready for 2017...

• This reply was modified 7 years ago by Steve Cullen. Reason: Name correction

I recall in school, there were some teachers that would give a point for filling out your name on your paper correctly. I feel like I just got one...

I'll take movie questions for 7 points, Alex.

Correct answers = 1 ???

This must be one of those Monty Python type questions:

Q: What is your name?

A: Steve Cullen

Q: What is your quest?

A: I seek knowledge and wisdom about...

Or do an inner join on that criteria.

Either a cross join or a JOIN Sales ON 1 = 1 will work if there is only 1 row in that table.

I dislike questions that require analysis or over analysis in order to arrive at the correct answer.

A QOD question should be a simple test. A better question might have...

This could work:

--===Declare variables

DECLARE @StartDate DATE, @EndDate DATE;

--===Set our variables based on the current date

select @StartDate = dateadd(mm, datediff(mm, 0, GETDATE()), 0);

select @EndDate = dateadd(mm, datediff(mm, 0, GETDATE()) + 1,...

One possible solution:

USE tempdb

GO

CREATE TABLE MyTable (ProductionDate DATETIME NOT NULL, Quantity INT NOT NULL)

INSERT INTO MyTable

SELECT '1-1-2012',5 UNION ALL

SELECT '1-3-2012',7

-- Get the data

;WITH iCalendar AS (

select top 15 DATEADD(DD, N...

QOD <<FAIL>>