Author Archives: David Bauernschmidt

About David Bauernschmidt

I live in the historical triangle of Virginia where I am married with two daughters. I have spent over 13 years working for a Fortune 500 company in the computer area. I started in VB 6.0 and by the time I ended my employment I was supervising a development team where we built many web applications. When my first daughter was born I wanted to spend more time with her so I left and became a programmer analyst for local government as well as launch my own company. Since then I have grown James River Webs into a profitable web design and application company helping small businesses create a big presence on the internet. As an employee I have created web application used by citizens and other companies. I enjoy fly fishing, and spending time with my family. I also enjoy learning new approaches and development tools when it comes to developing applications.

Arvixe and Reporting Services Intro (Part 1 of 7)

This month I am starting a series of articles on Microsoft SQL Server Reporting Service and how to implement it with Arvixe. Although many of the points made in these …

Tags: , , , , , , , , , , , , , | Posted under Programming/Coding | 5 Comments

Using PIVOT on Dates in One Column

Suppose you have a table that contains Job ID, when it was started, and when the Job ended. Now you want the difference in days between when it was started …

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

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