You can't embed the varchar @BookId directly into your query.

You can make your whole query dynamic and embed @BookId into it.  NOTE: This is very dangerous.

You can shred your @BookId...

As a 1st guess, I would think that either C2.ts_primarysecondaryfocus or C2.ts_ukrow has a BIGINT data type.

If that is not the case, then start by commenting all of the fields...

You can use PATINDEX to find the a=(any 3 integers), then use STUFF to replace the (any 3 integers) with 999

DECLARE @x table (y varchar(50));

INSERT INTO @x...

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 readily consumable data

            
June 7, 2022 at 1:23 pm
            
#4045619

            
            
                                                
        

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)
  ,...