Thank you very much for you help and I understand. Sorry for my ignorance.

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)

)

/********** */

insert into @TempCOGGP

SELECT coitem.co_num,

coitem.co_line,

coitem.item,

coitem.cust_num,

coitem.cust_seq,

qty_ordered,

qty_ready,

qty_shipped,

promise_date,

coitem.ship_date,

co.order_date,

coitem.stat,

coitem.Uf_PJ_AllocatedDate as AvailableDate,

@Pattern as pattern,

@Room as room,

@tag

FROM coitem

inner join co on co.co_num = coitem.co_num

--inner join customer on customer.cust_num = coitem.cust_num and customer.cust_seq = coitem.cust_seq

Where (coitem.promise_date >= @StartInvoiceDate and coitem.promise_date <=

@EndInvoiceDate) and (substring (coitem.item,1,3) = @Pattern and

SUBSTRING (coitem.item, 6,1) = @Room)

ORDER BY coitem.co_num, coitem.co_line

select * from @TempCOGGP