From reporting services you should be able to put in the properties of that database field a format of n2. That should format the number for presentation purposes.

This method is just my first thought... and I expect there is a more elegant and efficient solution. This method will also assume that the table has unique rows...

Right click on the database in Management Studio, Select All Tasks, Export. Then follow the wizard is probably the best way.

Other option, is connect to database in management studio....

Not sure why you want to use OpenRowset(). I would think you would probably be better suited to create a linked server on your 2005 box to the 2000...

There is nothing worse than a set based operation on millions upon millions of rows, especially when it hits an error and spends just as much time rolling back the...

Agreed. I guess its difficult to say what to do unless you are intimate to the situation. Maybe the code is as simple as some deletes and uses a...

You are correct. I am not saying to do a while loop or something similar. I was going with the idea of taking the code the vendor provided...

I would try my best to avoid the cursor method as well. If the vendor stored procedure is not encrypted, a .net procedure, etc you should be able to...

I am not aware of any setting that would affect only views.

I misread the explanation. I was thinking that when you run the SQL directly on the source it does not time out, but when you run it as the...

You'll need to provide more information about your application to be able to provide a setup suggestion. How many users, whats the application written in, # of transactions expected,...

Can you post more information about the batch file? It almost sounds like a windows style error versus a sql error. I have seen those types of messages...

How are you running the view? Just via the management studio? I don't have a solid answer, but since there was no responses yet I figured I would...

Thanks, I will try that and see what I get.

Solution you have should work. Prior to 2005 and CTEs, ROWNUMBER(), etc I used a different method for something similar. In your case you could look at creating...