Don't know if this will help: https://www.sqlshack.com/sql-server-transactional-replication-how-to-reinitialize-a-subscription-using-a-sql-server-database-backup/

Not really.

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16

ODBC driver versions up to 18.2 are listed as compatible w/ SQL Server 2016. Can you move to a newer ODBC driver?

I assume you were referring to using ODBC...

Did you mean to use OPTION (MAXRECURSION)?

i.e., something like

WITH factorial(F,n) AS (
SELECT 1 F, 3 n
UNION ALL
SELECT F*n F, n-1 n from factorial where n>1
)
SELECT F from...

Why do you have both @TVP GetTrackingNO parameter and @trackingTVP AS GetTrackingtNO variable?

It looks like the extra "t" in GetTrackingtNO is a typo, & you are actually using GetTrackingNO, correct?...

Can you be more specific about what specifically is not working, and what you mean by "not working"?

Does it return an error? If so, at what point and what error?

You...

Check out this article by Jeff Moden: https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1

Maybe something using STRING_SPLIT?

-- e.g.,

SELECT #returned_products.#returned_products_id,CONCAT('reason_',value) AS returned_products_reason
FROM #returned_products
--Assumes reason always in the form "reason_#. Using REPLACE to treat underscore as the delimiter.
CROSS APPLY STRING_SPLIT(REPLACE(#returned_products.returned_products_reason,'reason',''),'_') reasons
WHERE reasons.value...

You generally don't need/want to use DISTINCT when you're using an aggregate like COUNT() -- you instead want to GROUP BY the SELECT columns that are not aggregated.

Does that work?...

Can you provide DDL & sample data insert script?

You said you want counts, but you're using DISTINCT & you're not returning COUNT()

And these AI's should do that efficiently so that their queries don't block other services and users, or exhaust server resources.

Adapted from https://www.mssqltips.com/sqlservertip/2960/sql-server-backup-paths-and-file-management/

DECLARE @media_family_id uniqueidentifier = '67BAB2D0-A1DC-44F8-BF73-EBAFD5AE322'

-- File name : Where are the backups.sql
-- Author : Graham Okely B App Sc
-- Scope : OK on SQL Server...

Do you have SQL Server Integration Services Projects extension installed?

I don't think DB team should create/control/define UI requirements.

The DB team might advise on UI, both from the perspective of guidance based on the data, and for warnings when a...