How big is the numerator?  Do you want the quotient with or without decimal places?  If so, how many do you want or are you willing to put up with...

Thank you for the feedback...

Thought I'd take a bit more time to show what you can do with a template (this also correct's a minor logic error in the WHERE clause of the...

You bet, Ed.  Thank you for the feedback.

Aye.  Thank you for the tips... there have been several discussions over temp tables and table variables and most have involved some form of blood-letting

Thanks Brian... looking forward to it.  Enjoying my weekend, too!  Slept the whole day!  First time in more than a year! 

Shoot... here we go... this is a perfect example of what I've spoken of in the past... You had to write a little VB...

Using ISNUMERIC to determine if something is all numeric digits is a form of "Death by SQL"...

IF IsNumeric(RIGHT(RTRIM('ABCDEF$-1,'), 4)) = 1

print 'yay'

else

print 'boo'

IF IsNumeric(RIGHT(RTRIM('ABCDEF0D01'), 4)) = 1

print 'yay'

else

print 'boo'

IF IsNumeric(RIGHT(RTRIM('ABCDEF23E2'),...

Although I agree that doing an ORDER BY in a view is a bit crazy, I'd have to disagree with the author of the blog because I tried the methods...

Sorry for my obvious post, Jason... I pulled to reply to Mick's post and got distracted... in that time, you answered and I didn't see it.

True but you have to be careful not to allow things so large that you have the potential for trying to store more than 8060 bytes (or less) in a...

Which one worked?  The merge or the reregister?

You cannot say SELECT @somevariable = * and get away with it...

While OPENROWSET is fine, it exposes passwords and logins... it would be far better to create a Linked Server.

I don't know if DTS has a way to modify that output but, if it can, replace the 1234567 in the following code with whatever DTS uses...

SELECT CONVERT(CHAR(8),DATEADD(ms,1234567,0),108)

Converts 1234567 milliseconds...

>>[Subquery returned more than 1 value] error

That usually has more to do with what you're doing in the code... you should post it so we can take a look for...