>>>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
>
>That's it. Thanks!
:) No problem. Sergey beat me by 10 seconds.
If it's not broken, fix it until it is.
My Blog