سلام
فرض کنید جدول زیر را داریم
CREATE TABLE [dbo].[test]([Date] [date] NULL,
[Number] [int] NULL,
insert into [dbo].[test] ([Date],[Number])values('2016-07-22',null)insert into [dbo].[test] ([Date],[Number])values('2016-07-23',9)
insert into [dbo].[test] ([Date],[Number])values('2016-07-24',2)
insert into [dbo].[test] ([Date],[Number])values('2016-07-25',13)
insert into [dbo].[test] ([Date],[Number])values('2016-07-26',55)
insert into [dbo].[test] ([Date],[Number])values('2016-07-27',45)
insert into [dbo].[test] ([Date],[Number])values('2016-07-28',67)
insert into [dbo].[test] ([Date],[Number])values('2016-07-29',12)
insert into [dbo].[test] ([Date],[Number])values('2016-07-30',9)
insert into [dbo].[test] ([Date],[Number])values('2016-07-31',2)
insert into [dbo].[test] ([Date],[Number])values('2016-08-01',13)
insert into [dbo].[test] ([Date],[Number])values('2016-08-02',55)
insert into [dbo].[test] ([Date],[Number])values('2016-08-03',45)
insert into [dbo].[test] ([Date],[Number])values('2016-08-04',67)
insert into [dbo].[test] ([Date],[Number])values('2016-08-05',null)
insert into [dbo].[test] ([Date],[Number])values('2016-08-06',12)
insert into [dbo].[test] ([Date],[Number])values('2016-08-07',9)
insert into [dbo].[test] ([Date],[Number])values('2016-08-08',null)
insert into [dbo].[test] ([Date],[Number])values('2016-08-09',2)
insert into [dbo].[test] ([Date],[Number])values('2016-08-10',13)
insert into [dbo].[test] ([Date],[Number])values('2016-08-11',null)
insert into [dbo].[test] ([Date],[Number])values('2016-08-12',55)
insert into [dbo].[test] ([Date],[Number])values('2016-08-13',45)
insert into [dbo].[test] ([Date],[Number])values('2016-08-14',null)
insert into [dbo].[test] ([Date],[Number])values('2016-08-15',67)
insert into [dbo].[test] ([Date],[Number])values('2016-08-16',12)
select distinct(number) from test
NULL
2
9
12
13
45
55
67
9,
2,
13,
55,
45,
67,
12