Greg - thank you for the reply.

I am not sure if I am doing this correctly.

I go into the Transform Data Task Properties.

Source Tab

Click on Parameters

Create new Input Global Variables

Name...

I now have 3 things in my DTS package:

1. Microsoft OLE DB Connection

2. Execute SQL Task

3. Text File Destination

How do I connect them? Thank you.

Greg Charles (3/5/2009)

---

Put the EXEC in...

You're welcome, but... saying the data is "only a few thousand rows" is an invitation to future disasters... and maybe not the way you may think. If you have...

I tried using a left join. However, it still does not show rows that only match the date and not the class.

ALTER PROCEDURE [dbo].[usp_matrix_courses_month] --usp_matrix_courses_month 1

@northSouth int

--1=north, 2=south

AS

BEGIN

-- SET NOCOUNT...

Jeff and Matt,

Thank you both for your help!

The data is quite small. Only a few thousand rows. No real perfomance issues. The previous version works perfectly!

Norbert

This is the stored proc. On my asp page I will be displaying...

Jeff Moden (2/16/2009)

---

Thanks for the feedback, Norbert. And, consider this... since the code is so simple, are you sure you want the system to "suffer" through the overhead associated...

Jeff,

Wow. This is really efficient! Works great. Thanks for your help!

Norbert

Lowell,

Thank you very much for your assistance! The function works now.

I did forget to add a return variable. So if anyone is reading this, the complete correct Function is this:

CREATE...

GSquared (1/27/2009)

---

You'd have to build a table of months (or a full-on calendar table) and do a cross join from that to the locations, and then a left outer join...

I don't think a left or right join would work since the date is not in any table.

RBarryYoung,

Thank you. Your assistance is very helpful and solved my issue!

Norbert

Jeffrey and Jack

Thank you very much for your assistance. Your solutions worked perfectly!

- Norbert

Matt,

Thank you very much for the great explanation. I am leaning towards changing the SQL server to Mixed Mode where I can just use a SQL login/password to connect from...

Matt - thank you. I will give this a shot.