SQL Server ( with using UNION or UNION ALL)

Question

Among many data tables available in stored procedure, I need to collect them all and insert the results into a single table. I am already trying this in UnionALL. Is there any better way to handle this?

 

Stored procedure before alter (single table stored procedure):

 

https://verybin.com/?19d15ecf7a76fc6a#VIXsw1MJzF4twqwGkTFyBgUW3FCdMGMTM2molSj1WPA=

 

Stored procedure after Union command (single table stored procedure):

 

https://verybin.com/?8cee2bbfd34131f0#JlFgzqtmfQO8iDrLK0vBBM5FGiUeqpkM9vbG2lDlAto=

 

I need the help for the following stored procedure, which has multiple tables:

 

https://verybin.com/?2ed3e549814229a7#Qlk/H8gQxjeGLf0xDNAExkzoIGAFa6TBqVU+8uWDfLI=

 

I am a beginner,help us

 

Thanks in advance