Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO alter PROCEDURE [dbo].[stp_GetCountMonthWise] @startdate DATETIME, @finishdate DATETIME AS SELECT TheYear = MAX(YEAR(registration_date)), TheMonth = MAX(DATENAME(mm,registration_date)), TheTotal = COUNT(id), female = SUM(case when isnull(sex,'Unknown') = 'Female' then 1 else 0 end), male = SUM(case when isnull(sex,'Unknown') = 'Male' then 1 else 0 end) FROM registrations WHERE registration_date >= @startdate AND registration_date <= @finishdate group by YEAR(registration_date), datepart(mm,registration_date) Order by YEAR(registration_date), datepart(mm,registration_date)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.