Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: Calculating percentage issue

    That did it! Thank you all very much!

  • RE: Calculating percentage issue

    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...

  • RE: Calculating percentage issue

    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)

    ...

  • RE: Calculating percentage issue

    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...

  • RE: Better Excel Insert procedure?

    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...

  • RE: Translating SQL 2005 script to SQL 2000

    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...

  • RE: Translating SQL 2005 script to SQL 2000

    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...

  • RE: Translating SQL 2005 script to SQL 2000

    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...

Viewing 8 posts - 1 through 8 (of 8 total)