SQL Server ( with using UNION or UNION ALL)

kamal

7y1.5k

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah7y ago
You can use temp tables or CURSOR
cursor is like a tempoary sotrage for your query which you can loop and do desired operations
+1
Rajanikant Hawaldar7y ago
Instead of creating 3rd table to insert existing data from tables, better you can create view
+1
Piyush Pansuriya7y ago
Hi,
If your tables does not contain foreign key with each other, you can use union for get the result. other wise you can use joins with all the tables and get the result.
+3