Forum Replies Created

Viewing 15 posts - 556 through 570 (of 911 total)

  • RE: Column names on INNER JOINS

    Jeff Moden - Tuesday, November 13, 2018 6:34 AM

    jcelko212 32090 - Monday, November 12, 2018 5:04 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    November 13, 2018 at 8:58 am

    #2013337

  • RE: Column names on INNER JOINS

    gvoshol 73146 - Friday, November 9, 2018 5:43 AM

    jcelko212 32090 - Thursday, November 8, 2018 3:27 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    November 13, 2018 at 8:32 am

    #2013330

  • RE: Column names on INNER JOINS

    The legacy Sybase functions reflect a COBOL mentality, and not an SQL or RDBMS model the world. You mentioned that the CONVERT() allows formatting; but what's the rule about doing...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    November 12, 2018 at 5:04 pm

    #2013283

  • RE: Column names on INNER JOINS

    michael.leach2015 - Sunday, November 11, 2018 6:01 PM

    Jeff Moden - Sunday, November 11, 2018 1:59 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    November 12, 2018 at 10:00 am

    #2013238

  • RE: Column names on INNER JOINS

    I am new to SQL so I'm still unfamiliar with many of the terms and concepts. What do you mean when you say:

    1. Post DDL
    SQL has...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    November 10, 2018 at 4:00 pm

    #2013111

  • RE: Julian Date

    irehman - Saturday, November 10, 2018 8:25 AM

    Jeff has given you a kludge it will get you started, but you really need...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    November 10, 2018 at 2:54 pm

    #2013108

  • RE: Column names on INNER JOINS

    gvoshol 73146 - Friday, November 9, 2018 5:43 AM

    jcelko212 32090 - Thursday, November 8, 2018 3:27 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    November 10, 2018 at 8:30 am

    #2013070

  • RE: Column names on INNER JOINS

    michael.leach2015 - Tuesday, November 6, 2018 6:57 PM

    You need to get a good book on basic data modeling. A data element in...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    November 8, 2018 at 3:27 pm

    #2012916

  • RE: Data modelling: how do you handle child records when doing a soft-delete?

    >> 1. I'm unsure how to word the original post succinctly without using the term "parent/child relationship" or "hierarchical relationship". If I had said the below would it fit better?

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    October 28, 2018 at 12:32 pm

    #2011464

  • RE: Data modelling: how do you handle child records when doing a soft-delete?

    drew.allen - Friday, October 26, 2018 3:05 PM

    jcelko212 32090 - Friday, October 26, 2018 1:57 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    October 26, 2018 at 4:36 pm

    #2011432

  • RE: Splitting value into multiple rows based on size variable

    Jackie Lowery - Friday, October 26, 2018 11:11 AM

    I have a table of product lots that looks like this:

    lot_no       ...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    October 26, 2018 at 3:26 pm

    #2011430

  • RE: Identifying the 3rd qualifying record

    >> I have a scenario where the client wants to identify the 3rd successful attempt at contacting a customer within 5 days of each other. <<

    Why...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    October 26, 2018 at 3:16 pm

    #2011428

  • RE: Data modelling: how do you handle child records when doing a soft-delete?

    Andrew P - Thursday, October 25, 2018 9:18 PM

    If this was a wildlife forum, you’d be the guy who’s talking about grizzly...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    October 26, 2018 at 1:57 pm

    #2011417

  • RE: NOT IN vs NOT EXISTS

    drew.allen - Friday, October 26, 2018 7:58 AM

    Thom A - Friday, October 26, 2018 1:56 AM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    October 26, 2018 at 10:38 am

    #2011380

  • RE: EXCEPT operator problem

    Sybase created this ambiguous syntax (yes, it has some huge cardinality problems; it tends to use the last row physically stored on the disk when there are duplicates). This...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    October 25, 2018 at 4:14 pm

    #2011268

Viewing 15 posts - 556 through 570 (of 911 total)