I think the following will walk through FK relationships starting with a parent down through the affected tables.

DECLARE @Parent_Table SYSNAME = 'YourParentTable';

WITH TraverseTableHierarchy AS

(

-- Using the...

I believe that this is also an option:

WITH SampleData(CustomerID, VisitDate) AS(

SELECT *

FROM (VALUES(908,CAST('2012-07-28 00:00:00.000' AS DATETIME)),

...

jbrentbbutler (4/8/2015)

---

I wasn't trying to be critical of your article. I do think it's fair to discuss professional practices that might eliminate or reduce the types of errors you were...

Just for fun, here's another way using the SQL 2012 LEAD function:

DECLARE @Interval INT = 30

,@StartDT DATETIME =...

kat35601 (4/8/2015)

---

One more question I need to add the last order date to this and then add the AVg_days_between_orders to it so that I get Last_order_Date + Avg_days_between_orders

WITH orders

AS --...

ScottPletcher (4/8/2015)

---

I'm not seeing why you can't just use the code below. I'm sure someone can quickly explain the part of the problem that I'm missing :-).

SELECT cust_id,

...

DennisPost (4/8/2015)

---

Nice article thanks!

I've made that mistake before and seen others make it. It can be tricky to detect.

A colleague told me of a nifty trick today.

When releasing a trigger...

jbrentbbutler (4/8/2015)

---

Hmmmn, I see that this was republished from about a year and a half ago, and all the other comments are from the original publication date.

The may sound somewhat...

Luis Cazares (4/8/2015)

---

Thank you all for your help.

After a quick speed test, I got the following execution times after 10 executions for one million rows.

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

|Version | 1...

GilaMonster (4/8/2015)

---

dwain.c (4/7/2015)

---

I just posted this to "The Worst Comments" discussion thread:

dwain.c (4/7/2015)

---

-- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar

-- gave me...

Excuse my Homer Simpson moment there! Doh! :w00t:

SELECT cust_id

,Avg_days_between_orders=DATEDIFF(day, MIN(order_date), MAX(order_date))/(COUNT(*)-1.)

FROM @orders

GROUP BY cust_id

HAVING COUNT(*) > 1;

Edit: Added divide by zero protection (HAVING).

Alan has given you the more general form that...

pandeharsh (4/7/2015)

---

Hi Dwain ,

Very good article.

I read the article,

I didn't read the whole discussion that is going on.

I have...

Luis! So rare to see you posting a question I had to try to help out.

SELECT Cg.Fiid,

--Original Formula

SUBSTRING( CONVERT( varchar, Cg.Fiid...

Alan.B (4/7/2015)

---

Dwain Camps wrote a great article awhile back: The Performance of the T-SQL Window Functions[/url]

The article is very 2012-centric but discusses how to calculate a median in 2008 as...