This was the only way I could get the correct number of rows to come in. It only takes about a second or so to run. If you...

I was able to get the information on one line by using this query.

select distinct lastname,firstname,room_desc,data2.campusboxnum,data3.room_phone,emailaddr

from (select distinct idnum,lastname,firstname,campusboxnum,emailaddr

from

(SELECT...

Yes, I tried that and he took away some of the information I needed. Thanks everyone for your suggestions.

ok, thanks for the reply.

This is the information I want to appear:

Ackley Brianna Lynn Knox 203B 46 9999999999

Thanks and here is the data as a txt file.

Thank you for your assistance.

Here is the data from the three tables. Please see attached.

data definition for stage_config

stage char(5)

stage_ord int

data definition for candidacy

id_num ...

The purpose of the function is to find the total number of prospects with a given stage on a given date and compare that to the previous year.

Please see the output results attached.

I did not see any index information. I will attached the data soon.

This is the query they run to get the information:

SELECT * FROM ccsc_admis_numbers(:Group, :Year, :Term, :Date)

This is...

At this time no one is complaining about the database being slow. I was trying to be proactive and see what could potentially cause us some problems. We...

I have just spoken with the person who created this function. He said that he runs this report at night. So, since he runs this report at night...

Thanks, it is working fine now.

ok. I will try it.

Thanks everyone for your responses.