Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Another Pivot Table

    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...

  • RE: Another Pivot Table

    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] ?

  • RE: Error 605 database suspect

    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...

  • RE: import data using DTS bulk insert or BCP

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

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

Viewing 4 posts - 1 through 4 (of 4 total)