Forum Replies Created

Viewing 15 posts - 721 through 735 (of 911 total)

  • RE: Remove duplicate record based on criteria

    micang - Tuesday, January 30, 2018 1:58 PM

    I have the following data set below - I have identified duplicates which is purely...

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

    January 31, 2018 at 3:19 pm

    #1978111

  • RE: Calendar table

    tt-615680 - Tuesday, January 30, 2018 8:40 AM

    I have been trying to find out the best way to design a Normalized table...

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

    January 31, 2018 at 9:30 am

    #1978055

  • RE: Calendar table

    tt-615680 - Tuesday, January 30, 2018 8:40 AM

    I have been trying to find out the best way to design a Normalized table for

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

    January 31, 2018 at 9:29 am

    #1978054

  • RE: Help me in update - complex

    JoNTSQLSrv - Wednesday, January 24, 2018 8:41 AM

    hi All, 

      Hope all are fine
    create table #sample(id varchar(100), version_no int,...

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

    January 26, 2018 at 11:18 am

    #1977566

  • RE: help with the SELECT statement syntax.

    mw112009 - Wednesday, January 24, 2018 3:33 PM

    if object_id('tempdb..#rx') IS NOT NULL DROP TABLE #rx
    GO

    create table #rx( MemN VARCHAR(15), ClaimNumber...

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

    January 26, 2018 at 10:18 am

    #1977557

  • RE: Question Regarding Date logic

    ScottPletcher - Tuesday, January 23, 2018 2:24 PM

    Does YYYY-MM-00 -- not to mention YYYY-00-00 -- raise 1NF / atomicity issues?  Does the...

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

    January 23, 2018 at 5:54 pm

    #1977024

  • RE: Question Regarding Date logic

    Jeff Moden - Tuesday, January 23, 2018 9:47 AM

    jcelko212 32090 - Tuesday, January 23, 2018 8:30 AM

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

    January 23, 2018 at 10:59 am

    #1976960

  • RE: Question Regarding Date logic

    KGJ-Dev - Friday, January 19, 2018 9:16 AM

    Hi,

    I need to get Year, monthname in three letters, startdate and enddate  of the month for...

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

    January 23, 2018 at 8:30 am

    #1976918

  • RE: Compare two rows in the same table for equality in SQL

    sujeeth.selvam - Friday, January 19, 2018 12:34 PM

    >> have the following table in my database: <<

    Where is the DDL for this...

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

    January 20, 2018 at 5:30 pm

    #1976636

  • RE: How to use HAVING with MAX on dates.

    >> I need to do a report for sales reps showing the customers that have not ordered between a set of chosen dates. I need to break the dates down....

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

    January 18, 2018 at 10:29 am

    #1976381

  • RE: SELECT all negative values, that have a positive value

    adiedler - Tuesday, January 9, 2018 10:05 AM

    >> Ok, it is more or less a general question. <<

    We still need the DDL,...

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

    January 10, 2018 at 12:10 pm

    #1975359

  • RE: Composite Key Assistance

    John524 - Saturday, January 6, 2018 8:18 AM

    Indexes in transact SQL are built in the order in which the columns are declared....

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

    January 9, 2018 at 9:53 am

    #1975113

  • RE: delete records from table which are not active.

    TheSQLGuru - Thursday, January 4, 2018 1:43 PM

    aaron.reese - Thursday, January 4, 2018 7:47 AM

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

    January 6, 2018 at 12:23 pm

    #1974812

  • RE: delete records from table which are not active.

    mcfarlandparkway - Wednesday, January 3, 2018 2:39 PM

    >> I have a table, where it has status like active, terminated. <<

    Where is the...

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

    January 3, 2018 at 8:02 pm

    #1974380

  • RE: Is My Foreign Key Table Unnecessary?

    Phil Stratford - Tuesday, January 2, 2018 8:12 AM

    Your first problem is that there is no such thing as a "<something>_type_id" in...

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

    January 3, 2018 at 5:59 pm

    #1974373

Viewing 15 posts - 721 through 735 (of 911 total)