Viewing 8 posts - 1 through 8 (of 8 total)
Unfortunately it's not enough believe it or not. In this case, a = 52 and b = 10496, so c's percentage will be 0.495%. I'm still only receiving "0" with...
March 9, 2011 at 7:54 am
I feel like I'm still doing something wrong as the decimal has yet to move. Am I placing the command in the proper area?
WITH diagnostic(numerator, denominator)
...
March 8, 2011 at 3:49 pm
That worked, thanks!
The one final question I have is that c is now coming up very small, even with the multiplication by 100. How may I go about extending the...
March 8, 2011 at 3:16 pm
Thanks Wayne! In this instance when I'm making the lists do I have to have a consistency that SQL column 2 points to Excel column 3 such that if someone...
April 15, 2010 at 1:25 pm
Got it!
I had to reference another script I had from another one of our programmers that I remembered working whether it was 2000 or 2005/2008:
First he simplified the creation/dropping of...
December 30, 2009 at 11:34 am
I apologize if this is a novice question, but are you saying if we look at the first line that where it reads:
IF EXISTS (SELECT * FROM sysobjects WHERE OBJECT_ID...
December 30, 2009 at 11:02 am
My apologies. The issue I'm experiencing is not knowing what field(s) I am possibly mis-translating by reworking this SQL 2005 script back to SQL 2000. The following error message is...
December 30, 2009 at 10:45 am
Viewing 8 posts - 1 through 8 (of 8 total)