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

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

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

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

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

Why would you need 3 CAST statements?

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

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

Thanks!

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

Thanks!

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

Awesome! I *think* this is working!

Thank you!

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

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

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

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

thanks

Thanks everyone!