Forum Replies Created

Viewing 15 posts - 2,986 through 3,000 (of 8,761 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/27/2016)

    BrainDonor (10/27/2016)

    Phil Parkin (10/26/2016)

    Any clairvoyants here today?

    I knew you were going to ask that...

    I foresee that question being asked again in the very near future.

    😉

    Do you see anything...

    October 27, 2016 at 5:20 am

    #1909086

  • RE: Strange result using SUM with ISNULL(NULLIF...

    david.jack (10/27/2016)

    Hmmmm... it doesn't work in my scenario but, as per your assessment, the formula does seem to be correct, so my results must be the product of joins/grouping I...

    October 27, 2016 at 5:18 am

    #1909085

  • RE: Strange result using SUM with ISNULL(NULLIF...

    david.jack (10/27/2016)

    Hi,

    I'm very grateful for any light that can be shed on this. My code was per the following:

    SUM( ISNULL( NULLIF(VAL1,0), VAL2) )

    My understanding is that this should return the...

    October 27, 2016 at 4:42 am

    #1909075

  • RE: Need extract XML column data with SQL

    Sachin Butala-182900 (10/27/2016)

    Awesome, you made my day, Thanks

    You are very welcome.

    😎

    October 27, 2016 at 4:35 am

    #1909074

  • RE: historical queries

    sqlserverDBA2016 (10/27/2016)

    Hi guys

    is it possible to retrieve queries which ran a week ago in a sql server database.

    So far i'm only able to retrieve up to one day using...

    October 27, 2016 at 3:06 am

    #1909061

  • RE: Need extract XML column data with SQL

    Sachin Butala-182900 (10/27/2016)

    I have below XML in Table column and need to extract all account details.

    number | type | nickname

    Quick solution

    😎

    DECLARE @TXML XML = '<profile xmlns="http://schemas.clairmail.com/2008/01/Model/extensions" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <disabledState>

    ...

    October 27, 2016 at 2:56 am

    #1909060

  • RE: sql server 2012 Integration Services will not start

    tcronin 95651 (10/26/2016)

    Vmware host took a dive about a week ago all servers went down. Everything came back up but now Integration Services will not start (uses same account...

    October 26, 2016 at 2:04 pm

    #1908996

  • RE: Upgrade from SQL 2005... to Which Version ?

    homebrew01 (10/26/2016)

    I'm considering upgrading our production server from 2005, at the same time we upgrade servers. I have not kept up on the most recent versions. No specific need to...

    October 26, 2016 at 1:46 pm

    #1908993

  • RE: Field Order in XML generated from Stored Procedure

    groverparkgeorge (10/26/2016)

    That's much closer. Still a bit of tweaking, I think.

    Thank you.

    George

    Good stuff, just ping back here if you run into any problems

    😎

    October 26, 2016 at 1:34 pm

    #1908988

  • RE: Field Order in XML generated from Stored Procedure

    groverparkgeorge (10/26/2016)

    I apologize if this has been covered, but I couldn't find a reference that fits.

    I have been asked to support an existing web site--the original developer is out of...

    October 26, 2016 at 10:59 am

    #1908943

  • RE: Windows Function

    Worth having a look at Koen's article, Beware the defaults! (in windowing functions)[/url]

    😎

    October 26, 2016 at 9:23 am

    #1908926

  • RE: I want to Encrypt data in tables

    mickegohle (10/26/2016)

    Hi folks,

    So, I want to encryot some columns in cetain tables in a database.

    I was thinking creating a table where I specify which tables and columns to be encrypted...

    October 26, 2016 at 7:36 am

    #1908887

  • RE: Are the posted questions getting worse?

    Phil Parkin (10/26/2016)

    BWFC (10/26/2016)

    jasona.work (10/26/2016)

    Brandie Tarvin (10/26/2016)

    jasona.work (10/26/2016)

    Phil Parkin (10/26/2016)

    HanShi (10/26/2016)

    BLOB_EATER (10/26/2016)

    Lynn Pettis (10/25/2016)

    Spammers are getting better, now even the topics they post look legit.

    I liked Eric's response - "get...

    October 26, 2016 at 7:18 am

    #1908878

  • RE: SQL server memory reduced to zero

    kesavan.rv (10/26/2016)

    Hi Friends,

    All off sudden in my PROD SQL server memory was reduced to zero(As the minimum memory was set to 0).

    Is there any way to find which one...

    October 26, 2016 at 7:15 am

    #1908876

  • RE: RabbitMQ via SQL Server

    Jeff Moden (10/25/2016)

    TryingToLearn (10/25/2016)

    i need to create a queue via a trigger(i'm assuming) that will be consumed by a service/event bus in RabbitMQ. Would MSMQ be the proper way to...

    October 26, 2016 at 4:12 am

    #1908831

Viewing 15 posts - 2,986 through 3,000 (of 8,761 total)