Option D looks like a lot of work, setting up separate tasks just to run a series of SQL statements. I'd go with option C and let the stored procedure handle the heavy lifting.
Option D looks like a lot of work, setting up separate tasks just to run a series of SQL statements. I'd go with option C and let the stored procedure handle the heavy lifting.
I'm not sure about the other options, but option C seems the most straightforward. Encapsulating the SQL logic in a stored procedure and calling it from the task makes sense.
Option C looks like the way to go. Using a stored procedure to execute multiple SQL statements in a single task seems like the most efficient approach.
Matthew
6 months agoArleen
6 months agoCasie
6 months agoVirgina
6 months agoHubert
5 months agoGermaine
5 months agoTuyet
5 months agoDoretha
6 months agoTruman
7 months agoClaribel
6 months agoNydia
6 months agoEmmanuel
6 months agoIluminada
7 months agoWinfred
7 months agoArleen
6 months agoVirgie
6 months agoLetha
6 months agoNickie
7 months agoHelaine
7 months agoCelestina
6 months agoLisha
7 months ago