Might I suggest you post in the SQL Server administration or SQL Server General forums.

More people read those and you are more likely to get an answer.

This forum is...

A covering index on OrderDate, OrderID should do the job.

You'll be surprised how many people don't realise that functions prevent index usage, or don't think about indexes at all....

My pleasure.

DBCC Shrinkfile expects the logical name of the file to be shrunk as the first parameter, not the name of the database.

Run sp_helpdb 'MyTemp' and see what it returns as...

Just one thing. Never start a stored procedure name with sp_

Very much recomended against due to the way SQL resolves names when executing a stored procedure.

sp_ is the prefix that...

You're creating a table named TRENDDATA and inserting into TRENDDATA_

btw, did you test my code? I ran it on the sample data you posted yesterday and got results that look...

If anyone can do this without a cursor, I'd be very interested in seeing it.

Well, this caught my intrest, so I thought I'd give it a quick try. Sorry Remi. );

This appears to work, if I've understood your requirements properly.

CREATE PROCEDURE SumOfMaximum (@Tid INT,...

That assumes that you have an identity column, a timestamp or a datetime field defaulting to getdate()

I've had some fun issues with distributed transactions to the AS/400. In my experience, they're not DTC errors, but problems with the IBM AS/400 OLE DB driver.

Experiment with wrapping the...

What happensd is that SQL creates a temporary work table in TempDB for the columns returned from the query, plus a new column for the NewID, populates the work table...

You could run profiler and capture the sp:StmtStarting event. That will show you every statement executed inside the stored proc, even if it is encrypted.

That way, you'll be able...

Hmmm, I'm running Developer (2000) as a named instance on an XP Pro machine (SP 1) and @@Servername returns the name of the instance.

Have you tried through query analyser, or...

'Order by 1' says to order the resultset by the first column in it, in this case, the count(*)

Why do you need a dynamic statement? I assume you're doing this in a stored proc, if not, adjust or whatever...

I'm also assuming that you know the structure of the...