Forum Replies Created

Viewing 15 posts - 736 through 750 (of 911 total)

  • RE: suggestion on table order inside a join ?

    vsamantha35 - Tuesday, December 26, 2017 9:15 PM

    Does the order in which the tables are placed inside a join matter for getting...

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

    December 28, 2017 at 3:33 pm

    #1973783

  • RE: ORDER By Based on Company then SubCompany

    Jeff Moden - Saturday, December 9, 2017 10:13 PM

    jcelko212 32090 - Saturday, December 9, 2017 12:35 PM

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

    December 28, 2017 at 3:25 pm

    #1973782

  • RE: stored procedure returns a blank cell instead of NULL

    tomyang03 - Monday, December 18, 2017 1:46 PM

    An integer salary? A company where the personnel have hundred character names written in Unicode...

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

    December 20, 2017 at 8:25 pm

    #1973032

  • RE: Null Value Behaving Weird in SQL Query

    rocky_498 - Thursday, December 14, 2017 9:43 PM

    Hi Guys,

    Need help to understand, Please help me to understand....

    Here is my sample data
    ID,FNAME,LNAME,STATUS
    1,Smith,Sam,Active
    2,Faid,Kim,Null
    3,Jim,Al,Null

    My...

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

    December 17, 2017 at 1:02 pm

    #1972409

  • RE: computed columns

    etl2016 - Sunday, December 10, 2017 7:01 AM

    Your approached RDBMS is completely wrong. SQL and the relational model are based on sets....

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

    December 11, 2017 at 12:34 pm

    #1971648

  • RE: ORDER By Based on Company then SubCompany

    Jeff Moden - Friday, December 8, 2017 2:52 PM

    Seems to me that the hierarchy here won't change often.  This is a prime...

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

    December 9, 2017 at 12:35 pm

    #1971456

  • RE: "Tag" highest value in the month

    Simple SQL Tips - Friday, December 8, 2017 6:04 PM

    I'm new to SQL and trying to figure out how I can place...

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

    December 9, 2017 at 12:33 pm

    #1971455

  • RE: Remove duplicate values

    saravanatn - Wednesday, December 6, 2017 1:00 AM

    >>In the below table records [sic] are grouped by ID column. If the count for...

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

    December 7, 2017 at 11:51 am

    #1971256

  • RE: Sorting after records deleted

    webskater - Monday, December 4, 2017 6:08 AM

    You really don’t understand what a table is or how RDBMS works....

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

    December 7, 2017 at 10:49 am

    #1971223

  • RE: Resolving many to many linkage

    pietlinden - Wednesday, November 29, 2017 9:01 AM

    There's a standard way to deal with a many-to-many relationship - a junction table. Think...

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

    December 1, 2017 at 10:21 am

    #1970324

  • RE: Resolving many to many linkage

    rkordonsky 63916 - Wednesday, November 29, 2017 8:32 AM

    .

    Can you please get a book on basic RDBMS and what a table...

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

    December 1, 2017 at 10:02 am

    #1970320

  • RE: The Nonsensical Count

    Steve Jones - SSC Editor - Monday, November 27, 2017 9:41 PM

    Comments posted to this topic are about the item The...

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

    November 28, 2017 at 10:35 am

    #1969764

  • RE: How to make distinct when column is not in the view

    craig.jenkins - Friday, November 17, 2017 6:36 AM

    Did you read the rules of this forum? Where is the DDL you didn't post?...

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

    November 21, 2017 at 10:21 am

    #1969043

  • RE: Delete syntax not working

    Jeff Moden - Sunday, November 5, 2017 7:25 PM

    jcelko212 32090 - Friday, November 3, 2017 4:57...

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

    November 11, 2017 at 1:29 pm

    #1967646

  • RE: Date Ranges - Simple, but seemingly impossible

    Vegeta7 - Tuesday, November 7, 2017 2:34 AM

    Thank you all so much for kindly taking the time to come up with your...

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

    November 7, 2017 at 1:00 pm

    #1967050

Viewing 15 posts - 736 through 750 (of 911 total)