Forum Replies Created

Viewing 15 posts - 2,596 through 2,610 (of 2,894 total)

  • RE: Implicit conversion question

    Thanks Paul, I haven't read the article you posted about precision, scale and length rules. It makes sence now.

    Usually, I would explicitly convert the first required value(s) in...

  • RE: Function or procedure?

    jorgeclam12 (7/2/2010)


    i think for single value retrieval curser are better solution

    I guess you can do even better if you try harder:

    Create UDF which will call stored procedure which...

  • RE: String manipulation

    I have a suspicion, that the data in the table A are loading from some where. Id it is true, than the split should happen during the load other then...

  • RE: Implicit conversion question

    ...

    Select Cast(2 as decimal(18,6))/3) from Table :666666

    but

    the ResultsFromDecimal field after the UPDATE statement in my orginal post yields .666667

    ...

    If you will look closer, you will se that the result of...

  • RE: Calculate Working Hour Query

    Next time, please present your question in more helpfull way (you can find the link to how to do so in the bottom of my signature)!

    I have added some more...

  • RE: Implicit conversion question

    Paul White NZ (7/2/2010)


    ...

    A constant (like 1.0) will normally be typed as the smallest decimal that can contain its value (in this case, decimal(2,1)) - though there are some subtleties...

  • RE: SQL Table Insert rate?

    ColdCoffee (7/2/2010)


    ...

    I will be cheering for my India...20-20, we suck, but ODI and Test, india are teh team to beat! Beating them isnt as easy for Smith's gang as SQL...

  • RE: When this SQL error?

    Some times I don't understand why MS didn't make the CURSOR as undocumented feature 😀

    Or even better, to use a cursors they could make you to pay for a separate...

  • RE: SSIS error : Failed to lock variable "..." for read access ...

    Have you set Expression to the variable and EvaluateAsExpression to True?

  • RE: SQL Table Insert rate?

    Thank you Paul, I have no idea of how these rubbish tags end-up in the link I've posted. 😀

  • RE: Implicit conversion question

    In your case I would not try to choose the datatype based on the future operations which are going to be perfomed (it is usually a bad practice). For example:

    You...

  • RE: Rolling Moving Average (12 months)

    Please click the link in my signature to present your question in more helpfull way.

  • RE: using all in a parameter in a stored procedure

    Paul White NZ (7/2/2010)


    ...

    Interesting. Even though I am credited on that post with a couple of optimisations, it is not my routine of choice. It performs very well...

  • RE: WTF?? concatenating Date and time varchar fields messes up the milliseconds!!

    mberry 51447 (7/1/2010)


    Still doesnt help with Milliseconds.

    So basically I am SOL without 2008:(

    I am looking more into what my customer needs this for. Just comparing, that would be find...

  • RE: cannot get DISTINCT results from nested inner joins

    lionwelp (7/1/2010)


    ...

    Thanks for replying 🙂

    You're correct, the validation got the most recent Druk_nr and lowest number of Status (like isbn 3095561991134 got 2 rows, one with druk_nr= 1,status=3 and druk_nr=5,Status=2....

Viewing 15 posts - 2,596 through 2,610 (of 2,894 total)