Hi Lynn,
thanks for your reply. i haven't changed my requirement. anyhow apologize for the miss communication here.
What i told was about the code provided by ssc and not you. the ssc code has hard coded date set up for further use.
SELECT @fromYear='1913-01-01', @toYear='1998-01-01'
thats what i meant to say.
thanks jeff and lynn for your time on this post.