Very detailed. Will likely use this in the future. Makes sense to have to setup this information in the catalog and environment areas.

Thank you

skeleton567 (2/12/2015)

---

Is there any difference between this and the SQL function ISNULL? For simplicity and to avoid 'mindclutter' why would we not call it the same? I'm just...

g.britton (7/27/2014)

---

Much better to use a date dimension table that contains all relevant date info for your company. You can include columns like 'IsHoliday' or 'IsWeekend' as well as...

This is the way I would have done it and it feels a lot cleaner and easier to read than the example. IMHO

Arjun S (3/28/2012)

---

Another way to get the result...

Do not normally direct others to sites from the one the forum is on, this is another good explanation and illustration of LEAD and LAG: http://blog.sqlauthority.com/2011/11/15/sql-server-introduction-to-lead-and-lag-analytic-functions-introduced-in-sql-server-2012/

Conceptually, this logic could be applied to any table as more of a change or log tracking system.

Thank you!

The link did not work

I have to agree with the descent here:

If I am going to write something "temporary" then it is really just TSQL not a SP. A SP is permanent construct of...

I would just use in line TSQL with a begin/end and declaration of vars - no need to have a SP

I would agree. I create PDFs via SSRS but was hoping something other than another tool. A...

Yes, I knew it was an older thread, however, I felt the information was a) related and b) helpful to anyone else coming along this way.

Thank you for monitoring the...

FYI, you cannot go from Enterprise 2012 -> [?] 2012 if the Enterprise DB has vardecimal or compression as neither of these are supported in the lower versions of 2012...

Gregory:

Good article and thank you.

I found it amusing the discussion, cough, on terms stated in article and math representations. Sigh... I guess some folks have nothing better to do than...

Looks more like a detailed Index of what is in the book, not a review of the book.

Just double checking... You've never used and will never use CONNECT BY until it becomes part of the ISO Standard. And you never used DATEDIFF until it became part...