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...

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

Create UDF which will call stored procedure which...

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...

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

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...

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...

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...

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...

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

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

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...

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

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...

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...

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....