Performance of SQL Server [closed]

Closed 18 hours ago.

How to used STRING_AGG function inside another STRING_AGG function in SQL Server

I have 3 tables with 1-n relations between them

How to used STRING_AGG function inside another STRING_AGG function in SQL Server

I have 3 tables with 1-n relations between them

Finding first and last dates [closed]

Closed yesterday.

Finding first and last dates [closed]

Closed yesterday.

SQL Server LIKE function using column values instead of string

Obviously the LIKE function doesn’t work with actual column values. Does anyone know either HOW to make it work? Or an alternative that could work?

Create view with working hours based on data

I’ve got a table:

Return NULL for CTE where records not found

I have this sql query using Commont Table Expression:

Perform aggregations with two tables with same structure

I have two tables that hold the same type of data, one with current day data and one with previous day data:

Perform aggregations with two tables with same structure

I have two tables that hold the same type of data, one with current day data and one with previous day data: