Much closer, but now we're starting a day before the start date.

I'm not sure it's working...I'm getting different results with that than I am with my own clunky method...and when I specify a date range of '2011-03-01 00:00:00.000' to '2011-03-03 00:00:00.000',...

Can I still use the < function with two varchar values then? I'll give it a shot.

Okay, now it works GREAT on my test system...which...uses SQL Server 2008. But it doesn't work on SQL Server 2005, which is my prod environment. (I know I shouldn't have...

In a hurry? And you came up with that? I couldn't have done that if I had a month. Thanks!

One question though, where do I tell it what table to...

I'm getting a syntax error on that one inside the SUM() functions. THEN ELSE END...it says incorrect syntax near the keyword "ELSE"

I'm afraid I don't understand ColdCoffee's code. It's a little too advanced for me.

Okay. I have a solution now that is at least working, but it's really...well...clunky. It creates a table, loops the select statement to find the values, inserts them into that...

Okay. I am thoroughly confused. I'm trying to do what, in my mind, should be a very simple task, but it always seems to be the simplest tasks that are...

I'm not having any luck.

Maybe I should explain better what I'm trying to do...

I receive a start date and an end date from a user.

I need to select everything from...

Glad you got it figured out! That kinda stuff can happen to seasoned professionals, too. I'm a newbie at SQL, but I'm much more experience with C#, and I once...

Oh, I get it! You're literally pivoting the table, turning the rows into columns and the columns into rows. That is a neat trick! I think that might work for...

Here's where my inexperience comes in. What is a pivot?

You just said what I was starting to get at in my own head... 🙂 Maybe the creation of a new schema can't happen within the same block of code...

Are you creating the new schemas in the new database within the T-SQL script you wrote, or before you run the script?