Excellent! Thanks for the help.

I wish that was possible, but the mdb is coming from an outside company that doesn't want to give us access to their servers (except for the small nightly window...

There isn't really a good reason to not show the client the identity, other than personal preference. A computed column should do well, though. Thanks.

I've convinced the powers-that-be that this isn't something worth exploring since the proc works fine as is. Thanks for all of your help.

That's what I was afraid of. I'll keep working on it, but I'm afraid that you might be right. If there is a way, it's beyond my abilities...

The report displays several records at a time, depending on how many are returned. The actual report is formatted like the following:

OrderNumber

Detail1

...

I'm using ActiveReports by DataDynamics for the front end, and for some reason it isn't breaking the multiple Actions apart within the Orders. I don't know if this is...

I thought that you couldn't use UNION if you were pulling different numbers of columns from the various tables. Is this the case? Could I simply pad the...

The definition of the table wasn't changing, so defining the table before the IF statement worked perfectly. I am testing this in the Query Analyzer, but I was also...

Is there an easier way to fill a table from different sources, depending on the value of a variable?

I got this to work using a simple CONVERT statement to retrieve the time portion of the datetime field.

CONVERT(VARCHAR(8), timefield, 108)

This seems to suit my purpose quite well, although there...

Would it really be faster to go through the entire table to calculate the sum of the column for the variable? I suppose that is what I'm doing with...

I wasn't sure if it was possible to do the math inline since it relies on a sum of one column to produce the value for another column. Was...

Excellent. That's just what I needed. Thanks for the help.

Hi Chris,

Adding an index to the table variable seemed to be faster than doing the same to the temp tables, but either way it did shave a fair amount of...