Forum Replies Created

Viewing 15 posts - 601 through 615 (of 911 total)

  • RE: How to set the primary key for each table

    >>Joe, that's particularly harsh--and utterly wrong. <<

    Harsh yes; wrong. No. Let's go back to basic relational principles and definitions.

    >> Identities (especially INTEGER identities) have a number...

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

    August 27, 2018 at 10:30 am

    #2003469

  • RE: Convert Varchar field

    PL/1 syntax was so irregular in it syntax they had to invent VDL (Viennese Definition Language) to replace the old BNF we’ve been using for languages. Parsing it required three...

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

    August 26, 2018 at 5:13 pm

    #2003375

  • RE: How to set the primary key for each table

    barry.nielson - Monday, July 30, 2018 10:29 PM

    Don’t worry, kid, we will knock all hope out of you 🙂

    >> So I've imported...

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

    August 26, 2018 at 4:06 pm

    #2003372

  • RE: EXCEPT

    VoldemarG - Friday, August 24, 2018 1:53 PM

    Do the fields [sic: columns] of both objects [sic: table expressions] and/or SELECT statements between...

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

    August 26, 2018 at 2:11 pm

    #2003366

  • RE: Prevent duplicates in a table

    andycadley - Friday, August 24, 2018 11:03 PM

    jcelko212 32090 - Friday, August 24, 2018 12:29 PM

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

    August 26, 2018 at 11:43 am

    #2003358

  • RE: i need to write stored proc following logic please help me the code.

    >> I need another help. Need to modify the Update statement to include combination two new fields [sic] instead of one field [sic] <<

    When you have a...

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

    August 26, 2018 at 9:42 am

    #2003347

  • RE: i need to write stored proc following logic please help me the code.

    saptek9 - Saturday, August 25, 2018 5:41 PM

    >> I need to write stored proc following logic please help me the code....

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

    August 26, 2018 at 9:39 am

    #2003346

  • RE: Best practice question on using a primary key field opposed to using a foreign key field

    >> Let's keep this simple (for my sake) and say we have two tables. <<

    You are keeping things too simple. This is why the past 30+ years, posting...

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

    August 24, 2018 at 4:16 pm

    #2003295

  • RE: Convert Varchar field

    Jeff Moden - Friday, August 24, 2018 12:03 PM

    Man, I loved PL/1.  It was way ahead of it's time.  If you...

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

    August 24, 2018 at 12:58 pm

    #2003271

  • RE: Prevent duplicates in a table

    drew.allen - Wednesday, August 22, 2018 8:49 AM

    jcelko212 32090 - Tuesday, August 21, 2018 6:01 PM

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

    August 24, 2018 at 12:29 pm

    #2003266

  • RE: Convert Varchar field

    bpmosullivan - Wednesday, August 22, 2018 7:35 PM

    I have a VARCHAR field [sic] with units in inches 🙁 that i need to...

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

    August 24, 2018 at 10:47 am

    #2003245

  • RE: Prevent duplicates in a table

    Lynn Pettis - Tuesday, August 21, 2018 11:06 AM

    jcelko212 32090 - Tuesday, August 21, 2018 11:00 AM

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

    August 21, 2018 at 6:01 pm

    #2002777

  • RE: Prevent duplicates in a table

    Senchi - Monday, August 20, 2018 8:53 AM

    I am entering 'salaries' information into a sql server table called 'salaries'.
    Fields are :
    id (pk,identity),c_id...

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

    August 21, 2018 at 11:00 am

    #2002720

  • RE: Join on next available non null value

    Y.B. - Tuesday, August 21, 2018 8:06 AM

    Any ideas?

    >>I have costs that I need to convert into a different currency based...

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

    August 21, 2018 at 10:33 am

    #2002714

  • RE: conditional update query syntax

    paulgq - Sunday, August 19, 2018 11:48 AM

    There are several problems with your approach, which are pretty fundamental. The first is that...

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

    August 20, 2018 at 12:15 pm

    #2002540

Viewing 15 posts - 601 through 615 (of 911 total)