SQL Server throws a wobbly when one tries to declare/create the same-named temporary table more than once in the same procedure - I guess the query analyser assumes that all temp table creations ...

Effectively, those methods can become just thin wrappers around SQL queries. If you want to play with SQL Server’s JSON support (or the other big new feature in SQL Server 2016, temporal tables), you ...

Saved searches Use saved searches to filter your results more quickly ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

Loading data from SQL Server using Power Query is fairly straightforward, and the basics are well-documented (see here for example). However there are a few advanced options, not all of which are ...