You know by now how to post a T-SQL question. Please supply DDL and Consumable Sample Data.

As you're using SQL Server 2016 and ordinal position doesn't matter, have a look at STRING_SPLIT() (Transact-SQL). Then, have a look at how to create a delimited string...

Noticed every morning this week there's been able 2-3 pages of unicode character topic names, then the post is all in Chinese. They, however, all disappear I report 3 of...

Sorry, thought I'd put that in there: http://www.sqlservercentral.com/links/1769143/369201

Steve,

Getting an odd error from one of the links in the Newsletter today:

Slightly different to Eirikur's:

USE [YourDatabase];

SELECT s.[name] AS SchemaName, t.[name] AS TableName, c.[name] AS ColumnName
FROM sys.tables t
    JOIN sys.schemas s ON t.schema_id...

Yes, there is. What have you tried so far?

I'll admit, I've noticed this before as well before. We use c# and VB.net here, and I've noticed it in both.

Much like Phil, however, everything we have...

This looks like a classic Island and Gaps question.

There are plenty of solutions out there, this is just one example:

WITH Groups AS(
   ...

When you open the project in SSDT 2015, the project will go through a one-way upgrade. That's about it then, unless you have any custom tools on SSRS/SSIS, where you'll...