• If this happens, put a ID int identity column and set composite key on job_id and ID.

    then you can go for Clus. Index

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)