Forum Replies Created

Viewing 15 posts - 781 through 795 (of 911 total)

  • RE: Get the year and Qtr

    Papil - Friday, September 22, 2017 9:48 AM

    What you are working with our called intervals datatypes. Some other SQL products...

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

    September 27, 2017 at 1:51 pm

    #1961243

  • RE: Column Arrangement

    jcelko212 32090 - Thursday, September 21, 2017 12:58 PM

    TomThomson - Wednesday, September 20, 2017 9:02 PM

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

    September 21, 2017 at 12:59 pm

    #1960404

  • RE: Column Arrangement

    TomThomson - Wednesday, September 20, 2017 9:02 PM

    jcelko212 32090 - Wednesday, September 20, 2017 2:51 PM

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

    September 21, 2017 at 12:58 pm

    #1960403

  • RE: Return parents for children with certain condition

    Charlottecb - Wednesday, September 20, 2017 11:25 AM

    >> Ok, so here is my sample data I am testing against... <<

    No, what you...

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

    September 21, 2017 at 12:48 pm

    #1960402

  • RE: How to encrypt Credit Card numbers?

    BOR15K - Friday, September 8, 2017 10:17 AM

    We have now finally moved all our customers to SQL 2014 from old or very...

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

    September 21, 2017 at 11:36 am

    #1960396

  • RE: Assign group identifer to records with Cursor

    shogunSQL - Monday, September 18, 2017 11:56 AM

    >>I have a table called HelpDesk with two fields (row_id andsomething_name), I am...

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

    September 20, 2017 at 4:15 pm

    #1960287

  • RE: Column Arrangement

    Your DDL looks fundamentally wrong. First of all, by definition, tables must have PRIMARY KEYs; what you posted can never have a key of any kind because all the...

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

    September 20, 2017 at 2:51 pm

    #1960278

  • RE: EXCEPT in a trigger

    Chris Wooding - Monday, September 11, 2017 7:43 AM

    One other thing to be aware of is that EXCEPT eliminates duplicates.

    The ANSI/ISO Standard...

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

    September 13, 2017 at 4:22 pm

    #1959347

  • RE: Determine Monday of next month and Monday of next week

    Jeff Moden - Thursday, September 7, 2017 5:53 PM

    jcelko212 32090 - Thursday, September 7, 2017 2:11 PM

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

    September 8, 2017 at 2:23 pm

    #1958801

  • RE: Query Help

    vijay.singh 46672 - Thursday, September 7, 2017 1:53 AM

    >> I have data like below. <<

    Now we have to guess what the keys...

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

    September 8, 2017 at 12:14 pm

    #1958774

  • RE: Determine Monday of next month and Monday of next week

    Ed Wagner - Tuesday, September 5, 2017 2:16 PM

    Jeff Moden - Tuesday, September 5, 2017 1:41 PM

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

    September 7, 2017 at 2:11 pm

    #1958638

  • RE: Determine Monday of next month and Monday of next week

    Jeff Moden - Tuesday, September 5, 2017 1:41 PM

    jcelko212 32090 - Tuesday, September 5, 2017 12:00 PM

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

    September 7, 2017 at 1:40 pm

    #1958634

  • RE: Determine Monday of next month and Monday of next week

    jcobb 20350 - Wednesday, August 30, 2017 12:08 PM

    I am trying to determine the first Mondayof the...

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

    September 5, 2017 at 12:00 pm

    #1958158

  • RE: To automatically change the value of a column if a particular date time is reached

    poornima.s_pdi - Monday, September 4, 2017 3:39 AM

    >> I need to automatically change the value of job_status [sic] field [sic] to "2"...

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

    September 5, 2017 at 11:32 am

    #1958151

  • RE: Calculating averages

    SQLPain - Monday, August 28, 2017 5:27 PM

    Also never post pictures on SQL forum. This means in order to get this into...

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

    August 28, 2017 at 7:23 pm

    #1957175

Viewing 15 posts - 781 through 795 (of 911 total)