Grab the actual command from the SQL Server Profiler and also please post your SP definition.
>My SP is named InTransit.
>
>Tried this, got same result as before, it shows all the records:
>
>
text to cmd textmerge noshow
>exec InTransit ?m.fdBlNo
>endtext
>
If it's not broken, fix it until it is.
My Blog 
