Get the first record added per day group by the user in SQL

In the previous post Get the last record added per day group by the user in SQL I explained How to get the last entry for each user per day.

In this post, I am gonna to explain

How to get the first record added per day for each user in SQL.

Get the first entry added per day for each user in SQL

Consider you have a [Transaction] table to save multiple transactions for different users daily!

Continue reading Get the first record added per day group by the user in SQL

Dynamic Pivot Without Aggregation Function in SQL Server

In this article, I will explain How to create a

Dynamic Pivot Without Aggregation Function in SQL Server

Check also Convert Rows To Columns Using Dynamic Pivot In SQL Server.


Scenario

I have the below three tables (One-Many relations)
Dynamic Pivot Without Aggregation Function in SQL Server

  • The 1st table (Table) holds tables name.
  • The 2nd table (Fields) is related to (Table) to hold the fields name for each table.
  • The 3rd table (Field Value) is related to (Fields) to hold fields value for each field.

I would like to show all related data (Fields and its value) for each table name (Entity) in the 1st table to be structured as a real independent table.

Dynamic Pivot Without Aggregation Function in SQL Server

Check also Convert Rows To Columns Using Dynamic Pivot In SQL Server.


Steps Continue reading Dynamic Pivot Without Aggregation Function in SQL Server