Simple test proves it...

SELECT 1, CAST(1.23 AS DECIMAL(5,2))

SELECT 2, CAST(12.34 AS DECIMAL(5,2))

SELECT 3, CAST(123.45 AS DECIMAL(5,2))

SELECT 4, CAST(1234.56 AS DECIMAL(5,2))

Sure... but the methods are all worse than using profiler... why the profiler phobia?

Why?

Why? What's the problem?

Heh... c'mon now... {clutching sides in laughter... almost fell out of chair}, that developer is doing the best (s)he can...

Thanks for the Friday laugh...

Steve, you should start a...

This is why we always ask for a description of what you're trying to do... are you trying to generate 12 otherwise identical rows for each employee or ???

Matt Miller (8/1/2008)

---

As long as you're not hung up on performance, then cursors must be fine, since they help with readability...hmm no, not really, since they add more useless code...

MichaelC (8/1/2008)

---

Thanks Jeff! I'll play with these too. I think you also posted some suggestions when I was working with this function a while back, but we thought...

Jonathan Kehayias (8/1/2008)

---

Hmm, I have to go play with your code now Jeff. I am not surprised that you once again replaced a loop with a Tally/Numbers table....

michael.agarwal (8/1/2008)

---

Here is another puzzle:

There are 10 stacks of coins. Each stack contains 10 coins. All coins look same. All coins weigh 0.1 lb in 9 stacks but in one...

Ummm... nope... it isn't...

SELECT ISNUMERIC('11,22,33')

-----------

0

(1 row(s) affected)

I will agree, though, that...

One way is already demonstrated in the code I posted previously in this thread. Another way...

rbarryyoung (8/1/2008)

---

jcrawf02 (8/1/2008)

---

By the way, it's very big of you to contribute to the same thread as Jeff, when he's obviously anti-RBARry, but just can't spell your name . ....

Jonathan Kehayias (8/1/2008)

---

Jeff is looking to find out what you are trying to use CLR for. If it is just string splitting, unless you are using extremely long strings, that...

... and, heh... no "debug" is required on those... 😀