An Urgent Ad Hoc Report

In this new article, Yakov Shlafman shows us how he wrote a quick ad hoc report of expenses so that he could leave on time one day.

Calculating Moving Averages with T-SQL

How to efficiently calculate moving averages with SQL Server using Stock Market data.

How many rows are returned from the query below?

Riddle Me This

Convert String to a Table using CTE

Explains how to convert a list of Ids passed as string and convert it to a table

Concatenating Rows

Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.

The Dynamic Tally or Numbers Table

Building a tally table is a common T-SQL problem that many new developers struggle with. Lynn Pettis brings us an article that shows how to use CTEs to accomplish this.

If I restore a database without an ODBC datasource setup will it fail?

I have tried to restore a database using a different computer than usual, which did not have the ODBC datasource setup for the database concerned.  The database is basically stuffed - I got an error message stating "modify file encountered operating system error 112..."When I installed SQL Server on this computer I set it up […]

RE: Wat are the disadvantages of SELECT ... WITH (NOLOCK)?

I totally agree with ron... it's better to have less data that is accurate than all the data that might be...

RE: help with a query

Hmm.. I don't know, Remi... it seems they have their own business logic, with months absolutely independent on real calendar maybe setting things right would create confusion.If we suppose that you don't want to (or can't) change anything, try this:SELECT Q.city_code, Q.outlet_code, SUM(Q.sold0104), SUM(Q.sold0508),SUM(Q.sold0913),SUM(Q.sold1417),SUM(Q.sold1821) FROM (select [city_code], [outlet_code], CASE WHEN issue BETWEEN 1 AND 4 […]