Forum Replies Created

Viewing 15 posts - 496 through 510 (of 911 total)

  • RE: Find date conflicts for tasks and department scenario

    ronwcraig - Saturday, February 9, 2019 9:19 AM

    As per this block

    DECLARE @t1 table (
    id uniqueidentifier PRIMARY KEY,
    activity_id int,
    plan_id...

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

    February 9, 2019 at 9:01 pm

    #2021600

  • RE: Sort already comma separated list

    ScottPletcher - Friday, February 8, 2019 3:47 PM

    Jeff Moden - Friday, February 8, 2019 3:27 PM

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

    February 9, 2019 at 4:40 am

    #2021589

  • RE: Sort already comma separated list

    >> But to create a primary key with an int or bigint all you need to do is define the table like this:

    CREATE TABLE My_Table
    (my_table_id...

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

    February 8, 2019 at 2:04 pm

    #2021556

  • RE: Sort already comma separated list

    Jeff Moden - Tuesday, February 5, 2019 6:04 PM

    jcelko212 32090 - Tuesday, February 5, 2019 2:53 PM

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

    February 8, 2019 at 12:42 pm

    #2021547

  • RE: Which years are similar.

    ben.brugman - Tuesday, February 5, 2019 2:29 AM

    For fun and learning only.
    ===================
    ===================

    Which years are similar to a specific year.
    For example from which...

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

    February 6, 2019 at 9:41 am

    #2021282

  • RE: What it means to atomize values in 1st normal form

    michael.leach2015 - Monday, February 4, 2019 7:25 PM

    >> Suppose we have the following table. We have everything for the address packed into...

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

    February 6, 2019 at 9:35 am

    #2021279

  • RE: Sort already comma separated list

    ScottPletcher - Wednesday, January 30, 2019 11:38 AM

    This topic comes up so much, I think MS should "fudge" a little on the...

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

    February 6, 2019 at 9:11 am

    #2021278

  • RE: Sort already comma separated list

    Jeff Moden - Monday, February 4, 2019 2:28 PM

    jcelko212 32090 - Monday, February 4, 2019 11:16 AM

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

    February 5, 2019 at 2:53 pm

    #2021220

  • RE: Sort already comma separated list

    >> It's stored as numeric because it's more efficient, both in terms of size and in terms of built-in validity checking. <<

    Saving storage space today is not the...

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

    February 5, 2019 at 12:57 pm

    #2021207

  • RE: Sort already comma separated list

    Jeff Moden - Sunday, February 3, 2019 8:08 PM

    jcelko212 32090 - Friday, February 1, 2019 1:46 PM

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

    February 4, 2019 at 11:16 am

    #2021064

  • RE: Sort already comma separated list

    >> I have values like this in a column which basically is the exact same thing if sorted .
    ORM;PS;SUP
    ORM;SUP;PS
    I want to have it as follows...

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

    February 1, 2019 at 1:46 pm

    #2020907

  • RE: Simple question on multiple INNER JOINs

    >> One table is called "Games" which contains a list of software titles. <<

    Where is the DDL for the table? This has been posting netiquette for all SQL...

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

    February 1, 2019 at 1:15 pm

    #2020900

  • RE: CASE with LEN Evaluation

    DinoRS - Friday, February 1, 2019 7:16 AM

    I do have still troubles, as far as I see he can't evaluate properly for...

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

    February 1, 2019 at 11:33 am

    #2020893

  • RE: How do I convert a uk date in string format to date?

    Lorna-331036 - Thursday, January 31, 2019 4:46 AM

    Hi
    A user enters a date in uk format (i.e '24/01/2019') into a web form (.net). ...

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

    January 31, 2019 at 2:41 pm

    #2020779

  • RE: What is Alternative of numbered_procedures?

    parviz.vakili - Sunday, January 27, 2019 6:50 AM

    Tanks dear joe
    but what is the best practice or solution for my scenario?

    Rename them one...

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

    January 27, 2019 at 8:08 am

    #2020223

Viewing 15 posts - 496 through 510 (of 911 total)