I agree with Steve's comments....but when is the next...

I think this is somewhat what I need... only that I need the results to be grouped by DateCount.. so instead of

SELECT A.DateCount, A.Outlet, A.Brand, A.DailyTot, A.Runtot

FROM ...

I realise that you have probably only given us some sample data....but is there any chance that you have a unique row identifier in your real data?

the reason I ask...

Correct! Sorry for such a crappy presentation of the problem.. Am reading that "excellent article" ;).. I'm excited about the speed and the hacking spirit around it, but I'm...

deleted: didnt read the OP question thoroughly !!

"Tiddy Oggy" Land....:-D

what volume of data are you talking about...

no of tables / rows ??

Hi Ray

Not sure if the attached code is of any use to you, but may provide some ideas.

I run this on SS2K...mainly used to determine changes in an offline reporting...

Novicejatt (8/13/2010)

---

I want that this query should recogonise the dates from the table and not from the date range so that it only displays weeks that are present in the...

I would also add that you maybe keep a close eye on the "active threads" on this site.

Many a time I have found real world questions that are similar to...

Many thanks for both responses.....noted the named instance requirememt.

will give it a go asap.

regards Graham

sabarichandru (8/16/2010)

---

Hi Gah,

Thanks for your quick reply.

but i like to ask whether the WriteBack Feature will be support in Excel 2003 & 2007 .

because i created Cube in SSAS2008 and...

a quick Google and.....

Based on latest versions of SQL / Excel this article explains how

http://blogs.msdn.com/b/excel/archive/2009/10/12/excel-2010-pivottable-what-if-analysis.aspx

The following code is one way of providing what you asked for...however you may require more flexilibilty in which case you really need to post back.

I would also strongly suggest...

Hi Rod

Running Totals are certainly possible in SQL.

There is an excellent article at:

http://www.sqlservercentral.com/articles/T-SQL/68467/ by Jeff Moden

I would also strongly suggest that you read this:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are prepared to provide the...