hey grasshopper,

I agree with Jeff that more than likely, you are better off making a smarter statement rather than resorting to dynamic SQL. I think the only time I...

Something like this should cut it for you:

Declare @SQL as varchar(200)

Declare @Value int

Set @SQL = 'SELECT ID, Name, Description FROM Table1 WHERE Name = ''A'''

IF @Value = 0

 BEGIN

  Set @SQL =...

try port scanning the server and see if any other ports in the vicinity are open. use Nmap for this. use the -P0 (zero) command to not ping scan the...

try looking into xp_smtp_sendmail (google it, it is an extended stored proc). Then write a wrapper proc that sends to more than one email server (which can be specified in...

you know, I have seen quite a few optimization programs that all prefer to use the COALESCE over any IN, EXIST or UNION queries. I always thought that there must be a...

Then again, here is article that might shed some light on speed and efficiency.

http://archives.postgresql.org/pgsql-performance/2002-12/msg00185.php

seems that exists is better on larger sub-selects, where as in can be better on smaller...

something like this should work if your indexes are clean

select account_number

from table1

Where InactiveFlag=1

AND (

Account_number IN ( Select Distinct AccountNumber From table2 )

OR Account_number IN ( Select Distinct AccountNumber From table3...

okay,

can you intercept this resume data and save it to a textfile? It is possible that the problem isnt so much in SQL as it is in the way the...

lol .. well, I guess that is why you are an addict and I am a mere grasshopper.

When run as a batch.

Declare @table table ( MyColumn varchar(50), iCount int,...

understood what he wants to accomplish. Seems to me that there is less load adding only the records he needs to the temp table, then updating the table with the...

That is a really interesting way of doing that Dave. It seems like it would create more overhead though when used as a temp table like that. Interesting though, because...

actually, I am not sure that it is your only option is what I meant to say.

based on what you added, you would (if you were to implement a file...

I dont have an answer to that unfortunatly. I wonder, how is the data getting into the column in the first place? When it comes out, is it all one...

what about saving their resumes as files on the server and storing a link or the path to that file in the DB? seems like it would answer your question...

agreed with the combo approach of @table and multiple queries to getting the data you want. Something similiar to this.

Declare @table table ( MyColumn varchar(50), iCount int, iTotal int )

Insert...