Hi,

Thanks for your response

My expected output

FlightName[No.OfSegments]DeparturePlaceDepartureDateArrivalPlaceArrivalDate

KL1233aaaa2011-03-30 02:15:00.000bbbb2011-03-30 05:15:00.000

KL1262dddd2011-03-30 03:15:00.000cccc2011-03-30 05:00:00.000

KL1281aaaa2011-03-30 01:15:00.000dddd2011-03-30 03:45:00.000

your query output:

FlightNameNumberOFsegmetsDepartPlaceArrivalPlaceDepartDateArrivalDate

KL1233aaaadddd2011-03-30 02:15:00.0002011-03-30 04:30:00.000

KL1262ddddbbbb2011-03-30 03:15:00.0002011-03-30 04:30:00.000

KL1281aaaaaaaa2011-03-30 01:15:00.0002011-03-30 01:15:00.000

Here

ArrivalPlace and ArrivalDate not matching with my expected output

Thank you WayneS

you are article is helpful for me

Good Information

Thank you

Even though I am getting following error.

===================================

Cannot connect to admin:ranjith\SQLCLIENT2008.

===================================

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was...

Thank u

Hi,

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Go

Waitfor TIME '14:16:00'

begin

SELECT * FROM employeeee WHERE EmpID ='mp3661' ----120000

end

In the above scenario what is the scope of READ UNCOMMITTED ISOLATION LEVEL?

...

Thanks now it isworking

I tried with the following query...But

select ename,sal AS maxsal,deptid

from employees

where sal in(select max(sala)

...