And another question...if the following job steps run successfully (which are doing more inserts), wouldn't the growth or tempdb be problems there, too?

How do I check to see if it's waiting on growth?

Thanks for the feedback; however, changing the names is not an option. While I would love to be able to do that, and had never actually seen a setup where...

I was hoping for a way to do this in the report rather than in an already-lengthy stored procedure. Is there a way?

Hmm...so I guess then you can't just change the collation in the SELECT, as I tried to do. Initially we figured it was collation, but using the COLLATE keyword didn't...

It does, thank you very much.

Does anyone know what is causing this? Is it a setting somewhere.

We sell products that are registered trademarks, so we have to display that when we display the item.

You rock...it gives me the logo!!! Thanks!

Awesome, that worked. Thank you!

It's really not a big deal. I wanted the column names in a specific order because I am anal-retentive. The table is a large table with lots of columns. It's...

Thanks. I can't use the GUI because there is too much data and it times out. I do have the script for the table; however, I cannot drop and recreate...

Thank you. It never occurred to me to only union in the blank value and allow the multi-value parameter to do its thing with 'Select All.'

I was able to union...

I had not seen this link, but it seems it's explaining exactly what I need to do. Oh joy! It seems every report I touch becomes quite the learning experience!...

I can try to play with the InScope function to see if it helps me out in any way; however, I'm not sure what you did is what I need...

Duh. Seems so obvious! Thanks!! I probably tried every variation of everything except that one!