If you get the time check this Stairway to MDX[/url]. This series for MDX starts right at the very beginning and takes us through all the basic functions of MDX,...

Following is the problem. you are ordering the project after that you are cross joining the Dealer dimension.

NON EMPTY { ...

once you implement Chris query (suggested above) you will be able to get the complete set of date only. in which each date will show you the same information.

i...

ahhh reminded me of migration from 2000 to 2005. All old school queries were needed to fixed at that point of time.

Thanks for the reminding Steve.

you need to have your routine well defined in a table 1st. after that you need to lookup from that table between your source and destination to identify what would...

Is there is any limit between two dates? as far as i know cross tab get very slow on reports if the columns list get higher.

you can also check this...

As all above me highlighted so i would leave it as is it.

beside that excellent question. Thanks for sharing Steve.

nice question. Thanks for sharing Tom

thanks for the question steve. brought some old memories back. 🙂

good question. Thanks for sharing.

Another possible scenario.

1. What if a Customer have only one Sale then two dummy rows should be shown or Single because if single your always 3 rows rules violates here....

Quick questions

1. What is the frequency of insert in this table.

2. Is there any bulk insert operation on this table.

3. What happens in case of any delete operation is...

compdude (11/10/2015)

---

So far I have tried isnull for each of the columns but this has not changed the nulls from the pivot data. I believe the isnull needs to take...

Great question Hugo. Thanks for sharing

you can get weeks between two dates. but what i didn't understand is the statement below

Now between this two dates, i want to calculate number of weeks on another date...