I have a procedure that I'm trying to produce for a client. They want to see
total order counts each day from the 1st to the end of the month.

The procedure I have now will produce order counts for days that do exist. It
is using the order open date to pull orders from the orders table from
between a start and end date.

The client wants to see zero for the days that didn't have any activity.

For example:

Office          Day          Total
BranchA      1               50
BranchA      2                0
BranchA      3                10

How do I insert a blank record into my temp table that will show 0 for the
days that didn't pull?

Thanks so much in advance.

A general method is to create a dataset/table/view with all the days you
want to include and use an OUTER JOIN to get the results. If you want
specific query, please read www.aspfaq.com/5006 and post relevant
information to repro your problem.

Would putting an index on a SmallDateTime field increase performan
How to disable all the foreign keys in sqlserver 2000
sp vs. imbeded sql in vb, which is better?
Urgent! - time out errors while inserting into the dB
Help with tricky update statement