Counting Bit (true & false) in SQL
Here is how to count bit in SQL
SELECT Id, count(1) as TotalCount,
SUM(CASE WHEN Addressed = 1 THEN 1 ELSE 0 END) as AddressedCount
FROM [dbo].[Alerts]
Command Palette
Search for a command to run...
Comments
Join the discussionNo comments yet. Be the first to comment.
More from this blog
Azure Resource Manager Quick Start Templates
Azure Resource Manager Quick Start Templates is a treasure trove. I have to book mark it here. Templates
Mar 9, 20221 min read
OpenTelemetry .Net 6 Web Job
OpenTelemetry is the software industry standard for logging so I wrote a sample Web Job that logs, traces and emits metrics using open telemetry. Sample on Git Hub
Feb 18, 20221 min read
Copying content folder in .csproj
To copy content folder in .csproj to output folder, add the following. <ItemGroup> <Content Include="$(ProjectDir)Content\**" CopyToOutputDirectory="PreserveNewest" /> </ItemGroup>
Jan 20, 20221 min read
My software development principles.
Do not violate the YAGNI principle. You aren't gonna need it. Do not violate the POLA principle. Principle of least astonishment. My preferences Domain-Driven Design. Functional programming. Test & Behavior Driven Development Clean Code: A Handb...
Sep 12, 20211 min read
Restful in .net core
To return success with no content use return NoContent(); POST is used to create a resource so if the POST has a ID like POST authors/myid If the id exists it should return Conflict return new StatusCodeResult(StatusCodes.Status409Conflict) To creat...
Feb 24, 20211 min read