HappyGeek (6/20/2016)

---

EdVassie (5/27/2016)

---

What is wrong with

UPDATE yourtable

SET Postcode = Replace(Postcode, ' ', ' ')

FROM yourtable

WHERE postcode...

Please, post DDL and sample data. To know how to do it, read the articles from my signature.

Alan.B (6/18/2016)

---

Con Alexis thank you sir. That's what I was looking for. Sorry for the late reply, yesterday was my birthday.

Luis. It's for an article I'm working on. I have...

Do you know what "at" was being used for in the first query?

Here's the formula applied for all values.

WITH CTE AS(

SELECT *,

p1 - s1 + s2 + CASE WHEN 6...

It's using the formula shown on BOL.

Considering example 1.00 / 7.1 we just get the formulas.

p = p1 - s1 + s2 + max(6, s1 + p2 + 1)

s =...

Lynn Pettis (6/17/2016)

---

Steve Jones - SSC Editor (6/17/2016)

---

Well, my navigations through the world of VSTS are complete, or at least, working.

As much as I like the system, finding information and...

Can you elaborate?

Using the sample data, I get the expected results you posted. Is...

Monster (I wonder who gets the reference)

Cross apply is the way to go. Check the following article which explains how to do it.http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

Here's an example. Be sure to understand it and ask questions that you might...

This page might help you understand what's happening. https://msdn.microsoft.com/en-us/library/ms190476.aspx

Especially the remark: "The result precision and scale have an absolute maximum of 38. When a result precision is greater than 38,...

That's exactly why this won't have an easy solution. Each system is different.

Consequence

Just curious on why you want to use CLR for this. I hope that you made that function just to make it easy to translate to procedural programming.

If anyone else...

Brandie Tarvin (6/17/2016)

---

I knew I was conflating Whole Numbers and Integers somewhat, so I went and looked it up. Then my mind got blown.

ZERO IS NOT A RATIONAL NUMBER!

Further proof...