Forum Replies Created

Viewing 15 posts - 1 through 15 (of 21 total)

  • RE: SQL Query Combine with string

    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...

  • RE: SQL Query Combine with string

    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...

  • RE: my ISP won''''t open port 1433

    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...

  • RE: Alternative to SQLMail

    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...

  • RE: Need help with tsql syntax

    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...

  • RE: Need help with tsql syntax

    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...

  • RE: Need help with tsql syntax

    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...

  • RE: nvarchar formatting?

    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...

  • RE: Way to get full @@rowcount even when using "top"?

    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,...

  • RE: Way to get full @@rowcount even when using "top"?

    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...

  • RE: Returning a record for each day in a range

    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...

  • RE: nvarchar formatting?

    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...

  • RE: nvarchar formatting?

    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...

  • RE: nvarchar formatting?

    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...

  • RE: Way to get full @@rowcount even when using "top"?

    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...

Viewing 15 posts - 1 through 15 (of 21 total)