Drew that query was good, but after applying so many fields and partitioning on that basis made that query fail. e.g. in C1, if a that particular week (w1) and...

Thank You all. problem got solved. I removed the database name that i was using like "Use DDDD". Once i removed it, data was fetched in excel Thanks.

Tables which already exist in database i am using 3 name table convention but there are two tables which are created in database itself, where i can't use 3 name...

This is the sequence of errors when running the same query through excel pivot option

1)Changed database context to XXXXX

2) Problems obtaining data

3) A pivot table using connection 'YYYY' has failed...

When i am using this query its working fine in SSMS, but when i am creating excel pivot table to fetch SQL server data through this query then it gives...

I would like to display NULL.

This forum etiquette link is very helpful and will change my original post in this format only. Thank You so much.

i get the way you have posted the data.

is this the way to ask any query? I dont actually get the format in which it has been written

No, any start up article will be helpful.

Oh yes i forgot to mention that, once data is populated, indexes will be recreated. Do you think that will tune query to some extent?

These tables are just for reporting. jobs fetches data and reload these tables every time job is run. then queries are written to outer join different tables to fetch reports...

Thank you for your response

These tables (around 12/15) are used for reporting purpose. there are 3 jobs which fill these tables from another server and then there are queries written...

Thank you so much. this is actually i was thinking that it will always be needed to bring data either way to make that comparison happen. I have never worked...