How r u setting the parameter? Let me explain it.

For example if you need date for 3rd Sunday of March 2009 then use as follows

SELECT dbo.getDateAtNthOccurence('01/Mar/2009',1,3)

The...