Cool - - Just explaining how I did it. 

Thanks for the advice.

Yes, I had to use the (Select * ) and all values had to be at the end of my join. 

For it to work in DTS, I had to...

Now, I have the results, but will the DTS accept Temp tables in the results when it trys to transform?

Select * from myview mv

left join (Select Reason1,Reason2,Reason3,Reason4 from #ResponseList) as...

I got it to work - - Move the Insert out of the loop and add

 SET @Response1 = null

  SET @Response2 = null

  SET @Response3 = null

  SET @Response4 = null

Jeff,

The requirements for the report also extend into many more *frustrating* things but, long story short, I had to create a view to manipulate the data the way they wanted. ...

I started something like this....but needs work

CREATE TABLE #ResponseList

(

 OpportunityId varchar(15),

 Reason1 varchar(150),

 Reason2 varchar(150),

 Reason3 varchar(150),

 Reason4 varchar(150)

)

Declare cOpp CURSOR FOR

  SELECT REASON, OpportunityId FROM OPPORTUNITY WHERE (NOT (REASON IS NULL))

Declare @OpportunityID varchar(12)

Declare @Reason varchar(250)

Declare...

They want it in a flat file. 

Yes, it is for a report.

How the data currently lives:

Response                                 MYId

First Response, Second, Third      XYZ1234

Hello, How, Are, You                   UUU3333

The data was not placed in a one to many table from the beginning, but instead of normalizing...

I found a post that you cannot do what I am trying in SQL 2000

Passing column names as parameter to a table-valued UDF is not allowed in SQL 2000.

But if...

I am using a Multi-statement Table-Valued Function

I tryed this and i get an error when trying to use a value from table a

Line 2: Incorrect syntax near '.'.

Select * from...

1.) Field has many values that are separated by commas (Code for this above)

2.) The values then need to be Columns for the original query.

Current Fields within a view:

MyId  | ...

--QuarterOfYear

Set DateFirst 6

Select (DatePart(wk, getDate())/13) + 1 as QuarterOfYear

I did this to know the Quarter of the Year I am in.  I have to pass a function Today's Date...

I got it SubSelect

SELECT     cs.Name, COUNT(req.RequestId) AS Total

FROM         dbo.tblRequest req RIGHT OUTER JOIN (SELECT * FROM tblImplementer WHERE UserID = @ImplementerId) AS

                      tblImplementer ON req.RequestId = tblImplementer.RequestId RIGHT OUTER JOIN

                     ...

tblRequest

RequestId

ChangeStatusId

....

....