OK, sorry about that, I'll try again.

Tablea has

proc_id dtime proc_num

70360 20130404 3706

63 ...

I was trying to capture just cases where the examination fields id and related_exam_id were the same. Maybe I was making it harder than I needed it to be.

Thanks very...

I am getting an error, on the second line: incorrect syntax near examination

I'm not sure how to join them but will play around with it. Thanks.

I think I can't get what I need because what is in the 3rd table is not related to any one item in the joined a and b tables. ...

I tried using the convert and distinct. It runs but still gives me all the duplicate records. I also tried putting the results of the join on the first...

I tried using distinct but one of the fields I need is text and so can't use it.

Each table has an id PK only.

I may try making use...

I found the problem. I had to put the drive letter in the path name. Like:

\\servername\d$\foldername\filename.txt

Thanks to everyone for taking the time to help me with this.

I can ping the other server from the server where the job runs. I have added full control to the share file on the other server where I want...

I'm having the same error on some reports that return a lot of data and ask for parameters. Our SSRS is integrated with Sharepoint. Would we add the asp...

I still don't understand why the query works, but not as a view.

Any thoughts?

Thanks so much.

I took out mstr_end out of the select portion and it works. I didn't really need to select it, just had it while working on the request.

Thanks so...

Thank you for those ideas.

I was hoping to do this without a second table though. I'm not using all the fields in the table to get the max date...

The account that I was logged in as and the account that SQLService runs as did not have any permission to files on the U drive. Our SA added them...

I had the server administrator increase permissions on the U drive and everything worked. I was able to bring database online and restore the other.

Thanks anyway, and maybe this will...

Just to clarify, I'm not upgrading the SQL Server for Sharepoint databases (that's already enterprise). THis is for a separate server used for Reporting Services which we have integrated...