Viewing 15 posts - 1 through 15 (of 21 total)
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...
March 7, 2005 at 4:16 am
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...
March 5, 2005 at 5:37 am
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...
March 4, 2005 at 5:18 pm
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...
March 4, 2005 at 5:11 pm
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...
March 4, 2005 at 5:08 pm
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...
March 3, 2005 at 2:34 pm
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...
March 3, 2005 at 2:30 pm
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...
March 2, 2005 at 1:17 pm
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,...
March 2, 2005 at 1:07 pm
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...
March 2, 2005 at 1:02 pm
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...
March 2, 2005 at 1:00 pm
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...
March 2, 2005 at 12:56 pm
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...
March 2, 2005 at 12:53 pm
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...
March 2, 2005 at 12:38 pm
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...
March 2, 2005 at 12:34 pm
Viewing 15 posts - 1 through 15 (of 21 total)