Reply to thread

Message: <blockquote data-quote="0cean" data-source="post: 22634583" data-attributes="member: 562898">Thanks, machan.Thanks machan. Query eka nam hari.[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')SELECT COUNT(DISTINCT birthday) FROM @mytableWHERE birthday>='2017-01-01' AND birthday<'2017-02-01'[/CODE]Ow macahn.Ela aniwa. kohomath program eke mita wada tikak wenas.Ekata query eka liyana kota therum ganna wenawa.Thanks machan. Wade nam hari.Mama ube qury eka liyapu widiye mokakhari awulak thiyada...Error ekak enawane...[CODE]Msg 102, Level 15, State 1, Line 23Incorrect syntax near ')'.[/CODE][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)[/CODE]</blockquote>

Verification: Dahaya deken beduwama keeyada?

Top Bottom