Thanks, I'll do that.

I appreciate that you guys are willing to go so far as to replicate the tables, data, etc. but that's way more than I could ask.

I was really looking for...

In the sample data I've left out some of the extraneous data.

Zones:

CREATE TABLE [cc].[Zones](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[Zone] [nvarchar](50) NULL,

[zDescription] [nvarchar](255) NULL,

[Inactive] [bit] NULL,

[TS] [timestamp] NULL,

[DateCreated] [datetime] NULL CONSTRAINT [DF_Zones_DateCreated]...

I was just thinking, I could insert all of the items into the table first since I already know how many times each should appear in the list.

Then either I...

Resolved.

The problem wasn't with the customer number field itself, but rather with a computed field in the same table that used the customer number field. It was casting it...