Click here to Skip to main content
15,897,371 members
Home / Discussions / Database
   

Database

 
AnswerRe: delete two tables Pin
Harini N K29-May-07 22:06
Harini N K29-May-07 22:06 
Questionto get latest version of product Pin
chandru7029-May-07 17:22
chandru7029-May-07 17:22 
AnswerRe: to get latest version of product Pin
shally_7929-May-07 19:26
shally_7929-May-07 19:26 
GeneralRe: to get latest version of product Pin
chandru7029-May-07 19:39
chandru7029-May-07 19:39 
GeneralRe: to get latest version of product Pin
shally_7929-May-07 22:13
shally_7929-May-07 22:13 
GeneralRe: to get latest version of product Pin
chandru7030-May-07 1:19
chandru7030-May-07 1:19 
QuestionQuery AVG help Pin
Hulicat29-May-07 13:22
Hulicat29-May-07 13:22 
AnswerRe: Query AVG help Pin
Hulicat30-May-07 15:12
Hulicat30-May-07 15:12 
Got it...Thanks Srinivas!

select count(*) as 'Total closed for range', Priority_type_name
'Priority', location_name 'Cient', email 'Engineer' ,
AVG(datediff(d,report_date,last_status_update_time )) AS [Avaerage
time open]
from job_ticket j
inner join priority_type p on p.priority_type_id = j.priority_type_id
inner join tech t on t.client_id = j.assigned_tech_id
inner join location l on l.location_id = j.location_id
where (last_status_update_time between @startdate and @enddate) and
status_type_id ='3'
group by l.location_name, t.email, p.Priority_type_name

Regards,
Hulicat

QuestionSqlDataSourceEnumerator.GetDataSources Pin
Savas Cilve29-May-07 9:01
Savas Cilve29-May-07 9:01 
QuestionT-SQL Pin
Werries29-May-07 7:55
Werries29-May-07 7:55 
AnswerRe: T-SQL Pin
Mike Dimmick29-May-07 11:17
Mike Dimmick29-May-07 11:17 
GeneralRe: T-SQL Pin
Werries29-May-07 19:28
Werries29-May-07 19:28 
GeneralRe: T-SQL Pin
Colin Angus Mackay29-May-07 21:38
Colin Angus Mackay29-May-07 21:38 
QuestionPL/SQL Package Syntax Pin
Alaric_29-May-07 5:09
professionalAlaric_29-May-07 5:09 
AnswerRe: PL/SQL Package Syntax Pin
Al Ortega29-May-07 5:19
Al Ortega29-May-07 5:19 
GeneralRe: PL/SQL Package Syntax Pin
Alaric_29-May-07 5:38
professionalAlaric_29-May-07 5:38 
QuestionSQL Server 2000, Collation Pin
eggsovereasy29-May-07 5:08
eggsovereasy29-May-07 5:08 
Questionso I want to filter only input text. how it possible... Pin
Piyush Vardhan Singh28-May-07 23:33
Piyush Vardhan Singh28-May-07 23:33 
QuestionHow to export hsqldb into sql serverdb Pin
DON34528-May-07 20:44
DON34528-May-07 20:44 
AnswerRe: How to export hsqldb into sql serverdb Pin
Mike Dimmick29-May-07 11:32
Mike Dimmick29-May-07 11:32 
QuestionOracle 9i Master Detail Pagination Pin
K.P.Kannan28-May-07 19:43
K.P.Kannan28-May-07 19:43 
AnswerRe: Oracle 9i Master Detail Pagination Pin
Harini N K28-May-07 20:05
Harini N K28-May-07 20:05 
GeneralRe: Oracle 9i Master Detail Pagination Pin
K.P.Kannan28-May-07 20:13
K.P.Kannan28-May-07 20:13 
GeneralRe: Oracle 9i Master Detail Pagination Pin
K.P.Kannan29-May-07 0:54
K.P.Kannan29-May-07 0:54 
GeneralRe: Oracle 9i Master Detail Pagination Pin
Harini N K29-May-07 1:08
Harini N K29-May-07 1:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.