I have no answer. Here is something to try.

Are you EXECing the SP from the same Query Analyzer window as the normal SQL? If not it is possible your connection...

I still don't know why LineNo is reserved, but I think you are after SET ROWCOUNT X which is like an external TOP that also works on UPDATEs and DELETEs.

Simple answer = Yes. Search on LineNo within BOL and one of the hits is the Reserved Keywords list and LINENO is in there as a SQL Server reserved keyword....

My first guess is that it may be resolving into an intermediate resultset for the purposes of performing a sort or resolving some expression. In other words, your cursor is...

Look at the DECLARE CURSOR information within books online to get all that stuff explained. Following is a template

 DECLARE curUpdate CURSOR SCROLL_LOCKS DYNAMIC LOCAL FOR

    SELECT something

         FROM somewhere

         WHERE some = condition

         ORDER...

You may be right about it being easier to use a VB app. Anyhow, apparently either my memory is failing me or 2000 works different than 7 for this (likely...

Thanks. Your plan B is what I was trying to do but forgot to name my resultset (calct). I reverted to the @Temp table when I couldn't figure out how...

I don't have a direct answer for you, but check your delimiter to make sure its detecting columns correctly. Check the data type detected on the SQL table to make...

I don't believe it is directly possible. I'm assuming the computations for the real TOTAL are either intensive enough or complicated enough that you don't want to reperform them. Given...

I can't help it.....

That was pure genius. Very nice.

Aside from the fact that doing something like that would make me really nervous, here are some possible issues I can see.

First, you would need to be carefull with quotes...

Without knowing why the ROWCOUNT apparently performs as poorly as it apparently does, you might try a TOP 200 in conjuction with the ROWCOUNT. Just a stab in the dark.

Also,...

I agree with John but figured I'd point out that if you have Enterprise Manager to work with you can get a template (see what EM does) by performing the...

I'm not sure if a cursor would run any faster than the SET ROWCOUNT, but it is another option. Create a temp table to hold the results (@Table, not #Table...

If you are trying to develop a single comprehensive select list with all the data, the cursor approach above would require using a temporary table to gather all the data...