Forum Replies Created

Viewing 15 posts - 6,451 through 6,465 (of 7,164 total)

  • RE: Conditional Counting

    Welsh Corgi (5/12/2011)

    If this is in Oracle then you should probably be using PL/SQL and posting your question to an Oracle Forum.

    Ditto. We have a hard enough time with keeping...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 10:29 am

    #1323810

  • RE: Transpose in SQL & SYBASE

    Here is a slight variation which will protect you against new "type" values added to your database down the line from altering your expected results:

    Yours (re-formatted):

    SELECT b_id,

    ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 10:25 am

    #1323809

  • RE: Executing a bat file which resides on another server

    I think you need to surround the path with double quotes because it has a space in it...something like this:

    /c "\\ServerName\AX\WT A to B\Mileage.Bat"

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 10:14 am

    #1323801

  • RE: Can we increase @query_result_width (size) when using MSDB.DBO.SP_SEND_DBMAIL (stored procedure)

    Google is your friend.

    http://stackoverflow.com/questions/997628/how-do-i-increase-the-maximum-allowed-attachment-size-for-email-sent-using-msdb-d

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 10:06 am

    #1323792

  • RE: Conditional Counting

    Is this for Oracle? What is VARCHAR2(7 BYTE) ?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 10:01 am

    #1323787

  • RE: Conditional Counting

    Indexes? Keys?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 10:00 am

    #1323786

  • RE: Sending batches of SPs at one time from Application

    JKSQL (5/12/2011)

    It is .Net but the problem I have is we are forced to code to 2005 and greater. That means my TVP is a CSV. They are...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 9:44 am

    #1323772

  • RE: Sending batches of SPs at one time from Application

    sturner (5/12/2011)

    Well here are two concrete reasons why not to do it the way they are doing it:

    1) Performance: there is a overhead associated with each batch, from the network...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 9:41 am

    #1323769

  • RE: Sending batches of SPs at one time from Application

    JKSQL (5/12/2011)

    The developers I am working with are taking to the idea of stored procedures which is great. Problem is now they seem to be sending batches of stored...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 9:27 am

    #1323752

  • RE: Conditional Counting

    Here's a solution using CROSS APPLY that builds off Dixie's idea but does not require an aggregate table to be maintained. It seems to perform well compared to the other...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 7:28 am

    #1323651

  • RE: SQL Server 2008 / R2 date vs int

    No problem...thanks for bringing out the conversation. If you have a moment please post back if there are further findings or developments in the data type choice.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 7:08 am

    #1323636

  • RE: Divide By Zero Error

    No problem...if you have a moment please post back when you arrive at the root cause and/or a solution.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 7:06 am

    #1323633

  • RE: Is there any way to run the query more than 8000 character via openquery?

    lindsaywang (5/11/2011)

    ...but it has a restriction that we should know the table structure before we insert the data into the table

    I only presented the INSERT INTO...EXEC() AT technique because you...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 7:04 am

    #1323631

  • RE: Join a query to a table

    Jason-299789 (5/12/2011)

    Thanks for the feed back opc, especially on the Distinct vs Group By modification and the tips on XML escaping characters, based on the opening post I would have...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 12, 2011 at 7:01 am

    #1323627

  • RE: Conditional Counting

    The Dixie Flatline (5/11/2011)

    One approach is to use SUM(CASE...) in place of COUNT().

    The trick is to make the test for an earlier Trans_Type = 1 quick. ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 11, 2011 at 4:38 pm

    #1323423

Viewing 15 posts - 6,451 through 6,465 (of 7,164 total)