Viewing 15 posts - 1 through 15 (of 38 total)
I renamed and removed some columns. This should now be 100% clearer. There is no problem with the data as I stated in the first post.
So question is how...
February 10, 2011 at 3:01 am
Pavel Pawlowski (12/17/2009)
TheHTMLDJ (12/17/2009)
I got an error:Server: Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'over'.
On what version of SQL Server you are running the...
December 17, 2009 at 5:20 pm
I got an error:
Server: Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'over'.
Also do I need a MAX DECODE or just MAX if I change...
December 17, 2009 at 8:24 am
This might be a beginning to create the date table you requested:
Yes that works. Should this be implemented as a View or a table? I will try and post...
December 4, 2009 at 8:03 am
Those are helpful. Perhaps someone has script for deriving periods and weeks within those periods.
bitbucket-25253 (12/3/2009)
Might I suggest reading this SSC article by Lynn Pettishttps://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx
December 3, 2009 at 12:27 pm
WOW!!! This is my exactly my point. Another post where there was no answer but a lecture.
Don't go back and edit your previous posts since we cannot keep on...
November 22, 2009 at 6:11 pm
A spreadsheet is attached of the data with companyname and districtname column.
It does appear there is duplicate data for some stores on some dates. Assume this is by design....
November 22, 2009 at 2:05 pm
I checked out your website. Do you have any plans for video tutorials about complex topics such as Analytics? I have not been able to find these anywhere and I...
November 22, 2009 at 1:37 pm
lmu92 (11/22/2009)
Example:
companynamedistrictnamestorenbrbusinessdateMatureMathAudioBooks
OnlineDotComHuntsville00052009-09-07 00:00:00.00017521752360
OnlineDotComHuntsville00052009-09-07 00:00:00.00023882388519
OnlineDotComHuntsville00052009-09-07 00:00:00.00019931993379
... It shows that there is more than one...
November 22, 2009 at 1:29 pm
This following query gives me exactly what I need except the companyname and districtname columns need to be eliminated
1) when the districtname is empty, the companyname becomes the...
November 22, 2009 at 2:29 am
arun.sas (11/21/2009)
TheHTMLDJ (11/20/2009)Im not sure what you meant by what formats need to be retrieved.
I mean
Records must be in this specific order:
OnlineDotCom (Company totals)
Memphis (District totals)
0001 (storeNbr totals)
0002 (storeNbr...
November 21, 2009 at 12:36 am
Ok, from the sample data I assumed that the company is static, so that I removed the company from order by class, how ever when the change of the order...
November 20, 2009 at 11:57 pm
arun.sas (11/20/2009)
TheHTMLDJ (11/20/2009)
Post the schema of the booksales table
Do you mean my first table definition?
Yes, but not now, because you edit the first post, and what formats do need to...
November 20, 2009 at 11:38 pm
Post the schema of the booksales table
Do you mean my first table definition?
November 20, 2009 at 11:07 pm
Viewing 15 posts - 1 through 15 (of 38 total)