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

Dixus 

Hi, Holger.

What is the type of the [orgid] column from the view? (Not the underlying table.)

The only contrived example I can think of is where implicit type conversion is taking place where perhaps you're expecting [orgid] to be an integer type yet the view has come to a different conclusion.

You can see how implicit conversion in the equality example below (first query) ignores the leading space from the actual column value. Note: I'm just using the space here as an example - I'm not Unicode wizard meaning perhaps other characters could exhibit this same behaviour.

Example

DROP TABLE IF EXISTS [table1]
GO

CREATE TABLE [Table1]
(
	[orgid] [nvarchar](8) NOT NULL
)
GO

INSERT INTO
	[Table1]
VALUES
	(N'9943')
	, (N'9951')
	, (N' 9952')
	, (N'9974')
GO


SELECT
	*
FROM
	[Table1]
WHERE
	[orgid] = 9952;


SELECT
	*
FROM
	[Table1]
ORDER BY
	[orgid];

Output

Then again, maybe my brain's on the fritz and it's got nothing to do with this at all. But it's all that came to mind.

Cheers,

Lain