select top 30 	id,
		case
			when patindex('%<requestedSegmentRef><segmentRef>3%',MP_Request) > 0 THEN '3W'
			when patindex('%<requestedSegmentRef><segmentRef>2%',MP_Request) > 0 THEN 'RT'
			when patindex('%<requestedSegmentRef><segmentRef>1%',MP_Request) > 0 THEN 'OW'
		end
		username,
		datalength(tqe_response) as [length],
		subreccnt,
		datediff(ms,requestdate,tqe_response_ts)/1000 as [time] ,
		MP_Statistics,
		TQE_RESPONSE
from TQS_MP_RequestCounter
-- where id = 12075
order by id  desc

-- delete tqs_timaticInfo where TS > '09/01/2008'

-- select id, tqe_response from tqs_MP_requestCounter where id in (11629,11633,11636,11639,11640,11643,11644,11648,11649)