Don''t have a clue, but just wondering if you should really be using the same port as SSMS.   Just seems like an increase in your "attack surface area" that perhaps...

I think the reason you haven't seen anyone do that kind of thing is fairly simple.   While Word has a lot of formatting capability, you still have to find a...

This should work to replace the DISTINCT.   It gives the correct result:
DECLARE @test-2 AS TABLE (
    id int,
    grp varchar(25),
    keyposition int,
    KeyValue varchar(100)
);
INSERT INTO @test-2 VALUES...

How about removing the DISTINCT and adding an ORDER BY ?
DECLARE @test-2 AS TABLE (
    id int,
    grp varchar(25),
    keyposition int,
    KeyValue varchar(100)
);
INSERT INTO @test-2 VALUES (123,...

Take a look at how I took your query and just supplied a temp table name and all the possible values with some sample numbers to work with.   If you...

I'm pretty sure any kind of HASH function is going to operate on the binary value of a character, so lower case a (ASCII 96) is going to hash differently...

I'm thinking the net result is something like this:
WITH SELECTED_DATA AS (

    SELECT C.Cust_MPAN, CONVERT(date, J.PlannedStart, 103) AS [Date], J.[Status], WP.AbortCategory,
        ROW_NUMBER() OVER(PARTITION BY C.Cust_MPAN, J.[Status] ORDER BY...

This has the potential to be challenging, because how would you handle a name like John Paul Revere?   I can only think of one effective and performant way to do...

Jeff,

Every time I "replace" a REPLACE with something less expensive like LEFT, RIGHT, and/or SUBSTRING, the query I'm working on improves it's performance significantly.   Of all the string...

All,

SSIS packages do require an instance of SSIS to be able to run, unless SSDT has now effectively simulated what the Integration Services service was doing in older...

Stop using the subtraction of one date from another, and compare your results with using the DATEDIFF function, which operates like this:

DATEDIFF(day, EarlierDateFieldValue, LaterDateFieldValue)

It might hold...