DECLARE @ErrList table (
    LogID int NOT NULL IDENTITY(1,1)
  , ErrDesc nvarchar(4000) NOT NULL
);

INSERT INTO @ErrList ( ErrDesc )
VALUES ( 'Company (105): Error:...

Take a look at my answer to your previous related question

https://www.sqlservercentral.com/forums/topic/which-table-design-is-better#post-4059010

• Your code has errors in it
• You use a loop to hit sampleData 12 times
• You miss any data that may fall in the last second of the day

I...

As Jo mentioned, it depends on your requirements

I would most likely use the following

tb_Worker

WorkerID

FName

LName

-- Other Worker Attributes

tb_Course

CourseID

CourseDescription

-- Other Course Attributes

tb_WorkerCourse

WorkerID

CourseID

DateCompleted

The FORMAT function return type is NVARCHAR , which is a string.

https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql?view=sql-server-ver16

You can get the same result by replacing FORMAT with

CONVERT(varchar(10), [YourDateField], 120)

SQL does not have a Year-Month only data type

Working purely with the data that you provided, and getting totals by Match_Id, TeamId,  isServe, and CtTeamWinRally you can quickly calculate what the expected values are

SELECT td.Match_Id,...

There is nothing in your table that links those records together (Like CustomerID).

Create some sample data

CREATE TABLE #SLA (
    CustomerID  int
  ,...

Looks like you have too many quotes.

Try replacing all your '''' with ''.

Also use PRINT(@SQL) to check your D-Sql

You may want to take a look at the following 2 articles

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-%E2%80%93-converting-rows-to-columns-1

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-2-dynamic-cross-tabs

In the meantime, when posting a question, please help us to help you.  Give us...

You can do something like this for the dynamic SQL

DECLARE @SQL nvarchar(MAX);

IF OBJECT_ID(N'dbo.tblDoesntExist', N'U') IS NULL
BEGIN
  -- TABLE does not exist
  SET @SQL = N'
...

I would create an iTVF to search a string for the starting positions of a keyword

CREATE FUNCTION dbo.GetAllStartingPositions (
    @String  varchar(8000)
  ,...

@Jeff Moden

I have a fiber outage at the moment, so was unable to catch your Group By session on GUIDS V.S. FRAGMENTATION last night.

Is there perhaps a recording...

@jeff Moden

I have a fiber outage at the moment, so was unable to catch your Group By session on GUIDS V.S. FRAGMENTATION last night.

Is there perhaps a recording...

The queries would look something like this

SELECT      TOP ( 10 )
           ...