actually your reply did help, thanks. I didn't think of creating a new temporary table in a stored procedure to organize the data. now how could i write...