The requirements of this is that I do not need to create a table, just a stored procedure or query. I just wanted to know of an efficient...

I have not created a table structure yet as I wanted to get the query constructed. The criteria that I have listed is all of the information that I...

Thank you again.:)

Thank you for your assistance.:)

DECLARE @WeekStart smalldatetime

DECLARE @WeekEnd smalldatetime

DECLARE @WeekStart_Name varchar(10)

DECLARE @WeekEnd_Name varchar(10)

DECLARE @MonthYear varchar(12)

SET @WeekStart = (DATEADD(day, DATEDIFF(day, 0, getdate()) / 7 *...

I will try to use your example:

[Incident Date] >= "#07/01/1753#" ? [Incident Date] : "#01/01/1900#"

You could use a derived column to check for this particular date.

TransactionDate == "000000" || LEN(TRIM(TransactionDate)) == 0 ? (DT_DATE)(SUBSTRING(@[User::Default_ReportDate],5,2) + "-" + SUBSTRING(@[User::Default_ReportDate],7,2) + "-" + SUBSTRING(@[User::Default_ReportDate],1,4)) : (DT_DATE)(SUBSTRING(TransactionDate,3,2)...

Microsoft SQL Server 2005

Integration Services

by Kirk Haselden

I would definitely give this one a look at.

Jamie Thomson's blog - http://blogs.conchango.com/jamiethomson/

has been very helpful for myself as well.

I have ran into that error before.  If you are using some kind of repository software like Microsoft Visual Source Safe, you need to first check out the script from Visual...