• Even i am getting the answer as "-1, 0, 1".

    I have executed the query in SQL 2008 Enterprise edition.

    i am agreeing with others about the fact that

    to get ans as -1, -2, -3, the seed value should be -1.

    @Moderator :

    Look in this.