How to Create A Bar Chart Using SQL Server - CodeProject
Mar 19, 2017 · In this puzzle, we're going to learn how to create a bar chart using SQL Server. Sometimes, it’s fun to see what you can do with the humble SELECT statement. Today, I figured it …
How Do You Calculate the End of the Month in SQL?
Aug 30, 2016 · When working with SQL dates, sometimes you need to calculate the end of the month. Months are tricky! Some are 28 days, others 30 or 31, and now and then there’s a leap year! So, …
Gridview in ASP.NET MVC - CodeProject
Jul 4, 2016 · Download MVCGridView.zip - 2.7 MB Introduction I have been asked so many times how to show gridview since there is no such controller in MVC like in ASP.NET. Therefore, I decided to …
Comparison of Template and Strategy Design Patterns
Dec 12, 2013 · Download the Demo Project here Introduction In this article I have demonstrated the comparison between template and strategy design pattern with the help of a code example from my …
Quick Print - CodeProject
May 5, 2006 · Download demo project - 23.9 Kb Download source - 11.6 Kb Introduction This printing class is based on the article by Rob A. Fraydl, "Creating a Printing Class". In fact, it's just an …
Overview of SQL Server Stored Procedure - Code Project
Aug 2, 2009 · Table of Contents Overview What is a Stored Procedure? System Stored Procedures User Stored Procedures Creating Stored Procedures Performance Consideration Network …
Setting up an ESP32 development environment with PlatformIO
Dec 1, 2025 · Here things can be easy or complicated depending on your board. The easiest thing is you have a supported development kit that is listed under Board. If not, you can still use it. The idea …
Execute SQL Query on Mutiple SQL Servers or Databases ... - CodeProject
In this blog we would learn how to execute a SQL Query on multiple databases of single DB Server or on a single Database on multiple DB Servers.
Conditional Sums in SQL Aggregate Methods - CodeProject
Jan 5, 2012 · A method to simplify this query and to run within a single select that I have used with success is to use a “conditional” sum in the SQL query. So rather than running COUNT(*) we will be …
Web Application State - CodeProject
Apr 15, 2008 · Download sample - 738 KB Introduction Web Application State A Web page is recreated every time it is posted back to the server. In traditional Web programming, this means that all the …