Click on Control Panel. Scroll down to options, click on Forum Settings. Scroll down and you will find where you can change the number of posts per page....

That...

Now, if you really want help, we need the DDL for the underlying tables and sample data as well. You should be able to follow the instruction in the...

Three and four part naming conventions have been depreciated in SELECT lists. You really need to start using table aliases and two part naming conventions like this:

create view dbo.AB_CUST_ORDER_ACK...

Greg Edwards-268690 (10/1/2009)

---

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...

DDL is Data Definition Language, and what it means is the CREATE TABLE statements used to create your tables.

Please read the article I recommended. It will help you get...

If you are positive that the underlying tables are updated, then there could be a problem with the view. The problem, however, is that we can't see what you...

Greg Edwards-268690 (9/30/2009)

---

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...

I have another question regarding CalendarDate and closed date, which table or view do they come from in the query. Neither of these columns have a table alias attached.

Having looked at your original code and seeing the CalendarDate always ends in 00:00:00.000 (ie 2009-09-30 00:00:00.000) and closed_date ends with a time (ie 2009-09-30 13:03:01.333), the following is how...

Yes, i saw Gail also and dropped her a PM. She is still really busy.

The force is lacking in this one, yes.

You can obfusicate your table and column names making it more generic such that you can show what you did to solve your problem.

People do it all the time when...

Proper forum etiquette would have you show your solution. There may be others with similar problems and your solution may be helpful.

GilaMonster (9/29/2009)

---

Much more and your sig will be larger...