Problem solve
Get help with specific problems with your technologies, process and projects.
SQL Server Business Intelligence BI and Data Warehousing
Paging through SQL query results
Convert XLS data to a SQL Server table
A stored procedure to properly import data from an Excel table into SQL Server.Continue Reading
Runs of sequential numbers, part 2
-
Joining derived tables
The last N rows in each group
Extract surname from name column
Number of business days between two dates
This procedure will be useful for getting the number of working days between two given dates.Continue Reading
An introduction to data warehousing, part 1: The basics
An introductory guide to the basics of data warehousing.Continue Reading