Unfortunately, Row_number() won't...

sqlcentral (3/3/2009)

---

Lee: Thanks, that looks neat but I shudder while thinking how it would apply for non-trivial result sets. That looks like a lot of work for...

If you can let me know what the name of the order cokumn is then i can help you ..

If not then this can be using ROW_ORDER()

Do you have a primary key to determine the order?

For this project i would use SSIS, since you have SQL sever 2005 then you should have a copy of BIDS. This will allow you to create SSIS...

You can and should backup the system databases.

Since you have a backup of your missing datafile database, then it...

Do you have a backup?

maybe check your recycle bin?

Can you post the table defs and some sample data, with a outline of what the procedure is meant to do?

No sure what is going on,

But clicking the text-column button in Excel should fix the formating on the Excel side

Looks like a good event , am thinking of heading up from London..

notes4we (2/25/2009)

---

There columns Message, Date, JobStatus are not in...

use a join for this;

select Name, Message, Date, JobStatus

from tableA inner join tableB on tableA.id = tableb.id

use Sysobjects

SELECT COUNT(*) FROM sys.sysobjects

WHERE xtype = 'p'

it's all on the Microsoft website..

http://www.microsoft.com/learning/mcp/mcitp/sql/2008/default.mspx

I would be inclined to put the clustered index on the date. But this really depends on how you will be querying the table.

Are you able to post the queries...