Forum Discussion

Dixus's avatar
Dixus
Copper Contributor
Nov 14, 2023

SQL Server not returning (all) rows (Schrödingers Database)

Hi, i haven't seen this in 20 years of my experience. We tried nearly everything to figure out what's happening here. I hope someone can explain this.. The facts: There is a view that returns a ...
Dixus's avatar
Dixus
Copper Contributor
Nov 21, 2023
The problem was the error in that subquery (sort by was wrong). I think that different execution plans ran into different outputs. Depending on the conditions.
bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Nov 21, 2023

Hi Dixus -- Glad you solved it.  Nice work.  Take care.

Resources