SQL Server ( with using UNION or UNION ALL)

Jul 13 2019 1:43 AM

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

Answers (3)

How can i get data in a specific date range?

How to use CTE in SQL Server