i am looking at the individual queries now. a couple of questions though.

how do i declare the table variable?

can i create an identity column on the table variable?

do i need to create an index on the table variable before i join its results with results from another table?

also, do you see any optimization i could do for my queries? example: is there a way to calculate monthly sales and yearly sales per customer in one data pass?

thanks for the help. I appreciate it.