Hi Sean.

Here is my table.

DECLARE @TempCOGGP TABLE

(conum varchar(10),

coline varchar(10),

itemnum varchar(35),

custnum varchar(10),

custseq int,

qtyorder decimal (10,8),

qtyready decimal (10,8),

qtyship decimal (10,8),

promise date,

ship date,

orderdate date,

coitemstat varchar(3),

allocate date,

pattern varchar(3),

room varchar(1),

Tag varchar(1)

)