One more thing, in the database I have more note_types. I want to eliminate those records which has note_type_fk='29', but the resultset is displaying other note_type_fk's. Can someone please help...

I am still getting records which has event date or note_type_fk =29.

I added "ev.authorizations_fk is not null"

in the clause. For e.g. <B>cltyp.name= 'Clinical'

AND ((ev.event_date is null AND ev.authorizations_fk...

Here is the error message"Server: Msg 208, Level 16, State 1, Line 40

Invalid object name '##NumofEvents'."

when I run the stored procedure. And here is the stored procedure code:

select distinct p.people_id...

I've finally figured it out. Thanks for the help!

I re-ran the temp table and now I am getting 1 record back.

Thanks!

I am refering temp table from store procedure.

I got 0 records back when I ran the query

for sysobjects.

Below is the temp table I am creating:

CREATE PROCEDURE sp_temp_NumofEvents AS

Create table...

"Max" solved the merging issue.

I can get to Call type. The problem is, if I don't use count I get duplicate records; in One field I get call type and in another eventdate (I...