>Hi everybody,
>
>I've created a quite complex (parameter-wise) SP. I now want to be able to test it.
>
>In Query designer I created a long query that I can take my parametes from. But I'm not sure how can I create parameters out from this long and complex select.
>
>Any ideas for me how to create a test case?
>
>Thanks a lot in advance.

Right click on SP in SSMS Object Explorer. Then select Execute. It will ask you about parameters and will create a script and will run SP with parameters you passed.