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.
Randy Belcher
AFG Industries, Inc.