Select Single Record forf ollowing result set

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Select Single Record forf ollowing result set

Author

Topic

itnagaraj
Yak Posting Veteran

70 Posts

Posted - 2010-09-27 : 08:56:20

How to select single record if status like '%resol%' or '%change%'.Already i created a Query.Where i will modify it.The Query is

Select A.Number,A.Status,
Case When A.status like '%Change%' Then DATEADD(hh, 5, DATEADD(mi, 30, A.datestamp)) End As ResponseTime,
Case When A.status like '%resol%' Then DATEADD(hh, 5, DATEADD(mi, 30, A.datestamp)) End As ResolutionTime
From (
Select Number,Type Status,Datestamp From ActivityM1
Where Type in ('Resolved','Status Change','Open')
) A, PROBSUMMARYM1 B
Where A.Number = B.Number And A.Number='IM15596'

The record set is
Number Staus Response Time Resolution Time
IM15596 Resolved NULL 2010-09-22 18:04:45.000
IM15596 Resolved NULL 2010-09-22 17:23:02.000
IM15596 Resolved NULL 2010-09-22 17:22:19.000
IM15596 Status Change 2010-09-22 12:59:02.000 NULL
IM15596 Open NULL NULL

i want the following result
Number Response Time Resolution Time
IM15596 2010-09-22 12:59:02.000 2010-09-22 18:04:45.000

V.NAGARAJAN

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources