• 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.