SQL Server Queries – Stripping Extra Characters from the End of a String

Yesterday while implementing a particularly difficult SQL report query, I came across the following question: Given a String ‘This is a test, this is a ...
Read More

Tech Tip: Excel and Subtotals

If you use SUM() in Excel to calculate totals, you may want to know about the SUBTOTAL() function, which does a similar job, butbetter. SUBTOTAL ...
Read More
Archives