Does the original code that I posted with the while loop and the CROSS JOIN/APPLY have the same performance? I would think that the CROSS JOIN has better performance...

Thanks Chris and Luis.

But doesn't CROSS APPLY have a different purpose than CROSS JOIN?

Thanks for your reply Chris.

Based on what I'm trying to achieve, cross JOIN seems to be the correct way instead of cross APPLY. I'm referencing this explaination: http://www.sqlservercentral.com/Forums/Topic843768-8-1.aspx

Please let...

Can I just use CROSS APPLY like below?

SELECT ProductCode

,OrderCode

,OrderDescription

FROM @ProductCodes PC

CROSS APPLY @OrderData OD

ORDER BY ProductCode

I was waiting and wondering when you would provide your input, Phil.

My co-worker resolved this by loading the data into a staging table and then using a SP...

Thanks methinks.

Does anyone else have any other suggestions?

I usually use a flatfile source for csv files. But since this csv has a different layout because of the way the headers are repeated I wasn't sure what...

Thanks Sean for your reply. The loading of the file is on a daily basis. The layout of the data isn't straightforward so it's difficult for me to...

Guess my question wasn't clear?

Will try the compatibility.

Maybe you can help me with what I'm trying to achieve.

I have a table with the table name, column name, column values and whether the column values...

I'm using SQL Server 2008 R2. However, I think the database might be configured to run as SQL Server 2005 (9.0).

The expected result that I want is:

ProductID ...

Thanks Mike. I'll try that.

Phil, I wanted to use a derived column transformation before the data conversion transformation to handle blank values as NULL.

Thanks Tim. I already had tried your recommendations, but I still couldn't get the correct value saved in the table. I couldn't solve this issue at the end.