We' re still testing it and most likely it will change.

Right now we have an issue with storing Parameter values for "Mutliple list".

Example:

CURRENCY:

USD

CAD

GBP

We need to be able to store all...

We use a main table for all subscribers, and another table for each report. So if someone gets more than 1 report, we only have to list them once.

And you...

Posting schema and sample data, along with expected results will help out a lot.

Sounds like you want Prior Day, MTD, and YTD.

Although you also have to be careful with MTD...

Offer up some free beer and see...

Compare yy, mm, dd of date_closed to getdate()

Wonder if the OP is even looking anymore?

Interesting to hear if they think their problem is solved.

Greg E

You are correct.

When I've done this, it's with a query that starts at the beggining of the year.

So I don't need to quallify with the year too.

Greg E

Something along these lines...

sum(case when DATEPART(yy,date_closed) = DATEPART(yy,getdate()) then 1 else 0 end) as 'YTD',

sum(case when DATEPART(mm,date_closed) = DATEPART(mm,getdate()) then 1 else 0 end) as 'MTD',

sum(case when DATEPART(dd,date_closed) =...

Isn't date_closed = calendardate in the join

like saying

1=1?

So the query is working perfectly.

And I think I saw a teaser to this effect.....

Greg...

in your join criteria...

ON CONVERT(VARCHAR(11),date_closed,120) = CONVERT(VARCHAR(11),[CalendarDate],120)

If you are joining on dates (date_closed to CalendarDate), they will always be the same.

So all your case staements are effectively =

DAY - wouldn't...

I agree with the others - until you find the root cause, and know why it's causing the problem, you cannot fix anything.

What you are doing is like getting a...

9/11 - a day that I too always take time for a moment of silence and prayers for all the innocent lives lost.

Something I will never forget.

Greg E

Jan Van der Eecken (9/9/2009)

---

GilaMonster (9/9/2009)

---

No I didn't. No one local was willing to bet that the pigeon...

Try changing to a completely different account (through the configuration manager), apply, and then change it back to the original credentials.

Greg E

Another factor can be other systems in the network may already have existing Service Level Agreements. It may not make sense to try and promise up time in the same...

GilaMonster (8/31/2009)

---

There's already duplicate users in the system. We've got at least one case where two people have the same username. Something has to be don e about those and...