del

Hugo Kornelis (10/19/2010)

---

I liked the question - allthough with the exception of option 1 on really large (or busy) tables, all options will be blindingly fast, and you won't run...

Ladi,

I think that when we are dealing with T-SQL and the expected results are result sets consisting of rows and columns, with column names and column types, following the principle...

migurus (9/29/2010)

---

Thanks for a simple yet effective tool.

One thing was not clear = why all those functions are declared to return TABLE? it looks to me these funcs return just...

CELKO (9/27/2010)

---

Alexander Kuznetsov (9/24/2010)

---

CELKO (9/23/2010)

---

I still prefer Julianizing the business days to make the math easier

CREATE TABLE Calendar

(cal_date DATE NOT NUL PRIMARY KEY,

julian_business_nbr INTEGER NOT NULL,...

Ladi,

This is a interesting suggestion, a response I have been waiting for. I know about your framework, I read your article and commented on it. What you are suggesting is...

CELKO (9/23/2010)

---

I still prefer Julianizing the business days to make the math easier

CREATE TABLE Calendar

(cal_date DATE NOT NUL PRIMARY KEY,

julian_business_nbr INTEGER NOT NULL,

...);

INSERT...

Iulian -207023 (9/23/2010)

---

Very nice article Alex, thank you.

Indeed IsBusinessDate 'Y' or 'N' is great for building an understanding of the concepts, I remember when I implemented this functionality using...

feakesj (9/23/2010)

---

The article tries to cover too much ground and ends up doing none of the topics justice. In particular, the first function described would have been much better...

That's right, I concur. Thanks!

Steve,

Yes, both are great, no argument here. Yet will non-MS developers get encouraged to attend by this article?

I would guess the following was not intended to appeal to us developers:

"7. Developers, developers, developers

Not the kind that frustrate you every day, but the guys and gals that actually...

Thank you Steve!

UMG Developer (6/28/2010)

---

Also, if the identity increment was -1, then both option 1 and 3 would be correct, as there is no clustered index to order it, and no ORDER...

A very nice read. One more step: as we need running totals every time, why not precalculate and store them - that will speed it up even further. And we...