Comments by Member 12168418 (Top 7 by date)

select CAST(dateadd(S,Submit_Date+'19800','19700101') as DATE) as 'Date', CAST(DATEPART(HOUR, dateadd(S,Submit_Date+'19800','19700101')) as varchar)+ ':00' as 'Hour' ,
count(1) as Count , char_Circle='andhar pradesh' from HPD_Help_Desk where Submitter = 'temip_admin' and dateadd(s,Submit_Date+'19800','19700101') >CONVERT (date, SYSDATETIME())
and char_Circle='andhra pradesh' group by CAST(dateadd(S,Submit_Date+'19800','19700101') as DATE), DATEPART(HOUR,dateadd(S,Submit_Date+'19800','19700101')) order by Hour asc

the above query output is as below
Date Hour Count char_Circle
09/12/2015 00:00 13 chennai
09/12/2015 01:00 19 chennai
09/12/2015 10:00 42 chennai
09/12/2015 11:00 52 chennai
09/12/2015 12:00 64 chennai
09/12/2015 13:00 85 chennai
09/12/2015 14:00 88 chennai
09/12/2015 15:00 195 chennai
09/12/2015 16:00 148 chennai
09/12/2015 17:00 112 chennai
09/12/2015 18:00 118 chennai
09/12/2015 19:00 39 chennai
09/12/2015 02:00 49 chennai
09/12/2015 20:00 150 chennai
09/12/2015 21:00 50 chennai
09/12/2015 22:00 72 chennai
09/12/2015 23:00 41 chennai
09/12/2015 03:00 5 chennai
09/12/2015 04:00 16 chennai
09/12/2015 05:00 106 chennai
09/12/2015 06:00 11 chennai
09/12/2015 07:00 4 chennai
09/12/2015 08:00 40 chennai
09/12/2015 09:00 70 chennai


How can i get above output as a horizontal output

Hi,

I just want to know process and we have Peer to Peer Replication betweent two Databases.

Hi Pankaj,

Thanks for your help it is working thanks alot...

Error like

Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '19800'.