Viewing 15 posts - 32,536 through 32,550 (of 59,102 total)
Perry Whittle (9/18/2011)
Jeff Moden (9/18/2011)
This is just so wrong... What is the name of the school where they are teaching you to do such a thing in SQL Server?
RBARs R...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 18, 2011 at 7:02 pm
"Unordered"... have you an example of when ROLLUP produces incorrectly ordered results?
Also, what do you mean by it not taking us "very far forward"? unless I'm misunderstanding the requirements...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 18, 2011 at 6:25 pm
daveriya (9/17/2011)
YA LIKE THIS,BUT CAN WE USE SUM(SUM(FIELD)) ????
Just so you know, all caps in your posts is frequently identified as yelling at someone. I recommend avoiding the use...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 18, 2011 at 1:50 pm
Please see the following article...
http://www.sqlservercentral.com/articles/T-SQL/72503/
--Jeff Moden
Change is inevitable... Change for the better is not.
September 18, 2011 at 1:35 pm
{Edit} Post withdrawn... wrong post.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 18, 2011 at 1:18 pm
pathuripr (9/17/2011)
Question # 11: Create a loop to...
This is just so wrong... What is the name of the school where they are teaching you to do such a thing in...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 18, 2011 at 1:05 pm
karthikeyan-444867 (9/14/2011)
Thanks a lot 🙂 I understand the concepts now.
I appreciate you for spending some time for me to give a detailed...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 18, 2011 at 12:46 pm
Rokh (9/16/2011)
Well I'll be dammed. The first query is faster then the more readable and shorter query...I've tested it using 19 million records.
In that case, could you post the CREATE...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 18, 2011 at 12:38 pm
Ah... understood. So, are you all set now?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 18, 2011 at 12:08 pm
I sure do appreciate all the great feedback you good folks have given. It's been my pleasure to serve.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 18, 2011 at 12:04 pm
I still need to know which table ToCity and SalesAmount are in to optimize this to the tune of about a 300%+ performance gain. Are they in the Sales_City...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2011 at 6:05 am
Frances L (9/15/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2011 at 9:00 pm
Also, if your table has more cities in it than what you have in the query, add the following WHERE clause just before the GROUP BY...
...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2011 at 8:52 pm
Rokh (9/15/2011)
Using this query:
select
b.Sold_To_Country,
...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2011 at 8:36 pm
jason.stamm (9/15/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2011 at 8:16 pm
Viewing 15 posts - 32,536 through 32,550 (of 59,102 total)