It would be good to investigate how the tables are joined, are the indexes appropriate, is it fast when you call it from ssms? As mentioned by others taking the time to provide good information helps others to help you 🙂