In scenarios where you need to consolidate multiple rows into a single, comma-separated value, you can achieve this using FOR XML PATH. This script demonstrates how to retrieve volunteer data and display the days they have selected for participation.
2024-11-11 (first published: 2024-10-23)
1,224 reads
Often, we encounter situations where we need to loop through a dataset to process or update records iteratively. In such cases, I use WHILE loop like below. The example below demonstrates how a WHILE loop can be used to iterate Sales records. This approach is particularly effective when working with a numerical or date column, […]
2024-10-15
504 reads
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Yes, you’re reading that right, we’re going to download a report that cannot be...
Comments posted to this topic are about the item Poor Name Choice
Comments posted to this topic are about the item Getting the Indexed Columns
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers