Html computed value

• Zia Khan

  Old Hand

  Points: 341

  More actions

  April 3, 2006 at 3:56 am

  #168337

   

  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

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  April 3, 2006 at 6:49 am

  #630358

  follow thread here

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**