CODEWITHSUNDEEP
sqlsql-server
Karthikeyan Ponnswamy
Karthikeyan Ponnswamy

Reputation: 15

To bring Title from output of SQL query

Query 

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

OUTPUT will be

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

I need to print like this dynamically in SQL.Please help me 

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

Upvotes: 0

Views: 80

Answers (2)

Pintu Kawar
Pintu Kawar

Reputation: 2156

You can get it using a variable:

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

OUPUT:

 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

Upvotes: 0

Gordon Linoff
Gordon Linoff

Reputation: 1269943

It looks like you want string concatenation. One method is:

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, '')

Upvotes: 1

Related Questions