• Thanks everyone for positive feedback.

    As you can guess the question came from practical experience when developers were puzzled with "odd" behaviour of SQL Server.

    Had to build this sample script to make the matter clear.

    Then it appeared to me other might benefit from it too.

    _____________
    Code for TallyGenerator