Viewing 15 posts - 2,281 through 2,295 (of 2,452 total)
Steve Jones - Editor (8/26/2010)
Excellent job of writing and enjoyable to read. I am looking forward to the rest of the series.
I agree with Steve's comments....but when is the next...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 26, 2010 at 9:49 am
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 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 25, 2010 at 8:52 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 25, 2010 at 8:47 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 25, 2010 at 6:22 am
deleted: didnt read the OP question thoroughly !!
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 24, 2010 at 1:07 pm
"Tiddy Oggy" Land....:-D
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 24, 2010 at 12:16 pm
what volume of data are you talking about...
no of tables / rows ??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 18, 2010 at 8:51 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 17, 2010 at 2:08 pm
Novicejatt (8/13/2010)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 16, 2010 at 1:08 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 16, 2010 at 11:34 am
Many thanks for both responses.....noted the named instance requirememt.
will give it a go asap.
regards Graham
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 16, 2010 at 9:22 am
sabarichandru (8/16/2010)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 16, 2010 at 5:44 am
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 16, 2010 at 3:36 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 15, 2010 at 12:18 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2010 at 8:45 am
Viewing 15 posts - 2,281 through 2,295 (of 2,452 total)