fnMFSplit¶

Signature¶

dbo.fnMFSplit(
    @PropertyIDs     VARCHAR(MAX),
    @PropertyValues  VARCHAR(MAX),
    @Delimiter       CHAR(1)
)

Table-valued result pairing IDs to values: - PropertyID INT - PropertyValue NVARCHAR(…) - Position INT (1-based index)

@PropertyIDs VARCHAR(MAX) (required) - Multiple property IDs separated by a delimiter, e.g., ‘1,2,3’.
@PropertyValues VARCHAR(MAX) (required) - Multiple property values separated by a delimiter, e.g., ‘a,b,c’.
@Delimiter CHAR(1) (required) - The single-character delimiter, e.g., ‘,’.

Convert two parallel delimited lists (IDs and values) into a single paired table.

SELECT *
FROM dbo.fnMFSplit('1,2,3', 'a,b,c', ',');