As a more generic response, if you want to use your own function in T-SQL the same way that aggregate functions like SUM are used, then you have no other...

As an alternative to the already mentioned ideas, how about adding a Calendar table to your database?

A Calendar table is a table that holds all days for a period that's...

My best (but still pretty wild) guess is that this table holds static data (with healthcare codes??), and that the highlighted line was added by a developer who, as part...

I copy/paste/ran your code and it ran fine for me. There was a message on the target queue.

If you use copy/paste from the code to a fresh database and try...

Aaron N. Cutshall (12/31/2015)

---

Hugo Kornelis (12/31/2015)

---

No, the conversion from string to datetime is actually documented. And there is no way to write a datetime constant other than as string (or...

Aaron N. Cutshall (12/31/2015)

---

Hugo Kornelis (12/31/2015)

---

Oh boy. I guess we can all brace ourselves for another day where dozens of people feel that they just have to respond to inform...

TomThomson (12/31/2015)

---

Hugo Kornelis (12/31/2015)

---

Oh boy. I guess we can all brace ourselves for another day where dozens of people feel that they just have to respond to inform the world...

Oh boy. I guess we can all brace ourselves for another day where dozens of people feel that they just have to respond to inform the world that there is...

The explanation is (slightly) incorrect.

SQL Server will not automatically map to existing users with the same name. What happens is that the (documented, in the page that's referenced in the...

JohnDeardurff (12/17/2015)

---

I want to verify what I think is the conclusion with this code. Is the ANSI-89 syntax for joining tables deprecated or just the *= operators. I know it...

I am preparing a course for Pluralsight that will have hours and hours of in-depth...

TomThomson (12/11/2015)

---

So I don't think that stating that "ID" is a user defined type would improve the question, it wouldn't really change anything. But maybe I'm biased because...

The question would have been better if the author had added a note that we can assume that "ID" is already created as a userdefined datatype.

I still got it wrong....

Unfortunately, there is not much out there. When I...

Always embarrassing to see a mistake in one's own question.

Both in the question and in the explanation I have consistently used the term "hash input" where I should have used...