Get halfyearly data from monthly data

Sasi Rekha

8y1.3k

How to get halfyearly data from monthly data

the structure isl ike below

I am having monthwise data i should convert it into halfyeardata with sum values''

Please tell me if anyone knows

DS100 2018-01-01 100

DS101 2018-02-01 100

DS100 2018-07-01 100

DS100 2018-02-01 100

I need like below result

DS100 Halfyear1 200 2018

DS100 Halfyear2 100 2018

DS101 Halfyear1 100 2018

Hi ,

i got answer myselg,please have a look

select DSID,Sum(IntValue),(datepart(mm,MONTH)-1)/6+1 as [halfyearly],datepart(yy,MONTH) as [year] from MonthlyData group by DSID,datepart(yy,MONTH),(datepart(mm,MONTH)-1)/6+1

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sasi Rekha8y ago
I was trying to get this answer for one day,Great suggestion ,thansk
0
Shahriar Nikkhah8y ago
the points are interesting, lol
0
Nitin Sontakke8y ago
Lesson to learn: Do not rush to ask the question. Give a bit of fight and then ask.
+1
Sasi Rekha8y ago
I was trying to get answer, finally I got myself
0
Manish Kumar8y ago
Question and answer are gievn by same person.
Interesting!!
+1
Sasi Rekha8y ago
select DSID,Sum(IntValue),(datepart(mm,MONTH)-1)/6+1 as [halfyearly],datepart(yy,MONTH) as [year] from MonthlyData group by DSID,datepart(yy,MONTH),(datepart(mm,MONTH)-1)/6+1
+2