Forum Replies Created

Viewing 15 posts - 886 through 900 (of 911 total)

  • RE: Format Date but Keep as Date Type

    walter.dziuba - Sunday, March 5, 2017 9:16 AM

    I have a date field of type datetime in a table.

    But while I'm creating a...

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

    March 6, 2017 at 12:02 pm

    #1931895

  • RE: TRIGGERS ON VIEWS

    ExhibitA - Monday, March 6, 2017 10:16 AM

    jcelko212 32090 - Monday, March 6, 2017 10:11 AM

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

    March 6, 2017 at 10:38 am

    #1931876

  • RE: TRIGGERS ON VIEWS

    ExhibitA - Monday, March 6, 2017 8:02 AM

    Your column names are still pretty vague and I'm trying to figure out why the...

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

    March 6, 2017 at 10:11 am

    #1931870

  • RE: TRIGGERS ON VIEWS

    ExhibitA - Wednesday, March 1, 2017 2:08 AM

    Thanks for all the replies I realized that its much easier to edit the select...

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

    March 2, 2017 at 9:51 am

    #1931249

  • RE: Roll from lowest level child to it's subsequent parent

    PSB - Sunday, February 26, 2017 8:28 PM

    Any help will be appreciated..

    We need to redo your schema as it makes no sense. By definition,...

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

    February 28, 2017 at 8:16 am

    #1930713

  • RE: Find Matching People in table based on similar values

    thomashohner - Monday, February 20, 2017 11:25 AM

    Hello All,
    I'm trying to find a method that will run on Data-sets of 100K rows...

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

    February 22, 2017 at 10:21 am

    #1929787

  • RE: Running Totals over multiple sets with a pivot

    anthony.green - Tuesday, February 21, 2017 7:54 AM

    Hi All

    Bit of a mental block, probably from looking at this a bit to much,...

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

    February 21, 2017 at 7:04 pm

    #1929641

  • RE: Many to Many Relationship Design Query

    jcelko212 32090 - Tuesday, February 21, 2017 3:10 PM

    kevin.obrien 66193 - Monday, February 20, 2017 9:07 AM

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

    February 21, 2017 at 3:10 pm

    #1929632

  • RE: Many to Many Relationship Design Query

    kevin.obrien 66193 - Monday, February 20, 2017 9:07 AM

    Hi,

    I have a table - TagDetail - that stores the many-to-many relationship between Tag, ParentTask,...

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

    February 21, 2017 at 3:10 pm

    #1929631

  • RE: Exists on where clause

    KGJ-Dev - Thursday, February 16, 2017 1:47 PM

    Hi,

    Sample data to play with

    Declare @vendor table(IdVenor int,MessageId int);
    Declare @vendor_customer table(IdVenorCustom int,MessageId int);
    Declare...

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

    February 21, 2017 at 2:55 pm

    #1929624

  • RE: Linking rows based on matching fields

    leehbi - Friday, February 17, 2017 9:19 AM

    I have a sub-set of customers :

    CREATE TABLE #temptable ( [ID] int, [Mobile] nvarchar(20),...

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

    February 21, 2017 at 2:26 pm

    #1929618

  • RE: How do I state my foreign key in my Create Table?

    karenworld - Sunday, February 19, 2017 1:26 AM

    Hi Expert,
    I tried to create a table with foreign key but I am not sure...

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

    February 21, 2017 at 1:55 pm

    #1929609

  • RE: Non-ANSI equal join - SQL 2012

    sjs-36273 - Tuesday, February 14, 2017 2:03 PM

    I recently found a non-ANSI select statement with equal joins executing against a SQL 2012...

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

    February 17, 2017 at 10:36 am

    #1929163

  • RE: Is not null 2 columns...

    ScottPletcher - Thursday, February 16, 2017 4:54 PM

    jcelko212 32090 - Wednesday, February 15, 2017 3:32 PM

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

    February 17, 2017 at 7:21 am

    #1929100

  • RE: Is having a lookup table that is for multiple entities a common practice?

    jcelko212 32090 - Wednesday, February 15, 2017 8:34 AM

    Doctor Who 2 - Wednesday, February 8, 2017 9:57 PM

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

    February 15, 2017 at 3:43 pm

    #1928740

Viewing 15 posts - 886 through 900 (of 911 total)