Viewing 15 posts - 2,596 through 2,610 (of 2,894 total)
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...
July 2, 2010 at 6:57 am
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...
July 2, 2010 at 6:50 am
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...
July 2, 2010 at 6:36 am
...
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...
July 2, 2010 at 5:47 am
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...
July 2, 2010 at 5:37 am
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...
July 2, 2010 at 3:31 am
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...
July 2, 2010 at 3:08 am
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...
July 2, 2010 at 2:58 am
Have you set Expression to the variable and EvaluateAsExpression to True?
July 2, 2010 at 2:05 am
Thank you Paul, I have no idea of how these rubbish tags end-up in the link I've posted. 😀
July 2, 2010 at 1:59 am
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...
July 2, 2010 at 1:56 am
Please click the link in my signature to present your question in more helpfull way.
July 2, 2010 at 1:27 am
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...
July 2, 2010 at 1:21 am
mberry 51447 (7/1/2010)
So basically I am SOL without 2008:(
I am looking more into what my customer needs this for. Just comparing, that would be find...
July 1, 2010 at 1:24 pm
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....
July 1, 2010 at 1:10 pm
Viewing 15 posts - 2,596 through 2,610 (of 2,894 total)