---------------------------... --SQL Server - left join data sums/counts/averages to date range to account for zero days or zero weeks --use recursive common table expression (CTE) and nested CTEs to accumulate "data dates" over the latest "n" weeks ---------------------------... ---------------------------...

Inside MS WSS 3.0 – Pattison & Larson Chapter 1 – Getting Started · WSS is a Site Provisioning (Creating) Engine · Multiple SQL DBs (2005 / 2000 / Express) store content & configuration data · Farm – one or more computers providing WSS to users · Configuration DB – farm wide settings o Server names o User roles · Content DB – one per WSS Application o · WSS runs on top of IIS · Needs IIS to handle incoming HTTP requests · The IIS Default Site has listener that passes HTTP requests to sharepoint/home...