SSIS can store the multi-row results of a...

In DTS a single data pump can be...

In SQL Server 2005, if you have a...

What does the following produce?

DECLARE @val CHAR(20)
SET @val...

Create a table of dates

This script creates a table and populates it with information about all dates between a (configurable) start date and end date.It creates a table called MyDates in a database called MyDB in which this is done but the script can be easily edited create the table in whichever DB you want it with whatever name […]