Although I still don't know why you can't do the above code, the quick fix is to set the sql code to a variable and execute the variable:

i.e.

set @sql =...

Thanks! I used a variation on your first idea that does work b/c it eliminates the aggregate. It probably wouldn't be a great solution if I had more than 4...

Can't have an aggregate in an update statement. I'm trying to think if a self join with the inner join would work but I'm not getting it yet.

Suggestions? Thanks!

They are all varchar fields. Thanks.

I use

/t ","

I just tried :

-t ","

-t","

/t","

\t","

and none of those seemed to do it. It keeps saying 'incorrect syntax near queryout'. My entire statement is:

set @sql = 'bcp "select...

I will. I thought \t was the default statement for tab delimited though?

Thank you very much - that was exactly what I was needing to know! It appears to have worked - at least my database is responding again.

Can you tell me...

Is that option possibly only for version 7.0? I didn't see it as an option in 2000, but I could be wrong.

I created a database maintenance plan to backup the...

I'm using Sql Server 2000

Cannot shrink log file 2 (ADPS_Log) because all logical log files are in use.

Thanks!

Does anybody have any new information about this issue? I am experiencing it - and my network guys claim nothing has changed regarding our domain controller - and my server...

I am referencing an actual file that has quotes in the filename - if I take the quotes out of the variable holding the filename - it won't match the...

Problem with quotes in the Bulk Insert - normally I use what you suggested

BULK INSERT temp FROM ''' (plus) @file (plus) '''

But in this case - my actual filename has...

I read the thread and tried some of their suggestions. sp_who2 does not indicate any connections to that DB, but I can't detach b/c it says it is in the...

The answer turns out to be...a service pack/hotfix for sql server 2000. This adds a new parameter called @ansi_attachment that can be set to true. This ensures attachments aren't sent...

The answer turns out to be...a service pack/hotfix for sql server 2000. This adds a new parameter called @ansi_attachment that can be set to true. This ensures attachments aren't sent...