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
5 months agoArleen
6 months agoCasie
6 months agoVirgina
6 months agoHubert
4 months agoGermaine
5 months agoTuyet
5 months agoDoretha
5 months agoTruman
6 months agoClaribel
5 months agoNydia
6 months agoEmmanuel
6 months agoIluminada
6 months agoWinfred
6 months agoArleen
5 months agoVirgie
6 months agoLetha
6 months agoNickie
6 months agoHelaine
6 months agoCelestina
6 months agoLisha
6 months ago