Viewing 15 posts - 46,561 through 46,575 (of 59,062 total)
Thanks for the feedback... the question now is do you really need the individual pieces?
December 15, 2008 at 9:42 pm
Soooooo.... no pooping... no walking away... don'cha ever get constipated? 😛
December 15, 2008 at 9:38 pm
Lynn Pettis (12/15/2008)
Jeff Moden (12/15/2008)
December 15, 2008 at 9:30 pm
Not ever, it sounds like. Well done.
December 15, 2008 at 9:22 pm
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...
December 15, 2008 at 9:19 pm
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...
December 15, 2008 at 9:11 pm
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...
December 15, 2008 at 9:09 pm
Lynn Pettis (12/15/2008)
December 15, 2008 at 9:05 pm
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
/**********************************************************************************************************************
...
December 15, 2008 at 8:54 pm
Damned nice try, Peter... thought you had it, but not quite...
SET STATISTICS TIME ON
SELECT '5' , dbo.fnResolveFractionals('5') ...
December 15, 2008 at 8:43 pm
Heh... here's my twit for the week... gotta love the arrogance...
http://www.sqlservercentral.com/Forums/Topic619172-1291-1.aspx#619380
December 15, 2008 at 6:37 pm
sognibene (12/15/2008)
Thanks, Jeff. I was wondering what I was going to have for dinner tonight.
Heh... mmmmmm... p-o-r-k c-h-o-p-s... gaaaahhhh... 😛
December 15, 2008 at 6:20 pm
rbarryyoung (12/15/2008)
December 15, 2008 at 6:16 pm
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.
December 15, 2008 at 2:34 pm
yousef.am (12/14/2008)
I need to know what the following statement does:set nocount on;
Save yourself some huge amounts of time in the future... learn to use Books Online, the "help system" for...
December 15, 2008 at 2:32 pm
Viewing 15 posts - 46,561 through 46,575 (of 59,062 total)