Forum Replies Created

Viewing 15 posts - 1 through 15 (of 7,428 total)

  • RE: Odd Behavior by Instance

    Phil Parkin - Tuesday, July 25, 2017 10:56 AM

    Antares686 - Tuesday, July 25, 2017 9:36 AM

    July 25, 2017 at 11:19 am

    #1952627

  • RE: Odd Behavior by Instance

    Phil Parkin - Tuesday, July 25, 2017 8:49 AM

    Another thing you could try, if you are unable to post the detailed information...

  • RE: Odd Behavior by Instance

    Lynn Pettis - Tuesday, July 25, 2017 8:38 AM

    Change this:

    AND A.[ACCT] NOT IN
                (
                  SELECT
                    [ACCT]
                  FROM
                    [dbo].[TABLEB]
                  WHERE
                    [FSCD]...

  • RE: Odd Behavior by Instance

    Antares686 - Tuesday, July 25, 2017 6:44 AM

    Unfortunately don't have a DBA available right now as ours just retired and they have...

  • RE: Odd Behavior by Instance

    Jacob Wilkins - Monday, July 24, 2017 3:29 PM

    ..the query which takes about 2 seconds to run normally clocks until the timeout...

  • RE: Odd Behavior by Instance

    Jacob Wilkins - Monday, July 24, 2017 2:30 PM

    Still no real detail. 🙂 Unfortunately, to us "quits working correctly" is no better...

  • RE: Odd Behavior by Instance

    Lynn Pettis - Monday, July 24, 2017 2:54 PM

    Not a clue.  We can't see what you see.  Could you solve this...

  • RE: Odd Behavior by Instance

    Lynn Pettis - Monday, July 24, 2017 2:05 PM

    Without more information, hard to say.  Since it looks like you can't provide much...

  • RE: How to improve that query?

    Luis Cazares (7/16/2015)


    I just made up some sample data including the columns mentioned in the query and an additional to group by so I can show you the different...

  • RE: How to improve that query?

    Luis Cazares (7/15/2015)


    Chris Wooding (7/14/2015)


    Antares686 (7/13/2015)


    Kutang Pan (7/10/2015)


    Is there any other way to write the below query:

    SELECT

    SUM(CASE WHEN Type = 4 AND STATUS IN (1, 2, 3) THEN...

  • RE: How to improve that query?

    Kutang Pan (7/10/2015)


    Is there any other way to write the below query:

    SELECT

    SUM(CASE WHEN Type = 4 AND STATUS IN (1, 2, 3) THEN Value ELSE 0 END)

    ,SUM(CASE WHEN...

  • RE: Convert Varchar to Int

    As stated we do need more information on your goal. However, typically the only reason I have seen to worry about making numeric data in mixed varchar sets int was...

  • RE: Integrated Authentication - External Data Source

    My understanding is that you are correct in that the hop doesn't know the credentials to use for the connection thus Anonymous. SPN is one method. There are other methods...

  • RE: Is SQL Server Mature?

    Maturity is a subjective concept. It has gone more than 3 versions then by standards and the fact it is often adopted shows it is mature. The question always has...

  • RE: Using a column name in a COUNT function

    Sean Lange (10/15/2013)


    Antares686 (10/15/2013)


    Charles Kincaid (10/15/2013)


    What I would actually like to see is COUNT() to mean to count the number of rows.

    I would like to only have to type COUNT()...

Viewing 15 posts - 1 through 15 (of 7,428 total)