Tag Archives: SQL Server

Returning TOP and BOTTOM Rows in SQL

The other day I saw a request come across a forum that was asking how to get the top 1 and the bottom 1 of customers with most and least …

Tags: , , , , , , , , | Posted under Programming/Coding | Leave a comment

Comparing SQL Databases for Differences in Objects

Like the real world, development practices keep changing so when I find development code that can make my life easier I want to save it for future use. In this …

Tags: , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Create Comma Separated List in SQL Server

Assume for a minute that you have a table with records that you want to quickly put into a comma separated file (fig. 1). You don’t want to create a …

Tags: , , , , , , , , | Posted under ASP .NET 4.0, Programming/Coding | Leave a comment