I googled “mariadb pivot” and the first answer was this. I need to generate this code: In few words PIVOT is grouping by two groups: CustomerID, ItemID Period And the result is: I played a little and i got this: The result is: The same code for SQL Server: It […]
Few days ago Business Insider posted a list of 8 in-demand programming languages. The big news is that SQL is number 1! Codingdojo report spots SQL as the best programming language to learn, based on the number of job postings on Indeed. Finally I decided to check the average salary for SQL Developer […]
Data Warehouse is “a system used for reporting and data analysis”. In general it is built by dim (dimension) and fact tables (structure and data tables). Here I create a stored procedure to build Date Dimension. Now it builds only calendar data and will be expanded to include “fiscal” data […]
