• 2k
  • 3
  • 438

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):
Stored procedure after Union command (single table stored procedure):
I need the help for the following stored procedure, which has multiple tables:
I am a beginner,help us
Thanks in advance

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (3)