Re: Improve Query

Arnold,

You are right, my apologies for not being clear. I wanted to know on how to
improve a query to monitor automation jobs. Below are 2 queries being used
at the moment:

/***this query shows last 10 runs of an application with the status***/
SELECT top 10 app.application_id, app.application_desc, req.
application_request_id, req.items_count, req.items_processed, req.start_time,
req.end_time, type.application_request_status_type_desc as 'Last Status'
FROM automation..application_request req
join automation..application_request_status_type type
ON type.application_request_status_type_id = req.
application_request_status_type_id
join automation..application app ON app.application_id = req.application_id
WHERE req.application_id = 2
ORDER BY req.application_request_id desc

-AND-

/***this query shows failed/successful transactions. It queries a count of
each application_request_detail_status_type_id for an
application_request_id***/
SELECT req.application_request_id, req.
application_request_detail_status_type_id, det.status_desc, count (req.
application_request_detail_status_type_id) as 'count'
FROM automation..application_request_detail req
join automation..application_request_detail_status_type det
ON det.application_request_detail_status_type_id = req.
application_request_detail_status_type_id
WHERE req.application_request_id = 4745
GROUP BY req.application_request_id, req.
application_request_detail_status_type_id, det.status_desc





Arnie Rowland wrote:
SELECT count(application_request_detail_status_type_id)
FROM MyTable

...Somehow, I think that you have a different question in mind, but it is
difficult to guess what it may have been.

Is it possible to create a query that returns a count of each
application_request_detail_status_type_id as columns?

Any help on this would be greatly appreciated, thanks :)

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-mseq/200611/1

.

Relevant Pages

  • Sum records from multiple queries
    ... Need your expert help on the following ... Req No ... i have managed to write a query which gives me the emp id wise record ... show the total of the candidate's status i.e, sum of owned,rejected and ...
    (comp.databases.ms-access)
  • Re: Showing Data thats not there!?!
    ... the query you already have for what is being used. ... Rm Req (RBID, TBID, Room ID, Hire Date, Start Time, End Time) ... TBID=Training Booking refernce number if used for training course ...
    (microsoft.public.access.queries)