asked on
ALTER VIEW [dbo].[ExtendedOrderHeaderView]
AS
SELECT H.*
,dbo.PreviousOrderDate(H.custID) as [PreviousOrderDate]
,RealOrderCount = (SELECT count(o.orderno) FROM OrderHeaders O WHERE (O.custid=H.CustID) and (OrderType=0))
,RealLastOrderDate = (SELECT max(o.createdat) from OrderHeaders O WHERE (o.custid=H.custid) and (OrderType=0))
,DaysSincePreviousOrder = DATEDIFF(DAY,h.[CreatedAt],[PreviousOrderDate])
FROM dbo.OrderHeaders as H
GO