Thank you!!

Yes, I am trying to join the output of the function (where the output of function is independent of the data in the joining table) with table?

example

I have...

Thank you

Thank you so much..this would help!!!

Thank you!!!

Hi..do you know how do delete duplicate posts??

Thanks I deleted from Child table in Storedprocedure and then data from parent table.

I am getting start and endtime needed only username:

Select min(event_time)as End_time,A.Entry_Id as Entry_id,a.start_time

from dbo.activity B

Right join

(

select Acivity_id,entry_id,min(Event_Time) as start_time from dbo.activity doc

where doc.Eventy_type_id =6

and Event_Value like...

Yes,I am trying to find the first eventType of 3 AFTER the each( 6 , 1 ) pair in the table.

So,for example of occurance

Of eventype_id 6 , then...

@Lynn Pettis : I dont know whats your problem.Please try to take things positive.I am trying to make Sean Lange : understand my issue.You need not point...

select '10704' as entry_id , '2012-05-18 14:17:20.710' as Start_time ,'2012-05-18 14:18:13.957' as End_time ,'test3' as USername

Union all

select '10704' as entry_id , '2012-05-18 14:24:45.057' as Start_time ,'2012-05-18 14:25:14.780' as End_time ,'NULL'...

This should be my expected result of my smaple data provided in (insert)

entry_id Start_time End_time ...

I am trying to get the Start_time and end_time for an entry_id when the eventy_type_id changes from 6 to 1.I am getting start_time (event_time) when it has eventy_type_id=6 and end_time(event_time)...

The Start_time will be the each time when eventy_type_id =6 and event_value=pending

and end_time will be the each time when event_type_id changes from 6 to 1.

ans user_name will be the...

Thank you its working