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.13 (8)

2021-11-26 (first published: )

13,001 reads

Blogs

Advent of Code 2022

By

Foreword Advent of Code is an annual event in which participants solve a series of...

Daily Coping 8 Dec 2022

By

Today’s coping tip is to be curious. Learn about a new topic or an...

#PowershellBasics: Warnings and how to hide them.

By

One of my favorite parts of having a new job is that I learn...

Read the latest Blogs

Forums

COLLATE Errors

By saintor1

I have been using this for a long time.   It was done initially in...

blank page

By carjara

Hi guys! The topic "Connect to SQL Server with Python to Create Tables, Insert...

how to keep two databases with different collation on one instence

By rajemessage 14195

hi, i want to keep two databses with diffrent collation on one instence of...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Temp Alias

See possible answers