sorry for everything what I've done wrong for posting my prob.. I finally have find a solution for my prob...

so thnx again for your efforts....

yes that's right.... and I didn't put a test data because as you can see from the image it would be inappropriate to insert such a large data on a...

ok i have this table...

create table InteractionSegment (

InteractionSegmentId PRIMARY KEY int NOT NULL,

SegmentType smallint NOT NULL,

DeviceId varchar(64) NOT NULL,

StartDateTime datetime NOT NULL,

EndDateTime datetime NULL,

AgentDeviceId varchar(64) NULL,

SplitSkillDeviceId varchar(64) NULL,

EnteredCodeData varchar(64) NULL,

InfoValue...

it's difficult to explain for me this problem because I'm not expert in this field..but I'll try.

we have one table with all values mentioned on the previous page..this table contain...

all the rest of columns..

hm...that would be a tricky part....

i want in some way if could be possible.. to show in single row e.g. for ID 135 the lowest start date and largest end...

SELECT TOP 1000 [InteractionSummaryId]

,[InteractionSegmentId]

,[SegmentType]

,[DeviceId]

,[StartDateTime]

...

ok sorry i'll post a entire prob...

I have this select which sort missed calls from table InteractionSegment...

SELECT

iseg.*

FROM

tblInteractionSegment iseg

WHERE iseg.InteractionSummaryId NOT in (SELECT InteractionSummaryId FROM tblInteractionSegment WHERE SegmentType in...

well this is just 3 column of my table... and what you post is correct...but i want all the other column to be shown with the adequate query..

can you help...