except sql

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

15,140 reads

Blogs

SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!

By

They run, they return data. So what? Some SQL queries just waste your time...

Copilot Outside of SSMS Seems to Work

By

I read Brent’s first look at SSMS and Copilot in there. He didn’t have...

A New Word: Falesia

By

falesia– n.  the disquieting awareness that someone’s importance to you and your importance to...

Read the latest Blogs

Forums

Question about updating statistics

By SQL Guy 1

We have very large tables in our database, some even more 1 B records,...

Greener Grass

By Grant Fritchey

Comments posted to this topic are about the item Greener Grass

What tool or tools do people like for monitoring SQL servers?

By tschgc

I have a few tools at my disposal but none of them seems like...

Visit the forum

Question of the Day

A Basic Data API Builder ADD

What parameters are required for the dab add command in the Data API Builder?

See possible answers