SQL reads 11:59:59 AS AM. The the missing record was PM.

Did you try your original query with '5/15/2015 23:59:59' Instead of '5/15/2015 11:59:59'?

I had forgotten about it,...

Do we have them in any other colors? 😎

I agree with Jeff on the need for the technical questions.

I remember seeing a resume for a DBA that seemed to have good experience. I was eavesdropping on the...

Beatrix Kiddo (5/22/2015)

---

Our server names include an indicator of whether or not they are virtual. Which is fine until somebody P2Vs the server and forgets to change the name. Nothing...

Gary Varga (5/22/2015)

---

Eric M Russell (5/22/2015)

---

T_Peters (5/21/2015)

---

I've run into various naming conventions that have caused problems over the years. One of my favorites was naming printers after the 7 Snow...

Other than reducing the number of databases to manage, I cannot see any benefits.

This would mean fewer databases to manage, but this database could, if not would, be a nightmare...

Were you looking over my shoulder? 😉

SELECT CONVERT(DATETIME2, '2015-01-16T16:06:14.577-06:00', 127) results in: 2015-01-16 16:06:14.5770000

Does this help?

Looks like the style is 127. Did you try convert specifying style 127?

https://technet.microsoft.com/en-us/library/ms187928%28v=sql.110%29.aspx

Is there any chance you could do some SQL work where you are working now? Maybe there's a chance you could do so for a few hours a week. If...

Luis Cazares (5/20/2015)

---

Reactions like this make me wonder if I should change my signature.

Those questions are there because some people just copy, paste and execute code without analysing what they...

oops

FYI, the =* and *= can easily be converted to Outer Joins so you could upgrade to SQL 2008 or higher.