It doesn't work with sysdatetime() or getdate(), but I don't need actual datetime. It is only testing query...
This works:
Set statistics io on
Execute Create_Tournament
'Juhász Beach Volleyball Tour 2012',
'Soběšovice',
'20100301',
'20100301',
'20100301',
'Muži',
100,
8,
0
-Pepin z Hane