Sorry if this ones a little obvious, I think I should really know the answer but can't work it out. I've written a query that pulls 2 rows from a table and I need to mutilpy the various columns on the top row by their corresponding number on the second row and then dump the result to a second table. But I can't work out how on earth I go about it, I've even tried sperating the rows into seperate queries but still can't work it out. Any pointers?
Oh and I saw aggregate rows was deprecated what are we supposed to use in its place?
Last edited by bugg_tb; 09-12-2007 at 05:09 AM.