Viewing 4 posts - 1 through 4 (of 4 total)
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...
December 12, 2005 at 7:11 am
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] ?
December 12, 2005 at 7:01 am
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...
November 29, 2004 at 2:47 am
thanks... what if I'm using DTS ?
what should I write in format file to tell SQL, there is a column header ?
August 14, 2003 at 8:25 pm
Viewing 4 posts - 1 through 4 (of 4 total)