left join

SQLServerCentral Article

How to filter non-existing records in SQL

  • Article

Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]

4.22 (9)

You rated this post out of 5. Change rating

2021-11-26 (first published: )

14,950 reads

Blogs

Friday Flyway Tips: State-based deployment with Flyway Teams

By

I was asked about state-based deployments in Flyway Teams, so I decided to show...

Advice I Like: The Main Thing

By

The main thing is to keep the main thing the main thing. – from...

Sic Transit Gloria Community

By

When Covid took out the PASS organization, I had someone say to me, “Well,...

Read the latest Blogs

Forums

The Table Backup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Table Backup

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Monoliths and Microservices

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Monoliths and Microservices

Visit the forum

Question of the Day

The Table Backup

I run this code in SQL Server 2022. What happens?

BACKUP TABLE beercount TO DISK = 'beercount.bak'
 

See possible answers