Information générale
Forum:
Microsoft SQL Server
I agree that i would be easier to build the the app but it was just to slow. By using a procedure I cut the execution time from 4-5 minutes to apx 20 seconds. The stored procedure I created runs fine but it needs some flexibility. One thing it needs to be able to do is to change from an inner to a left outer join if a paramteter is passed or add a piece to the where clause if necessary. What I want to avoid is haveing multiple procedures called from one button (that only gets a cursor for a report).
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement