Not sure because I've never tried to do a group by in the primary update (it seems to me to be bad form).  If I want aggregate info, then I...

put it in a while loop that checks @@rowcount

use SET ROWCOUNT 10000

many different ways of doing this...

try

select top 1 columnname from tablename where ... order by ...

I hope you all realize there's an implied challenge in that original post which can be looked at in two ways:

1. Provide an example of a situation where the cursor...

just delete the "with allow_dup_row"... it will work.  (Or at least it does for me.)

I believe it is just a syntax change.  You can still "allow dups" by just not saying "UNIQUE" in the create index statement.

Um, how about having the source not put them in there? (always the best option: get good data to start)...apart from that...

There is also the option of using a format...

Along the same lines of reasoning, has anyone written about the top WP on my list and my own personal major peeve:  the unbelievable stupidity of prefixing table names with...

DTS supports EXCEL as an output that you can put a transformation task into:

select ... from result table

OR

exec ResultProducingProc

Now just go find an excel forum for how to...

Don't forget to check dos errors using the return from cmdshell (assuming the platform suppoorts it).

declare @err INT

EXEC @err = master..xp_cmdshell ...

IF @err <> 0 PRINT "oops, so much for...

RAISERROR will usually do this.

your result is being implicitly converted to a float datatype which gets goofy like this.  You should tell the result to round and put the result into a numeric or...

I was able to duplicate your problem when using only a CHAR(13) as a line break.

I don't know. (to be clear)

But here's my guess:

I suspect the editor that you used to create the proc stripped the line breaks in a manner that confused the parser.

In...

Like GO, the line terminator says take the prior string (ASCII text of your TRANSACT-SQL) and send it to the server.  That's it.  The server does all parsing, compiling, and...