i think Crystal requires all fields to have a name/alias, right? try this:

SELECT DISTINCT count (accts) AS ACCTCOUNT FROM SOMETABLE WHERE Base like '%bus%'

all that is missing is your WHERE statement after the join, so the SQL knows what to exclude/include in the delete:

delete

from @a

left outer join @b-2 as b

on a.col1 =...

you might also want get the user to connect, and use sp_who or sp_who2 adn see what username they connected with... that might help track down what login they use...

[Builtin\Administrators] would have the same rights as the sa user.....anyone in that group gets mapped to the dbo database owner, so it wouldn't be obvious that they have permissions, since...

this might help: it created either the appropriate DELETE or TRUNCATE statement, and created them in Foreign key hierarchy order.

you'd want to enahcne this so that it doesn't delete your...

ive used this in the past; it's a cursor, and resource intensive; it takes a couple of minutes to run on my 100meg database with 100's of procs and...

soemthing like this is probably what you want: you want to use a case statement to determine how a row gets counted

SELECT SUM(CASE WHEN DUES > 0 THEN 1 ELSE 0...

the EXEC command has no limitation to the length of the command, so you can append variables to death with it..., but sp_executesql has a parameter that has a limit.

can...

you can see a lot of log bloat if you have scheduled jobs that are doing things like DBCC Reindex or other similar maintenance operations. could that be what you...

ive used this in the past; it's a cursor, and resource intensive; it takes a couple of minutes to run on my 100meg database with 100's of procs and 1400+tables:

sample...

translated via Google: basically fill out my survey and maybe win an Ipod:

also psexec is a command line program from sysinternals.com...is that installed in the path on the server?

just one more thing to double check.

take a look at this thread from a couple of years ago...someone adapted the hex scripts to do this:

I see that that takes care of %20 kind of stuff for...

for both SQL's, you'll want to view the estimated execution plans. they will be different, becuase the second sql is returning data from the other table

Is there an index on...

just a bit of clarification:

the program Purge.exe exists on the SQl server itself, right? not locally?

here's a typical example of what i might do: i put file contents in a...