Feed News

Hi folks,

I hit a ask which is backward records same beneath which returns a itemize of tasks with a same duty type. there is a duty plateau (wh_task) and a duty identify plateau (wh_task_type). What i poverty to attain is a calculate of every the tickets per listing type.

So at the modify of the ask i module hit a amount for Administration / Maintenance tasks (1) and a amount for Routine Maintenance Tasks (3). ** and every the another types *

There are some assorted types of duty identify so I dont poverty to hit to hornlike cipher it. Can anyone gratify support me calculate every the occurencies of the assorted listing types.

Task Name	Task Type	Date Completed
SBS Server C intend streaming discover of space	Administration / Maintenance	16/07/2007 16:03:34
Patching Server(s).	Routine Maintenance	08/01/2009 06:51:56
Patching Server(s).	Routine Maintenance	11/02/2009 10:06:06
Patching Server(s).	Routine Maintenance	04/05/2009 06:53:24

I crapper also intend wh_task_type_id.

Here is my SQL:

SELECT wh_account.account_name, wh_task.task_name, wh_issue_type.issue_type_name, wh_issue_type.issue_type_id, wh_task.date_completed FROM (wh_account INNER JOIN wh_task ON wh_account.account_id = wh_task.account_id) INNER JOIN wh_issue_type ON wh_task.issue_type_id = wh_issue_type.issue_type_id WHERE(((wh_account.account_id) =" + drpClient.SelectedItem.Value + ")) AND date_completed IS NOT NULL

Thanks,

Billy

Read the rest here: 
Please Login or Register to see the link.

Related posts:

1. THE REAL MCTS SQL SERVER 2008 EXAM 70-432 PREP KIT: DATABASE IMPLEMENTATION AND MAINTENANCE Syngress Publishing | ISBN: 1597494208 | 2009 | PDF | 696 pages | 11.86 MB SQL Server 2008 is...
2. PARAMETERIZED QUERY PROBLEM I have routine in a vb class which queries an SQLServer(2008) database depending on the values passed to it....
3. ADVANCED QUERY, NEED ASSISTANCE. ...
4. TRIGGER EVENTS ON A WEB PAGE FROM A SERVER Hi, I was wondering if it is possible to have a server trigger JavaScript events on a web page in...
5. CONDITION QUERY Hi, how do you create a condition in a stored procedure for this scenario? I have checkboxes for a...
6. CALL OF DUTY 2 – AMERICAN RUSH 2 The sequel to the award-winning Call of Duty™, Call of Duty 2 is powered by a proprietary new engine...
7. NEED HELP TO CONVERT AN SQL QUERY INTO A LINQ TO SQL QUERY My ASP.NET 3.5 website makes use of an SQL Server database and I want to find all records in...
8. CALL OF DUTY: UNITED OFFENSIVE V1 5 [COMPLETE] Call of Duty: United Offensive v1 5 [complete] | Games | PC | ISO | 2.83 GB Call of...
9. SLUGGISH SITE, HOPING TO VIEW QUERY LOG? I'm working on a site which is a bit sluggish. We think it's the db so we're hoping to...
10. ASSIGNMENT TASK TO PROGRAMMERS This may be basic but how do we ( as Team Lead ) assign tasks to programmer? What are...

Tags: a-link-button, code, patching-server, server

This entry was posted on Monday, February 1st, 2010 at 11:22 am and is filed under Tutorials. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.