Forum Replies Created

Viewing 15 posts - 61 through 75 (of 217 total)

  • RE: Get percentages

    providerlink table

    PLid   PLworkRequestID   PLcurrentStatus   PLtat   PLunworkable

    PL203602   WR27904         90      39      73

    PL203605   WR30397         90      2      27

    PL204371   WR29892         11      38      76

    PL204374   WR29892         90      23      61

    PL205765   WR30018         90      72      27

    PL207872   WR29683         11      79      0

    PL207874   WR30775         11      12      0

    So I want to find the percentage of records that, where PLtat + PLunworkable is greater than 75. So for the sample data above, I can see that...

  • RE: Get percentages

    Now I get a "Line 6: Incorrect syntax near '>'."

    tried switching some things around, but can't get around this error

  • RE: Getting an average

    Oh ok...I see that part now...thank you!

  • RE: Getting an average

    What I don't understand about this query, is how is it getting the total # of workrequests? Because shouldn't it have to get the total, then get the total...

  • RE: Getting an average

    Why would you need 3 CAST statements?

  • RE: Getting an average

    wow...that is a lot. Would I put all of this into one query?

  • RE: table containing billing rates

    performing mathematical operations on anything with a NULL will result in a NULL? Correct?

    Thanks!

  • RE: table containing billing rates

    You mean CASE statements in the SQL or the ASP code?

    Thanks!

  • RE: table containing billing rates

    Here is my full formula(in ASP):

    result = objRs("CCflatRate")

    result = result + (pages * objRs("CC1setRate"))

    result = result - (MaxVal(0, pages - objRs("CC1setpageEnd") * (objRs("CC1setRate") - objRs("CC2setRate")

    result = result - (MaxVal(0, pages...

  • RE: Selecting max date

    Awesome! I *think* this is working!

    Thank you!

  • RE: Selecting max date

    yes, I have it written like this:

    SELECT COid, BIid, BRid, COofficeName, CMclientName, BRrate AS 'Client Rate',

    BIstandardRate AS 'Standard Rate', BIdescription

    FROM billrate, clientoffice, clientmaster, billitem

    WHERE 1=1

    AND BRclientOfficeId = COid

    AND BRbillItemID...

  • RE: Selecting max date

    Well, I think I just complicated things more.

    This query was supposed to be a subquery in a larger query. But now whenever I run it, I get a:

    Server: Msg...

  • RE: Selecting max date

    Hey thanks guys...

    I guess I don't need BRid in there. I just had it in there so I could visually see what it was. But the final program won't...

  • RE: Selecting max date

    I tried this, and unfortunately it still pulls any and all dates, not just the max date.

    thanks

  • RE: get a percentage

    Thanks everyone!

Viewing 15 posts - 61 through 75 (of 217 total)