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

Duplicate of https://www.sqlservercentral.com/forums/topic/is-it-possible-to-add-a-scripts-folder-to-a-reporting-services-project-2

• Many users are wary of opening Excel or Word documents, as they can contain malicious macros/scripts. Can you generate DDL (Create table script) for the table (including indexes), &...

You just want to concatenate all the IssueName values? If you don't care about order, you can use STRING_AGG function:

SELECT STRING_AGG(IssueName,',') AS IssueNames FROM dbo.tempIssueRange;

Given that you know the from and to time zone (i.e., you know the offset difference), but your values are not datetimeoffset, why don't you just use dateadd()?

AT TIME...

Maybe something like Monarch? I used a product called Monarch decades ago that sounds like this tool.

There are some industries/groups of customers with more discipline than others, and some...

<reference_number> is an element, not an attribute.

That error seems to indicate you're not using SQL Server 2022. (Which is probably why DesNorton wrote " (NOTE the extra parameter in STRING_SPLIT)"

Are you on SQL Server 2022? You...