Forum Replies Created

Viewing 15 posts - 766 through 780 (of 911 total)

  • RE: Having trouble displaying a date in a certain format...

    Jeff Moden - Friday, October 20, 2017 10:50 AM

    jcelko212 32090 - Friday, October 20, 2017 10:35 AM

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

    October 20, 2017 at 12:07 pm

    #1964559

  • RE: Having trouble displaying a date in a certain format...

    chef423 - Wednesday, October 11, 2017 1:03 PM

    Select Invoice_Exceptions.Invoice_Number, Invoice_Exceptions.ItemNum, Inventory.ItemName, Invoice_Exceptions.Amount, Invoice_Exceptions.Quantity,
    Invoice_Exceptions.Reason_Code, Invoice_Exceptions.LineNum, Invoice_Exceptions.EmpName, Invoice_Exceptions.DateTime AS Day_Voided, Invoice_Totals.Payment_Method
    From...

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

    October 20, 2017 at 10:35 am

    #1964528

  • RE: Trying to speed up this 'GetWorkingDays' function.

    Jason A. Long - Tuesday, October 17, 2017 11:57 PM

    Build a calendar table with one column for the calendar...

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

    October 20, 2017 at 10:28 am

    #1964526

  • RE: Using a case statement to determine join

    What you posted is pretty useless and needs to be corrected. For example, did you know that by definition, a table must have a key? We never use the old...

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

    October 16, 2017 at 9:45 am

    #1963865

  • RE: Order by issue

    as1981 - Tuesday, October 10, 2017 7:36 AM

    Instead of inventing your own notation, why don't you use the ISO standard? It's part...

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

    October 12, 2017 at 10:30 am

    #1963424

  • RE: select count of rows based on condition

    sgmunson - Wednesday, October 4, 2017 10:25 AM

    jcelko212 32090 - Wednesday, October 4, 2017 7:42 AM

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

    October 4, 2017 at 12:50 pm

    #1962338

  • RE: Merge to upsert when target table might have legitimate duplicate tuples

    sgmunson - Tuesday, October 3, 2017 3:02 PM

    pisorsisaac - Tuesday, October 3, 2017 2:55 PM

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

    October 4, 2017 at 7:52 am

    #1962252

  • RE: Merge to upsert when target table might have legitimate duplicate tuples

    pisorsisaac - Tuesday, October 3, 2017 2:47 PM

    >> (Please, diatribes regarding why such a table might exist are unneeded; it's not my...

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

    October 4, 2017 at 7:46 am

    #1962248

  • RE: select count of rows based on condition

    bartedgerton - Tuesday, October 3, 2017 10:01 AM

    You have a fundamental problem; you don't understand that SQL has a CASE expression, not...

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

    October 4, 2017 at 7:42 am

    #1962247

  • RE: Strange COALESCE issue

    >> I think it's correct to provide a table structure for any questions so I'll include that first: <<

    yes, this has been basic netiquette for the 30+ years...

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

    October 2, 2017 at 9:53 am

    #1961901

  • RE: How can this query be rewitten?

    vsamantha35 - Saturday, September 30, 2017 1:36 PM

    We need more information before we can help you. Did you read the part in...

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

    September 30, 2017 at 3:58 pm

    #1961784

  • RE: Naming Conventions - Table and Column Names

    TomThomson - Friday, September 29, 2017 7:47 PM

    jcelko212 32090 - Friday, September 29, 2017 4:44 PM

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

    September 30, 2017 at 3:24 pm

    #1961783

  • RE: Naming Conventions - Table and Column Names

    TomThomson - Friday, September 29, 2017 3:34 PM

    jcelko212 32090 - Thursday, September 28, 2017 1:20 PM

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

    September 29, 2017 at 4:44 pm

    #1961755

  • RE: Naming Conventions - Table and Column Names

    BethF - Tuesday, September 26, 2017 1:18 PM

    Google my name and writings on this. This is not a matter of...

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

    September 28, 2017 at 1:20 pm

    #1961455

  • RE: Get the year and Qtr

    ScottPletcher - Wednesday, September 27, 2017 2:20 PM

    Jeff Moden - Monday, September 25, 2017 11:42 AM

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

    September 28, 2017 at 12:40 pm

    #1961445

Viewing 15 posts - 766 through 780 (of 911 total)