I have a table that I am trying to generate a report for. In the table is a customer Id and a vendor Id. In the vendor ID I get two results for the same customer ID. A negative number before the order is processed and a postive number when the item has made full circle. I need to extract every matching customer ID with its corresponding negative and positive number:

right now if i do a search say on customer '10050' i get two vendor numbers on with a negative and one with a postive like this:

10050 -1000
10050 0

I really need it to be:

10050 -1000 0
10051 -1000 0

I need to return all records in a certain time frame not just '10050'

Do I need a temp table. An example would be nice - thank you!!!