Hi I have a stored procedure that when its executed it outputs Persons name, date created their id, location, description etc.... I have two parameters that the SP uses, @Ent which is Location and @date. What I am trying to achieve is have a job execute the stored procedure and make it use table valued parameters so that the SP is executed for all the @Ent variable. For example the stored procedure looks like this...
THANKS IN ADVANCE
asked Apr 10, 2013 at 06:28 PM in Default
Instead of trying to execute the query for each value, how about just running the query and then using the table variable to JOIN it to the data. That will work. But, performance might be junk because the table variables do not have statistics.
answered Apr 11, 2013 at 06:32 PM
Grant Fritchey ♦♦