IF OBJECT_ID(‘dbo.VSgn’) IS NOT NULL
DROP VIEW dbo.VSgn;
GO
CREATE VIEW dbo.VSgn
AS
SELECT Cur.mnth, Cur.qty, SIGN(Cur.qty – Prv.qty) AS sgn
FROM dbo.VsalesRN AS Cur
LEFT OUTER JOIN dbo.VSalesRN AS Prv
ON Cur.rn = Prv.rn + 1;
GO

IF OBJECT_ID(‘dbo.VGrp’) IS NOT NULL
DROP VIEW dbo.VGrp;
GO
CREATE VIEW dbo.VGrp
AS

SELECT mnth, sgn,
DATEADD(month,
-ROW_NUMBER() OVER(PARTITION BY sgn ORDER BY mnth),
mnth) AS grp
FROM dbo.VSgn;
GO YYY