Forum Replies Created

Viewing 15 posts - 676 through 690 (of 911 total)

  • RE: Storing multiple variations of the same data?

    Kevlarmpowered - Thursday, May 10, 2018 11:26 AM

    Can anyone weigh One of the rules of RDBMS is that we don't do display...

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

    May 21, 2018 at 9:34 am

    #1991263

  • RE: Regex in SQL

    I really think that cleaning up data before it goes to the database should be done at another tier in your system. Other languages and tools have much much better...

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

    May 21, 2018 at 9:18 am

    #1991257

  • RE: Getting free periods from booked periods

    My thought would be to pre-allocate periods, using the ISO half open interval model. Then each client would be given one or more periods. The the unallocated periods would...

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

    May 18, 2018 at 8:47 am

    #1991004

  • RE: Is there a maximum number of joins allowed in SQL 2016?

    sgmunson - Thursday, May 17, 2018 2:56 PM

    GBimberg - Thursday, May 17, 2018 2:24 PM

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

    May 17, 2018 at 7:01 pm

    #1990951

  • RE: Return rows where value doesnt exist

    >> First off Joe, the schema has already been built. <<

    It was already built, then why didn't you post the DDL for it? We can't read your mind....

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

    May 17, 2018 at 4:54 pm

    #1990943

  • RE: Return rows where value doesnt exist

    meichmann - Tuesday, May 15, 2018 12:56 PM

    >> I have a slight problem so I hope you can help.
    I have a table...

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

    May 16, 2018 at 2:05 pm

    #1990732

  • RE: SQL Query to pull data

    tapinderaujla - Tuesday, May 15, 2018 12:11 AM

    Your suffering from a lot of problems. First of all, it's not any fun for...

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

    May 16, 2018 at 1:46 pm

    #1990728

  • RE: Updating datetime2 column not working

    WebTechie - Monday, May 7, 2018 3:19 PM

    Hello,

    Trying to update some datetime2 columns.

    UPDATE T_MYTABLE SET dateTransferred = '2018-03-26 05.00.00' where id =...

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

    May 10, 2018 at 8:33 am

    #1990053

  • RE: To CASCADE DELETE or not?

    Orlando Colamatteo - Saturday, May 5, 2018 6:16 AM

    There is a healthy debate going on between a couple teams in my area...

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

    May 7, 2018 at 8:00 am

    #1989506

  • RE: Normalization and Third Normal Form

    Ronnie65 - Sunday, May 6, 2018 2:22 PM

    "Database Design and Relational Theory: Normal Forms and All That Jazz" by C. J. Date ...

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

    May 7, 2018 at 7:45 am

    #1989501

  • RE: Updating a column with serial numbers

    microsoftee - Monday, February 23, 2009 12:04 AM

    I want to update a table's column data with serial number i.e. first row 1,...

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

    April 30, 2018 at 11:10 am

    #1988666

  • RE: Group by month and year

    You don't seem to understand that dates are not kept in strings in SQL. That was COBOL, so doing string operations to pick out the the year, month and date...

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

    April 30, 2018 at 10:46 am

    #1988660

  • RE: Change Data format

    Eirikur Eiriksson - Thursday, April 26, 2018 12:55 AM

    VastSQL - Thursday, April 26, 2018 12:44 AM

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

    April 30, 2018 at 10:37 am

    #1988657

  • RE: Using CASE in a View

    ordnance1 - Monday, April 9, 2018 12:01 PM

    If you get a chance, why don't you learn the ISO 11179 data element naming...

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

    April 10, 2018 at 2:34 pm

    #1986227

  • RE: Updating null fields wehn changing field to not null.

    david_h_edmonds - Wednesday, April 4, 2018 7:16 AM

    >> we have a flat [sic] table in SQL server that has no PK field...

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

    April 6, 2018 at 1:50 pm

    #1985850

Viewing 15 posts - 676 through 690 (of 911 total)