Migration: Generate Pivotal ID in SQL 2005

Below is the sample code on how to generate Pivotal ID using the new ROW_NUMBER() feature in SQL 2005.

USE AdventureWorksLT
GO
DECLARE @Last_Id AS BINARY(8)

SELECT
    @Last_Id = Last_Id_Value
FROM CMS59_ED.dbo.RSys_Last_Id
WHERE Table_Name = 'Contact'

SELECT
    CAST(
    CONVERT(bigint, @Last_Id) + ROW_NUMBER()
    OVER(ORDER BY CustomerID)
    AS Binary(8)) AS Contact_Id,
    *
FROM SalesLT.Customer