this is another fibonacci logic besides my previous method with simpler query syntax using SQL Server 2012 or higher version. please contact me if you know better query syntax, i really appreciate that.
below my code:
IF OBJECT_ID('TMP_CUSTOMER') IS NOT NULL DROP TABLE TMP_CUSTOMER CREATE TABLE TMP_CUSTOMER ( CUSTOMER_ID INT IDENTITY PRIMARY KEY, CUSTOMER_CODE VARCHAR(10), CUSTOMER_VALUE INT ) INSERT INTO TMP_CUSTOMER SELECT 'CODE1', 1 UNION ALL SELECT 'CODE1', 2 UNION ALL SELECT 'CODE1', 3 UNION ALL SELECT 'CODE2', 4 UNION ALL SELECT 'CODE2', 5 UNION ALL SELECT 'CODE2', 6 UNION ALL SELECT 'CODE3', 7 UNION ALL SELECT 'CODE3', 8 UNION ALL SELECT 'CODE4', 9 UNION ALL SELECT 'CODE4', 10 /* FIBONACCI GENERAL */ SELECT *, SUM(CUSTOMER_VALUE) OVER (ORDER BY CUSTOMER_ID) FROM TMP_CUSTOMER /* FIBONACCI BY CUSTOMER CODE */ SELECT *, SUM(CUSTOMER_VALUE) OVER (PARTITION BY CUSTOMER_CODE ORDER BY CUSTOMER_ID) FROM TMP_CUSTOMER |
CMIIW
Leave a Reply