Thanks for the feedback... the question now is do you really need the individual pieces?

Soooooo.... no pooping... no walking away... don'cha ever get constipated? 😛

Lynn Pettis (12/15/2008)

---

Jeff Moden (12/15/2008)

---

Just to be sure... you're a heck of a better man than me, Lynn... I looked at your posts and you were quite the gentleman in...

Not ever, it sounds like. Well done.

Just to be sure... you're a heck of a better man than me, Lynn... I looked at your posts and you were quite the gentleman in explaining the facts of...

Oh yeah... almost forgot... plan for it now... if you leave the long term archive as daily tables, you'll have a hell of a time doing a search for a...

Interesting idea... and, if you really do that, there is no reason for a purge process. Just create the new table on a daily basis and have a script...

Lynn Pettis (12/15/2008)

---

Well, call me a softy, but I gave him something to work with. Hope it takes the comments to heart and takes the time to provide us...

I thought this was a fun problem to solve and also gave the opportunity to demo both the power and readability of "Cascading CTE's".

Here's the function...

CREATE FUNCTION dbo.ConvertFractionToDecimal

/**********************************************************************************************************************

...

Damned nice try, Peter... thought you had it, but not quite...

SET STATISTICS TIME ON

SELECT '5' , dbo.fnResolveFractionals('5') ...

Heh... here's my twit for the week... gotta love the arrogance...

http://www.sqlservercentral.com/Forums/Topic619172-1291-1.aspx#619380

Heh... mmmmmm... p-o-r-k c-h-o-p-s... gaaaahhhh... 😛

rbarryyoung (12/15/2008)

---

One thing that I have started to do in the last two years that I have found to be very helpful is to include test commands in the comments...

You'll also find that it's absolutely necessary to keep from getting "false returns" in a GUI that may be interpretted as error messages, especially on triggers.

Save yourself some huge amounts of time in the future... learn to use Books Online, the "help system" for...