Forum Replies Created

Viewing 15 posts - 4,726 through 4,740 (of 8,753 total)

  • RE: Unable to link data from data pulled from XML

    Alan.B (8/13/2015)

    drew.allen (8/13/2015)

    Alan.B (8/13/2015)

    Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include the text()...

    August 14, 2015 at 2:15 am

    #1819968

  • RE: Nesting Case When Statements?

    kevin.ellis86 (8/13/2015)

    So any transaction before 2012-07-19 would have an ID of 9368 and anything after would have an ID of 9369. Again sorry if this doesn't format correctly. Thanks for...

    August 14, 2015 at 1:22 am

    #1819962

  • RE: Customizing a Third Party Application ... One database or two?

    busraker (8/13/2015)

    The upgrades are incremental from the vendor. They don't recreate the database, only add / alter objects. The only risk would be if the vendor introduced an...

    August 13, 2015 at 3:11 pm

    #1819916

  • RE: Are the posted questions getting worse?

    WayneS (8/13/2015)

    Lynn Pettis (8/13/2015)

    WayneS (8/13/2015)

    Why is it SQLServerCentral gets so many Oracle questions on it?

    Do you think it would be beneficial to create an Oracle thread? (Would it actually work?)

    Or...

    August 13, 2015 at 1:20 pm

    #1819865

  • RE: automation

    SQLRNNR (8/13/2015)

    Ed Wagner (8/13/2015)

    I think the bottom line is that we need more information about what you're trying to do to be able to help you.

    No this is the bottom...

    August 13, 2015 at 10:54 am

    #1819805

  • RE: Are the posted questions getting worse?

    Luis Cazares (8/13/2015)

    Eirikur Eiriksson (8/13/2015)

    Grant Fritchey (8/13/2015)

    WayneS (8/13/2015)

    Crystal Ball, report to Aisle 5

    I'm sure that a large part of this is English as a second language. But lordy, can the...

    August 13, 2015 at 9:35 am

    #1819761

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/13/2015)

    WayneS (8/13/2015)

    Crystal Ball, report to Aisle 5

    I'm sure that a large part of this is English as a second language. But lordy, can the questions be worded more...

    August 13, 2015 at 9:30 am

    #1819754

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/13/2015)

    Lynn Pettis (8/13/2015)

    Ed Wagner (8/13/2015)

    I've worked in both environments and really prefer case-insensitive. As a habit, though, I try to write everything as case-sensitive.

    Having been working in...

    August 13, 2015 at 9:24 am

    #1819749

  • RE: Are the posted questions getting worse?

    Jacob Wilkins (8/13/2015)

    Heh, things like that with names always make me shake my head. I recently ran across a database that had table in the dbo schema that also had...

    August 13, 2015 at 9:19 am

    #1819740

  • RE: automation

    Quick suggestion, hire a consultant.

    😎

    August 13, 2015 at 9:12 am

    #1819733

  • RE: Filtering on multiple input pairs

    Quick suggestion on parsing the XML

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    DECLARE @INPUT XML = '<input>

    <pair>

    <acct_no>23423</acct_no>

    <tran_dt>9-11-2015</tran_dt>

    </pair>

    <pair>

    ...

    August 12, 2015 at 11:18 pm

    #1819549

  • RE: Today's Random Word!

    Ed Wagner (8/12/2015)

    SQLRNNR (8/12/2015)

    whereisSQL? (8/12/2015)

    Ed Wagner (8/12/2015)

    Eirikur Eiriksson (8/12/2015)

    Ed Wagner (8/12/2015)

    Steve Jones - SSC Editor (8/12/2015)

    broke

    Spending

    spree

    Candy

    Crush

    saga :crying:

    Series

    Sequence

    August 12, 2015 at 12:55 pm

    #1819487

  • RE: Customizing a Third Party Application ... One database or two?

    busraker (8/12/2015)

    I have a enterprise system that comes with a SQL Server Database. I add functionality to this system by creating my own tables, views, functions, etc. and adding...

    August 12, 2015 at 12:54 pm

    #1819486

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/12/2015)

    Lynn Pettis (8/12/2015)

    < Rant >

    I don't know about others but I am really tired of people thinking that using vulgarity is appropriate in a professional environment and this is...

    August 12, 2015 at 12:38 pm

    #1819480

  • RE: Archiving Data Script

    Welsh Corgi (8/12/2015)

    Brandie Tarvin (8/12/2015)

    Welsh Corgi (8/12/2015)

    Brandie Tarvin (8/11/2015)

    Welsh Corgi (8/11/2015)

    Unfortunately I get your code to work.

    On behalf of everyone who is wondering...

    Why is it unfortunate that you got...

    August 12, 2015 at 12:23 pm

    #1819472

Viewing 15 posts - 4,726 through 4,740 (of 8,753 total)