Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for like tables within the same database or maybe there is a need to combine like data across databases or even across servers. I have read about the UNION and UNION ALL commands, but how do these work and how do they differ?
2019-12-05
Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.
2017-06-13
5,896 reads
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
In June this year I took redundancy from the company I’d worked at for...
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
I am trying to setup a linked server and per the documentation it needs...
Ola hallengren stopped deleting older files for SQL Server 2016 which are on cluster....
cast(DATEADD(DAY, case when j1 is null then 0 else j1 end, j_date) as date)...
Ask SSC