Hi David,

I got your point,

so I just run T-SQL like this :

select [Date], ItemA as Item, QtyA as Qty

from

union

select [Date], ItemB as Item, QtyB as Qty

from

where...

Hi, Thanks,

yes the columns is fixed, 10 columns to be frankly, so the column are ItemA..J and QtyA..J

sorry, what do you mean -> Item.Qty be repeated for a [Date] ?

hi, got the same problem over here,

a suspect DB, already reset status, but when I ran DBCC CHECKDB, still got the error message.

is there a way out except recover DB...

thanks... what if I'm using DTS ?

what should I write in format file to tell SQL, there is a column header ?