Well, fortunately I do have 2k5 so I'll take the time to create my proc using your solution and post the results. Besides, even if it doesn't work better it's...

Jeff,

FIRST, thank you for the reply!

SECOND, it's funny. Right when you posted this solution I came upon my own. I'm anxious to see which performs better. not that this is...

LOL, it's homework alright, but from work!

I'll just post my section of the procedure. I think that should be enough to show...

Peter,

I'm curious to your thoughts on my solution. My personal opinion is that it's easier to read/understand.

Jason

What about ...

SELECT

    '$0-$10'   = Sum(CASE WHEN orderAmount BETWEEN 0 AND 9.99 THEN 1 ELSE 0 END)

    ,'$10-$15' = Sum(CASE WHEN orderAmount BETWEEN 10 AND 14.99 THEN...

A yardstick is better. It doesn't completely incapacitate the user but still gives a nice sting.

I've found that carrying a yard stick and smacking them upside the head when they forget to be the best training tool around.

The GDIPlus.dll should be on all windows machines by default. It's not something you install or would have installed in the past.

I would suggest trying the solution I posted in...

The code above worked for me. ?

Set your parameter default to...

=DateTime.Today.AddMonths(-1)

and that should do it.

Michael,

GOOD QUESTION!!! It would be nice if you could perform an UNPIVOT on multiple columns at the same time. I don't think you can, but the code below seems to...

Just use this script and add the primary key through Enterprie manager...

                            CREATE TABLE [dbo].[Subscription_History](

                            [nDex] [int] IDENTITY(1,1) NOT NULL,

                            [SubscriptionID] [uniqueidentifier] NULL,

                            [ScheduleName] [nvarchar](260) COLLATE Latin1_General_CI_AS_KS_WS NULL,

                            [parameterSettings] [varchar](8000)...

If your talking about SQL 2005 then it's in SQL Management Studio.

I'm not completely clear on the question, but I think you need to be in Query Analyzer

A few questions…

1.       What field(s) constitutes a “duplicate”? You may also want to look up examples of IF EXISTS.

a.       If it’s a single field,...