I still like mine, just had to modify the partition by clause. I believe this is also one that Paul White post.

CREATE TABLE [REV_BINDERS](

[OFFICE_ID] [int] NOT NULL,

[BINDER_ID] [int] NOT NULL,

[BINDER_NO] [varchar](7) NULL,

);

go

INSERT INTO [REV_BINDERS]

([OFFICE_ID],[BINDER_ID],[BINDER_NO])

select 2105110 , 1,0101 union all

select 2105110,2,0102union all

select 2105110,3,0103union all

select 2105110,4,0104union all

select 2105110,5,0108union all

select 2105110,6,0105union all

select 2101110,261,0101union all

select 2101110,262,0102union all

select 2101110,263,0103union all

select 2101110,264,0104union all

select 2101110,265,0106union all

select 2101110,266,0105;

go

with emp as (

select

OFFICE_ID,

BINDER_ID,

BINDER_NO,

count(*) over (PARTITION BY BINDER_NO) as BinderCnt

from

REV_BINDERS )

select * from emp where BinderCnt = 1;

go

drop table [REV_BINDERS];

go