not exists

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: )

12,999 reads

Blogs

Daily Coping 7 Dec 2022

By

Today’s coping tip is to stop for a minute when you walk outside and...

Encryption and Data Protection Regulation

By

One of the reasons you may be considering encryption is due to the relevant...

Types of data consulting engagements and what you can expect from them

By

There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Read the latest Blogs

Forums

Any good resource to learn Data Factory ?

By kalpitaru

I just joined a company and I'm new to Azure. It's a powerful tool...

query, compare and match against values in date and time columns

By brian.cook

So, I need to calculate the distance between the UNIT for example LPKC1 to LPKC2,...

SSAS Tabular Excel reports slower after upgrade

By woutgoet

Hello, We recently upgraded our SSAS Tabular model from compatibility level SQL Server 2014...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers