Hello,

I have one SP which will be called per Record and It is having approx 50 different parameters

Out of 50 parameters some parameters are assigned value to local variable defined SP directly and Some are used in Select statement get other local variable value

Now inside main SP I have other SP which is called like below

Exec Sub_SP which will have approx 30 parameters and

-have some locally defined variable which are getting direct value from main sp
-some values We are getting using select statement using main SP parameter

Now in that SP i found
with
RECOMPILE


So does it really require ?

I read several blogs online about parameter sniffing and all.

But Can you provide me your thoughts that Do I really need Recompile in this kind of scenario ?

I am not supposed to allow SP on server else I can do test  so just want everyone input