Does this need to be dynamic? Are you adding new columns to your table each month (so next month you'll have a column 04/01/2019)? If so, I'd suggest that what...

I admit, mine wouldn't have worked due to a missing comma, but if you fix that they do indeed both work (giving different results, depending on your need). You can...

There's also an article on SSIS Catalog Environments in the Stairway to Integration Services article series.

What do you mean "similar"? Like World events? Is 2020 similar to 2016 because they both hosted Olympics? Is 2014 similar to 1990 because Germany won the FIFA World Cup...

So are you ID's letters? What happens when you get to ID z, is the next row aa? That's going to be a problem for ordering in SQL Server; when...

You can, however, specify a default value for LEAD/LAG if the row reference would be "out of range". LEAD/LAG has 3 parameters, of which only the 1st is mandatory. The...

If you open the SQL Server Configuration Manager can you see your instance is running? Is it also a named instance and running on the default port (if...