html results for compute values
-
Hi All,
I am trying to create web asst job to show the results of my query which in the end follow the computed value also but the html is only showing me select results not the computed values.I check in QA and its give me the results but why the same scripts not showing the results in html.
Note (html showing only the compute values column names)
----*******----
select distinct
operator Name,
convert(varchar(8),starttime,11) Date,
sum(KeyStrokes) Keys,
sum(ActKeyStrokes) ActKeys,
sum(NumOfLines) Lines,
sum(ActNumofLines) ActLines
from
dataSummary
group by
operator,convert(varchar(8),starttime,11)
order by
operator,convert(varchar(8),starttime,11)
compute
avg(Sum(keystrokes)),
avg(sum(actkeystrokes)),
avg(cast(((cast(sum(actkeystrokes) as real))/(cast(sum(keystrokes) as real))*100) as int))
by
operator
-----*****-----
Any help will be highly appreciated
-
I am surprised that you get any result since there is an error in your query
COMPUTE clause #1, aggregate expression #3 is not in the select list
caused by avg(cast(((cast(sum(actkeystrokes) as real))/(cast(sum(keystrokes) as real))*100) as int))
(you can only compute columns in the select)
You do know, I presume that the use of COMPUTE will give you an additional recordset
Far away is close at hand in the images of elsewhere.
Anon. -
David - just as an FYI - this thread is posted all over the place...here's another thread to follow...
**ASCII stupid question, get a stupid ANSI !!!** -
Yeah David,
It give me another set of result but only in QA.When I try to creat a web job for this its showing only the results of my select clause not not compute one.........
And Sushila I posted it many places coz I have seen this as administration and T-SQL refrece.Any way thanks to mantion it
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply