Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 2,894 total)

  • RE: T-SQL Help Needed

    I can give you one other, very nice example for which you can try to come up with nice Natural Key: Order entity/table. Yes, just a simple and very...

    September 17, 2012 at 5:29 pm

    #1538853

  • RE: T-SQL Help Needed

    GSquared (9/17/2012)

    Eugene Elutin (9/17/2012)

    And you didn't respond to the basic assertion about e-mail, which is its horrible weakness as a primary key for human beings. I still maintain...

    September 17, 2012 at 3:58 pm

    #1538841

  • RE: T-SQL Help Needed

    ...

    I never worked for Amazon

    ...

    I don't think you have ever worked for any e-commerce company, otherwise you would know that none uses email as PK.

    And it is fine...

    September 17, 2012 at 11:15 am

    #1538739

  • RE: UniqueIdentifier as a Primary Key

    jeffem (9/17/2012)

    CELKO (9/14/2012)

    By definition it cannot be a key; it is not an attribute of any entity in the logical data model. A well-designed key should have validation rules (a...

    September 17, 2012 at 11:03 am

    #1538728

  • RE: Stored Procedure help

    askmewhat (9/17/2012)

    sorry last request... if Sunday were to be added on there? So both Saturday and Sunday.

    He is one for you, it can count any number of selected week days...

    September 17, 2012 at 10:55 am

    #1538724

  • RE: T-SQL Help Needed

    And you didn't respond to the basic assertion about e-mail, which is its horrible weakness as a primary key for human beings. I still maintain that using it...

    September 17, 2012 at 10:32 am

    #1538706

  • RE: Stored Procedure help

    a bit shorter version...

    DECLARE @year int

    SET @year = 2015

    SELECT

    MONTH(mfd) AS MonthNo

    ,DATENAME(MONTH,mfd)...

    September 17, 2012 at 9:08 am

    #1538664

  • RE: T-SQL Help Needed

    ...There were a significant number of vehicles there that predated the VIN standard. I see that show every month (I volunteer at a booth), so I'm more than...

    September 17, 2012 at 8:39 am

    #1538646

  • RE: Query for treeview

    Ok

    September 17, 2012 at 7:55 am

    #1538615

  • RE: simple que

    Jason-299789 (9/17/2012)

    Thanks Eugine, as I said I thought they were persisted even after the process that created them was closed,

    I was actually confused with creating a specific fixed table,Eg...

    September 17, 2012 at 6:32 am

    #1538556

  • RE: simple que

    Jason-299789 (9/17/2012)

    I thought the ## temp tables persisted until they were explicitly dropped from the TempDb, or the SQL service was restarted.

    Just try:

    1. Open query window 1 and type: ...

    September 17, 2012 at 5:23 am

    #1538525

  • RE: T-SQL Help Needed

    CELKO (9/14/2012)

    At the end, we are talking about Person entity, which can be used anywhere you are almost making yourself the laughing stock here.

    You might believe in Kabbalah...

    September 17, 2012 at 4:57 am

    #1538510

  • RE: simple que

    aaron.reese (9/14/2012)

    do you mean global ##temptables

    These persist between stored procedures until the session is ended or the connection is dropped.

    you can fill a ##temptable in one procedure and access the...

    September 17, 2012 at 3:41 am

    #1538468

  • RE: T-SQL Help Needed

    About DUNS...

    Having no DUNS means for you "doing business with criminal organizations"? Do you really think that local Fish-&-Chips or Pizza shop and local ice-cream man on a...

    September 14, 2012 at 7:28 pm

    #1538239

  • RE: T-SQL Help Needed

    CELKO (9/14/2012)

    One article from the New York Times on the differences in the DNA of twins.

    http://www.nytimes.com/2008/03/11/health/11real.html

    One of the Japanese companies is working on a single chip that does DNA...

    September 14, 2012 at 2:02 pm

    #1538140

Viewing 15 posts - 1,186 through 1,200 (of 2,894 total)