I came across an interesting problem this week. The requirement was to get row counts from two different tables and return these on the same row. The tables had a common column, lets call it category. The first thought was to use GROUP BY in T-SQL, but there is a problem with this:
|
1 2 |
SELECT a.Category, COUNT(a.*), b.Category, COUNT(b.*) FROM TableA a INNER JOIN TableB b ON b.Category = a.Category |
The […]
Today, at a project review meeting, a customer said in no uncertain terms, that fewer, more expert developers are better than a team of devs all with just a couple of years of experience. I was very pleased about this, because this is something I strongly believe, and in this case, a good part of […]
Should software ever be re-written? Technology is always changing, new versions of development tools, databases, third party components continually appear. In fact about ten years ago somebody said it was a full time job just to keep up with the new tools coming out of Microsoft. If anything in recent years, especially with the advent […]
Recent Comments