What you have posted is the inline schema definition, not the XML data content apart from the last 5 lines, can you please post fully consumable content?
😎

This should get you started
😎

;WITH SAMPLE_DATA AS
(
  SELECT
   22 AS reqf
   ,'mod' AS attr
   ,'U' AS...

Quick thought: the query posted is very inefficient with an execution plan that has literally hundreds of operators. This can be significantly simplified, here is an example.
😎

Out of curiosity, why do you want to do this?
😎

Two methods which return the same results
😎
DECLARE @XML XML;

SET @XML =
N'<root>
<families>
  <family>
  <Familyid>F1</Familyid>
  <FamilyMemberDetails>
   <Members>

Quick questions, in this context, what is random? Must the output be unique every time? Is there a limit for the values, i.e. 1-1000?
😎

Quite simple really, it is pushing the NULL values to the back of the output rather than having them in front. The curious thing here is that although NULL is...

Quick suggestion
😎

DECLARE @NL   CHAR(2)  = CHAR(13) + CHAR(10);
DECLARE @MYSTRING VARCHAR(MAX) = REPLACE('Hai,Hello,How are you,Hai all',CHAR(44),@NL);
SELECT @MYSTRING;

Output
------------
Hai
Hello
How...

What is the output of admin cmd "net start", what is shown in the Sql Server Configuration Manager and in Services? Possibly you may have more than one instance running...

Quick note, you will have to do intermediate step of either 2005 or 2008 when upgrading to 2016, you can't do this in one step unless you use scripting and...