Information générale
Forum:
Microsoft SQL Server
Thanks for the tip.
I have another question for the same problem.
Let's say, I have to create a process that will repeat itself for every client. Example: My query transforms its contents with bcp and it sends an e-mail to the client with xp_sendmail. I shouldn't have any problem with that part but how can I make those procedures loop for every client in my database.
Why not put them all together? like: ...where client in(...) It's because I can't send the whole file with all the infos from every client to each client.
Thanks for your help!
-Michael
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