从SQL查询的输出中获取Title

Question

查询

select distinct Task_Date as LastSevendate from [TimeSheet]
where Task_Date between DateAdd(DD,-9,GETDATE()-1 ) and GETDATE()-1

输出将是

2016-10-05 00:00:00.000
2016-10-06 00:00:00.000
2016-10-07 00:00:00.000
2016-10-10 00:00:00.000
2016-10-11 00:00:00.000
2016-10-12 00:00:00.000
2016-10-13 00:00:00.000

我需要在SQL中动态打印这样的内容。请帮帮我

2016-10-05 00:00:00.000  2016-10-06 00:00:00.000 2016-10-07 00:00:00.000 2016-10-10 00:00:00.000 2016-10-11 00:00:00.000 2016-10-12 00:00:00.000 2016-10-13 00:00:00.000

Answer 1

看起来您想要字符串连接。一种方法是:

select stuff( (select distinct ' ' + convert(varchar(255), Task_Date, 121) 
               from [TimeSheet]
               where Task_Date between DateAdd(day, -9, GETDATE() - 1 ) and GETDATE() - 1
              for xml path ('')
             ), 1, 1, '')

Answer 2

你可以使用一个变量:

declare @column varchar(max) = ''
Select @column = @column + ' ' + Task_Date from timesheet
select @column

输出:

 2016-10-05 00:00:00.000 2016-10-06 00:00:00.000 2016-10-07 00:00:00.000 2016-10-10 00:00:00.000 2016-10-11 00:00:00.000 2016-10-12 00:00:00.000 2016-10-13 00:00:00.000