Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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.
|SQL - Creating Pivot with all the possible columns||7||31|
|Powershell error using sql agent job||24||33|
|Search Text in Views||2||26|
|SQL Simple Query Taking a Very Long Time||11||31|
Join the community of 500,000 technology professionals and ask your questions.