This is the existing DDL on the Service Table.

BIG NOTE: I did not design this table. Taking steps to rework this.

CREATE TABLE [dbo].[Service] (

[ServiceId] [bigint] IDENTITY (1, 1) NOT NULL...

Wow, thanks for all the replies.

Wanted to clear up a few things.

1) This numbering (SessionID) does not go into a Primary Key column.

2) No one sees it except for the...