Reply to thread

Message: <blockquote data-quote="0cean" data-source="post: 22634681" data-attributes="member: 562898">Hari machan. habayi me query eka use karanna puluwan birthday hamogema birthday eka eka yr ekaka thiyanawanam witharayi neda..Query eke apu result eke February walatath value ekak awilla thiyanawa.(2015 witharak enawanam feb walata value ekak enna widiyak naha.)Eka (2, 'nimal', '2016.02.02') ekenda koheda awilla thiyenne.Meke auto ena month name eka deltamoon dipu query ekata add karaganna puluwanda bn[CODE]declare @mytable table(id int, stname char(10), birthday date);insert into @mytable values (1, 'saman', '2015.01.02')insert into @mytable values (2, 'nimal', '2016.02.02')insert into @mytable values (3, 'amal', '2017.05.02')insert into @mytable values (4, 'kamal', '2015.09.02')insert into @mytable values (5, 'nayana', '2015.08.02')DECLARE @year INTSET @year = 2015SELECT A.MonthName ,ISNULL(B.RecCount,0) AS NoOfBirthdaysFROM ( SELECT number AS MonthNumber ,DATENAME(MONTH,CAST(@year * 100 + number AS VARCHAR) + '01') AS MonthNameFROM master.dbo.spt_valuesWHERE ( type = 'P' )AND ( number BETWEEN 1 AND 12 )) AS ALEFT OUTER JOIN ( SELECT COUNT(ID) AS RecCount ,MONTH(birthday) AS MonthNumberFROM @mytableGROUP BY MONTH(birthday)) AS B ON A.MonthNumber = B.MonthNumber[/CODE][CODE]January     1February     1March     0 April             0May             1June             0July           0August       1September 1 October     0November     0December     0[/CODE]</blockquote>

Verification: Payakata winadi keeyak tibeda?

Top Bottom