Two things.1. Santosh, Why are you trying to do this to your table? What is the purpose? If it is a report then handle it in the reporting tool.2. Jason, the query you provided returns the exact same table minus one row. OR's are tricky. In this case, in all but one row, at least one field in the table satisfies the condition value <> 0 and therefore evaluates to "true" for the entire row to be returned.set nocount onselect * into dbo.myTablefrom (select14 'iss_quantity' ,0 'received_qty', 0 'moved_qty' ,0 'alloc_qty'union all select0 , 0 , 0 , 0union all select0 , 0 , 13.7 , 0union all select0 , 0 , 0 , 13union all select14 , 0 , 0 , 0union all select14 , 0 , 0 , 0union all select0 , 40.9 , 0 , 0union all select14 , 0 , 0 , 0union all select0 , 0 , 13.8 , 0union all select0 , 27.6 , 0 , 0union all select0 , 0 , 13.8 , 0union all select0 , 0 , 13.7 , 0union all select0 , 0 , 13.8 , 0union all select0 , 41.4 , 0 , 0union all select0 , 0 , 13.9 , 0union all select0 , 0 , 0 , 13union all select14 , 0 , 0 , 0) xgoSELECT iss_quantity,received_qty,moved_qty,alloc_qty FROM MyTableWHERE iss_quantity <> 0 OR received_qty <> 0 OR moved_qty <> 0 OR alloc_qty <> 0godrop table dbo.mytableset nocount off