Forum Replies Created

Viewing 15 posts - 4,951 through 4,965 (of 8,754 total)

  • RE: How to improve that query?

    Luis Cazares (7/10/2015)

    Eirikur Eiriksson (7/10/2015)

    Puzzles me though that the last condition will never be hit as it is a subset of the first one, typo perhaps?

    😎

    It's more an optic illusion,...

    July 10, 2015 at 12:40 pm

    #1811733

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/10/2015)

    Eirikur Eiriksson (7/10/2015)

    SQLRNNR (7/10/2015)

    Sean Lange (7/10/2015)

    Just saw this posted as an explanation to a problem.

    I'm new to SQL already researched in the Chinese do not think swimming on...

    July 10, 2015 at 12:15 pm

    #1811720

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

    July 10, 2015 at 12:04 pm

    #1811713

  • RE: Today's Random Word!

    Ed Wagner (7/10/2015)

    Sean Lange (7/10/2015)

    DonlSimpson (7/10/2015)

    Ed Wagner (7/10/2015)

    SQLRNNR (7/10/2015)

    Ed Wagner (7/10/2015)

    Patrick Stewart

    Dempsey

    Jack

    Gene

    Kelly

    Machine Gun

    Thompson

    July 10, 2015 at 11:06 am

    #1811693

  • RE: Today's Random Word!

    SQLRNNR (7/10/2015)

    DonlSimpson (7/9/2015)

    Ed Wagner (7/8/2015)

    DonlSimpson (7/8/2015)

    djj (7/8/2015)

    Ed Wagner (7/8/2015)

    crookj (7/8/2015)

    Ed Wagner (7/8/2015)

    DonlSimpson (7/7/2015)

    Revenant (7/7/2015)

    Ed Wagner (7/7/2015)

    crookj (7/7/2015)

    Ed Wagner (7/7/2015)

    djj (7/7/2015)

    Ed Wagner (7/7/2015)

    TomThomson (7/7/2015)

    Leaf

    Branch

    Root

    Administrator

    SA

    Disabled

    Challenged

    Heracles

    Hercules

    Theseus

    Thesaurus

    Wordy

    Loquacious

    Locutus

    Picard

    What's that?

    Actor

    July 10, 2015 at 9:09 am

    #1811646

  • RE: Are the posted questions getting worse?

    SQLRNNR (7/10/2015)

    Sean Lange (7/10/2015)

    Just saw this posted as an explanation to a problem.

    I'm new to SQL already researched in the Chinese do not think swimming on my mistake

    :w00t:

    Whu??

    Where is the...

    July 10, 2015 at 9:04 am

    #1811643

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (7/10/2015)

    On an unrelated notice, I created my own blog (and moved away from LessthanDot):

    Under the kover of business intelligence[/url]

    And yes, I stole the copyright notice from Grant and...

    July 10, 2015 at 3:11 am

    #1811529

  • RE: run SQL job continuously

    mxy (7/8/2015)

    i want to call a stored procedure continuously. i have only option to schedule using sql job, triggers doesnt help.

    Job calls a sp which loads data. My question is...

    July 9, 2015 at 12:35 pm

    #1811425

  • RE: Are the posted questions getting worse?

    Ed Wagner (7/9/2015)

    Matt Miller (#4) (7/8/2015)

    Alvin Ramard (7/8/2015)

    WayneS (7/8/2015)

    Alvin Ramard (7/8/2015)

    Sanity? Oh Sanity? Where are you hiding?

    I've had it. Enough is enough! When are people gonna stop hiring people...

    July 9, 2015 at 12:24 pm

    #1811418

  • RE: SQL 2012 Install silently fails after term acceptance

    Quick questions, what is the .Net version on the box? Can you install the latest .Net if not already there? It's just a hunch but have the latest (4.6) on...

    July 9, 2015 at 12:18 pm

    #1811415

  • RE: backup concepts

    Further on to Lynn's answer, and coining an oxymoron, the more you spend the less you loose, simplified ((Transaction Volume/Time) x (Cost of backup)) * (1 / (Allowed Data Loss))....

    July 9, 2015 at 11:03 am

    #1811392

  • RE: for automated backups

    sindura.pulimamidi1 (7/9/2015)

    hi,

    could anyone explain me,how would we know to assign the time stamps for automated backups in job schedules....

    thank you

    Quick suggestion, have a look at https://ola.hallengren.com/%5B/url%5D

    😎

    July 9, 2015 at 10:51 am

    #1811387

  • RE: Create XML with parent and child element

    j.grimanis (7/8/2015)

    Hi,

    I want to create an XML file with the below format.

    office_tel and mobile are fields of a table.

    <fields>

    <office_tel>

    <value>1234</value>

    </office_tel>

    ...

    July 9, 2015 at 12:45 am

    #1811184

  • RE: Stored Procedure with interesting behavior

    Quick question, any reason for not supplying the information needed to answer the question?

    😎

    July 9, 2015 at 12:26 am

    #1811182

  • RE: Are the posted questions getting worse?

    Alvin Ramard (7/8/2015)

    WayneS (7/8/2015)

    Alvin Ramard (7/8/2015)

    Sanity? Oh Sanity? Where are you hiding?

    I've had it. Enough is enough! When are people gonna stop hiring people that don't have a clue...

    July 8, 2015 at 2:04 pm

    #1811132

Viewing 15 posts - 4,951 through 4,965 (of 8,754 total)