Eirikur Eiriksson,

Thanks for the help. Your solution was perfect for what I needed. I finally understood what you did. I was confused because I had never seen CROSS APPLY and...

These results look like how to create the tables which I don't need help with. Suppose these two tables had no relationship between them built yet and I wanted to...

I hope this formats correctly. Here is sample data with the end result shown in the far right column:

IDCredit_Card ...

Finally it worked for me. What I have done is

1. report manager, right click on the report , select manage, click on data source tab on the left...

abd2303,

Could I not just pass it Windows credentials to do this?

Kevin

Could you perhaps explain how to set up the account specifically for SSRS? I'm not entirely familiar with the process. If I go this route, I currently use Windows Authentication...

This is more of a one-off exercise.

Kevin

Jeff & Eirikur,

Thanks for the suggestions. I was able to find a workaround. Though not a elegant solution, I used a program called HxD to open the text file and...