Forum Replies Created

Viewing 15 posts - 571 through 585 (of 911 total)

  • RE: NOT IN vs NOT EXISTS

    The [NOT] EXISTS() is one of the few we've got in SQL. The can return only TRUE and FALSE; most of the others can return an UNKNOWN logical value. The...

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

    October 25, 2018 at 3:46 pm

    #2011265

  • RE: CASE to table conversion

    Brandie Tarvin - Tuesday, October 23, 2018 5:34 AM

    Any thoughts would be appreciated. I don't need code per say. Just brainstorming...

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

    October 25, 2018 at 3:33 pm

    #2011263

  • RE: How to do a basic loop in SQL

    barry.nielson - Tuesday, October 23, 2018 3:55 PM

    SQL is not a procedural language; it's declarative. That means we don't have loops, we...

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

    October 24, 2018 at 2:15 pm

    #2011012

  • RE: increment months for two dates combination as a new label column

    Jonathan AC Roberts - Monday, October 22, 2018 5:07 PM

    Phil Parkin - Monday, October 22, 2018 4:58...

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

    October 24, 2018 at 2:07 pm

    #2011010

  • RE: Find average of child records within date range

    Why did you fail to post DDL? Now we have to guess from what you did post and how to correct it. But more than that, you have no idea...

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

    October 24, 2018 at 1:59 pm

    #2011005

  • RE: Display 'blank' cell when it is null.

    keneangbu - Friday, October 19, 2018 2:03 PM

    The data type of the column is decimal(9,2). I wanted an empty cell to...

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

    October 19, 2018 at 7:35 pm

    #2010489

  • RE: Count people who have dual citizenship

    sindhupavani123 - Monday, October 15, 2018 4:46 AM

    I see that you feel you are exempt from the rules of the...

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

    October 15, 2018 at 4:50 pm

    #2009770

  • RE: Audit Trial help

    SQL learner22 - Monday, October 15, 2018 10:15 AM

    The new Trigger Table should hold  new values and old values...

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

    October 15, 2018 at 4:37 pm

    #2009769

  • RE: Finding recent date from two tables

    salamlemon - Wednesday, October 10, 2018 9:20 PM

    >> I have a table design like below. <<

    thank you for posting DDL; so...

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

    October 15, 2018 at 3:25 pm

    #2009760

  • RE: Understanding the numeric and decimal data types

    michael.leach2015 - Monday, October 8, 2018 7:41 PM

    Jonathan AC Roberts - Saturday, October 6, 2018 7:18 PM

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

    October 9, 2018 at 12:54 pm

    #2008728

  • RE: Understanding the numeric and decimal data types

    michael.leach2015 - Thursday, October 4, 2018 9:42 PM

    NUMERIC(s,p) and DECIMAL(s,p) are the same in SQL Server, which they inherited from Sybase. This...

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

    October 8, 2018 at 11:13 am

    #2008583

  • RE: Finding when date changes for customer in table

    mnovosel - Thursday, September 27, 2018 10:32 AM

    In table UserData, it accumulates rows for users every time there is some sort of...

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

    September 27, 2018 at 5:10 pm

    #2007322

  • RE: Finding when date changes for customer in table

    mnovosel - Thursday, September 27, 2018 10:32 AM

    In table UserData, it accumulates rows for users every time there is some sort of...

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

    September 27, 2018 at 5:09 pm

    #2007321

  • RE: Referential Integrity vs. Performance

    >> We have a voting application where users can vote on Issues. In this scenario a user can cast one of three possible values for his/her vote. FOR, AGAINST, ABSTAIN...

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

    September 26, 2018 at 1:12 pm

    #2007148

  • RE: Is there a better way to write a simple query?

    Lynn Pettis - Wednesday, September 19, 2018 11:37 AM

    jcelko212 32090 - Wednesday, September 19, 2018 11:28 AM

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

    September 19, 2018 at 2:49 pm

    #2006353

Viewing 15 posts - 571 through 585 (of 911 total)