General information
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only