Stack multiple tables using UNION ALL
Avoid conversion errors when using UNION to stack rows from multiple tables.
2020-06-19 (first published: 2020-06-16)
2,159 reads
Tony
Blogs
Daily Coping 3 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Homework – December 2020 – Participate in the Advent of Code.
Christmas. Depending on where you live it’s a big deal even if you aren’t...
[Video] Azure SQL Database – Import a Database
By Arun Sirpal
Quick Video showing you have to use a BACPAC to “import” a database into...
Forums
How can I exclude records from this table?
How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...
Disable Package Expression
Hi SSC, I've got 2 Project Variables which I use to control wether a...
Inflow / outflow report per day
Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...
Ask SSC