>I have a stored procedure with 10 params. How do I call it if I only need to pass the 8th and 9th parameters? Do I have to include placeholders for the first 7 in the EXEC statement?
Try to call it with the named parameters.
E.g.
execute mySP @myParam7 = 'myValue7', @myParam8 = 'myValue8'
If it's not broken, fix it until it is.
My Blog 
