In SQL Server 2014, I have new data sitting in a table (second table) that I need to append to another table (the first table).
Both tables schemas are identical and have 60 columns each.
I'm lazy and really don't want to write an INSERT INTO query referring to all 60 columns individually.
Is there an easier way?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.