Forum Replies Created

Viewing 15 posts - 856 through 870 (of 911 total)

  • RE: No PKs on fact tables

    Lynn Pettis - Thursday, April 13, 2017 12:01 PM

    jcelko212 32090 - Thursday, April 13, 2017 10:42 AM

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

    April 13, 2017 at 12:36 pm

    #1938114

  • RE: No PKs on fact tables

    Jeff Moden - Thursday, April 13, 2017 6:47 AM

    jcelko212 32090 - Monday, April 3, 2017 12:55 PM

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

    April 13, 2017 at 10:42 am

    #1938097

  • RE: Parse numbers from Column

    Jeff Moden - Wednesday, April 12, 2017 7:47 AM

    jcelko212 32090 - Tuesday, April 11, 2017 12:23 PM

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

    April 12, 2017 at 11:03 am

    #1937902

  • RE: Parse numbers from Column

    dba-512085 - Friday, April 7, 2017 4:16 PM

    I have a sql table that stores weight in one column. How would I go...

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

    April 11, 2017 at 12:23 pm

    #1937702

  • RE: Removing Reverse Duplicates

    DesNorton - Wednesday, April 5, 2017 10:08 AM

    This will remove the duplicates


    -- Create a table to hold the data
    CREATE TABLE...

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

    April 11, 2017 at 12:15 pm

    #1937698

  • RE: Numeric as primary key

    Jeff Moden - Monday, April 10, 2017 7:16 PM

    jcelko212 32090 - Monday, April 10, 2017 3:10 PM

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

    April 11, 2017 at 11:27 am

    #1937681

  • RE: Numeric as primary key

    kaushikchin2 - Thursday, March 30, 2017 8:22 AM

    Hi,

    Is it advisable to use numeric(19,0) as primary key? I do no want to use...

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

    April 10, 2017 at 3:10 pm

    #1937519

  • RE: Numeric as primary key

    kaushikchin2 - Thursday, March 30, 2017 8:22 AM

    Hi,

    Is it advisable to use numeric(19,0) as primary key? I do no want to use Bigint because...

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

    April 10, 2017 at 3:05 pm

    #1937518

  • RE: How to join these tables together

    Jeff Moden - Wednesday, April 5, 2017 4:40 PM

    jcelko212 32090 - Wednesday, April 5, 2017 12:57 PM

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

    April 5, 2017 at 5:49 pm

    #1936939

  • RE: How to join these tables together

    Jeff Moden - Tuesday, April 4, 2017 6:22 PM

    Bill Talada - Tuesday, April 4, 2017 12:23 PM

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

    April 5, 2017 at 12:57 pm

    #1936897

  • RE: subquery

    hlsc1983 - Sunday, April 2, 2017 4:14 AM

    this is  my query
    select Students.student_rollno, marks, Subjects.subject_name ,Subjects.subject_id, Gradetype.Grade_id, TheoryPractical .ThPr_name, EndtermProgressive. ETPA_name
    ...

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

    April 3, 2017 at 1:44 pm

    #1936410

  • RE: No PKs on fact tables

    robert.gerald.taylor - Friday, March 31, 2017 6:52 AM

    I just inherited a data warehouse where none of the fact tables have a primary...

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

    April 3, 2017 at 12:55 pm

    #1936405

  • RE: How to join these tables together

    Jeff Moden - Sunday, April 2, 2017 5:01 PM

    jcelko212 32090 - Sunday, April 2, 2017 11:33 AM

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

    April 3, 2017 at 9:00 am

    #1936312

  • RE: How to join these tables together

    Jeff Moden - Thursday, March 30, 2017 8:24 PM

    jcelko212 32090 - Thursday, March 30, 2017 1:33...

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

    April 2, 2017 at 11:33 am

    #1936178

  • RE: How to join these tables together

    Joe Torre - Thursday, March 30, 2017 2:26 PM

    The ANSI/ISO standards which you should use should begin with the current version of...

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

    April 1, 2017 at 6:13 pm

    #1936141

Viewing 15 posts - 856 through 870 (of 911 total)