Forum Replies Created

Viewing 15 posts - 3,421 through 3,435 (of 26,490 total)

  • RE: Are the posted questions getting worse?

    Sean Lange (9/9/2016)


    The Dixie Flatline (9/9/2016)


    I have been making bacon like that for years...never knew it had a name. Another great way is to put a liberal amount...

  • RE: Are the posted questions getting worse?

    ThomasRushton (9/9/2016)


    Grant Fritchey (9/9/2016)


    GilaMonster (9/9/2016)


    Grant Fritchey (9/9/2016)


    BrainDonor (9/9/2016)


    I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch" type of...

  • RE: SQL Server to display output to HTML box in screen?

    chef423 (9/7/2016)


    I want to display an HTML [popup] box that displays the Grand Total of a Ticket in a POS.

    The SQL Script is very basic.

    select Grand_Total from Invoice_Totals

    where Payment_Method =...

  • RE: REPLACE or alternative?

    elzool (9/7/2016)


    Morning!

    An attribute comes back with five answers.

    NULL

    P=Permanent

    T=Temporary

    B=Both

    8=See Job Description

    Using the line below I receive a value of PermanenTemporary as the t at the end of Permanent is being replace...

  • RE: Convert int date(YYMMDD) to datetime

    moymike (2/4/2016)


    I'm assuming a better option has come available since this was posted, but here is another. It works for dates like 2000-01-01, which in YYMMDD would look like...

  • RE: Are the posted questions getting worse?

    Sean Lange (9/6/2016)


    Lynn Pettis (9/6/2016)


    Sean Lange (9/6/2016)


    Luis Cazares (9/6/2016)


    Sean Lange (9/6/2016)


    I tried my hand at curing my own bacon for the first time. It came out of the cure Saturday...

  • RE: TRY_CAST AND TRY_CONVERT not recognized

    Sean Grebey (9/6/2016)


    Trying to use these function which everything I read says 2012 forward inn SSMS 2014 and both of them toss me errors that they are not recognized functions?

    "Msg...

  • RE: Are the posted questions getting worse?

    Michael L John (9/6/2016)


    Ed Wagner (9/6/2016)


    Lynn Pettis (9/6/2016)


    Sean Lange (9/6/2016)


    Luis Cazares (9/6/2016)


    Sean Lange (9/6/2016)


    I tried my hand at curing my own bacon for the first time. It came out of...

  • RE: Are the posted questions getting worse?

    Sean Lange (9/6/2016)


    Luis Cazares (9/6/2016)


    Sean Lange (9/6/2016)


    I tried my hand at curing my own bacon for the first time. It came out of the cure Saturday morning and hit the...

  • RE: Indexing - Should primary key be a natural key or an identity?

    RonKyle (9/6/2016)


    Except that MS SQL Server adds a uniqueifier to the index of a clustered index if the index is not unique.

    This can't be a showstopper, can it? ...

  • RE: Indexing - Should primary key be a natural key or an identity?

    Sergiy (9/3/2016)


    Eirikur Eiriksson (9/3/2016)


    if no unique natural key is present then it is appropriate to use an identity for the clustered index.

    Those are completely non-related things.

    Clustered index does not...

  • RE: Are the posted questions getting worse?

    TomThomson (9/2/2016)


    Lynn Pettis (9/1/2016)


    djj (9/1/2016)


    Sean Lange (9/1/2016)


    Lynn Pettis (9/1/2016)


    And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?

    Odd...I...

  • RE: Avoiding Stored Procedures

    xsevensinzx (9/1/2016)


    David.Poole (9/1/2016)


    My definition of good enough would be significantly lower if the"we promise to fix this if it causes problems" was a firm commitment rather than an outright lie.

    There's...

  • RE: Is it a bad idea to declare a cursor within a TRY block?

    ScottPletcher (9/1/2016)


    Luis Cazares (9/1/2016)


    drew.allen (9/1/2016)


    First, the mantra is "It's a bad idea to declare a cursor. Period. End of sentence." 😀

    Drew

    Second, cursors can be local or global and the default...

  • RE: Temporary Functions?

    ScottPletcher (9/1/2016)


    CELKO (9/1/2016)


    ]I've found myself creating loads of functions recently which are typically used for one specific task and rarely required again.

    This is not how we intended SQL to...

Viewing 15 posts - 3,421 through 3,435 (of 26,490 total)