Database

SQL Server, MariaDB


SSRS: Split Groups with List

Let say that we need the following transformation in SSRS report: One of the tools to do this is List. I will explain only the tricky part and will give the .rdl in the end. Drag-and-drop List in the report body: Right click the top left corner of the list […]


SQL Server CLR: Assembly to Read/Write from/to REST API

In this example we’ll create SQL Server Common Language Runtime (CLR) to read/write from/to REST API. Technology used: Visual Studio 2019 (C# Windows .NET Class Library) SQL Server 2019 (on premises) Authentication: Basic (base64 encoded Username:Password) Requests: HTTP SQL GET SELECT POST INSERT Visual Studio 2019 Create new C#, Windows, […]


MariaDB: PIVOT

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 […]