• So finally From which version of SQL server, Identity property is copied into new table eventhough if the query has a GROUP BY clause.

    Then next question is it the intended behaviour of sql server or will it be changed in later versions?

    These questions might have answered in earlier discussions itself , but i missed in the crowd.

    --
    Dineshbabu
    Desire to learn new things..