Viewing 15 posts - 61 through 75 (of 217 total)
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...
May 16, 2007 at 1:12 pm
Now I get a "Line 6: Incorrect syntax near '>'."
tried switching some things around, but can't get around this error
May 16, 2007 at 12:32 pm
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...
May 14, 2007 at 2:11 pm
wow...that is a lot. Would I put all of this into one query?
May 14, 2007 at 12:13 pm
performing mathematical operations on anything with a NULL will result in a NULL? Correct?
Thanks!
April 5, 2007 at 12:13 pm
You mean CASE statements in the SQL or the ASP code?
Thanks!
April 5, 2007 at 7:12 am
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...
April 4, 2007 at 1:20 pm
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...
March 14, 2007 at 2:03 pm
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...
March 14, 2007 at 1:45 pm
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...
March 14, 2007 at 1:42 pm
I tried this, and unfortunately it still pulls any and all dates, not just the max date.
thanks
March 14, 2007 at 12:52 pm
Viewing 15 posts - 61 through 75 (of 217 total)