I bow to you because you demonstrate courage by submitting a QotD.

The third line will not return the results sorted as described in the question narrative or as shown in the 'should be'. The narrative specifies 'ascending order of date...

Drat! I thought that it was a case-sensitivity trick question, but couldn't remember which case sorts to the top. (And it's cheating to research anything for the QOD,...

I'm wondering why user would run those two statements if PK's '1' and '99' already existed.

I could not run your 'create's in 2000, but had-to make the COLLATE's match. Whether COLLATE'd or not, SQL 2000 throws a PK error for me on COMPETENCY whenever...

re PL/SQL: I confess that I have been visiting the 'dark side'.

I suppose that one would use count(1) to increase the mystery in one's uncommented code.:hehe:

Here's a justification for count(1):

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1242198&SiteID=1

Says here that DATEDIFF doesn't consider DATEFIRST.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=239958

I don't think that datediff(wk) salutes @@DateFirst.

[font="Courier New"]DateFirst StartDate EndDate DateDiff WeekDiff

--------- ----------- ----------- ----------- -----------

...

The idea is to reuse the values in the first row of each set where there is a blank?

I can name that query in one statement, but easier to describe...

Delete the parentheses (and the resulting derivision) from your FROM clause

INSERT #CDHToDelete

SELECT CDH.CDH_RecordID

...

Try it without the 'AS'.

How to merge this into your queries?

I would use the derived table technique as a guide for creating a view which described rights for each user. Could then query on...

Are you certain that this is the section of your proc which is throwing the error? We cannot reproduce your error in this piece of code. Perhaps the...

Agreed about SSN PK and about formatted PN. I'd store SSN payload with dashes to reduce annoyance of formatting for output. (I think that post-formatting would hurt report...