ChrisM@Work

Forum Replies Created

Viewing 15 posts - 2,401 through 2,415 (of 10,143 total)

RE: Cannot perform an aggregate function on an expression containing an aggregate or a subquery

paul.howard.raines (6/22/2015)
Thank you all for your very helpful replies.
I broke down my query to remove that "firstname and lastname" nonsense.
Now, my query is running based on criteria like :...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 24, 2015 at 2:07 am

#1807652
RE: order by desc and asc on same column

sqlinterset (6/23/2015)
I have attached the file above to show what i need. Hope this helps. Thanks
Yes I know, I saw it. You need the year as well as the month...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 23, 2015 at 9:30 am

#1807440
RE: Big Data Engineers

Being neither big nor an engineer I'm not really qualified to play with any data, but I do, and there are plenty of tables under the roof here which are...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 23, 2015 at 9:03 am

#1807423
RE: order by desc and asc on same column

sqlinterset (6/22/2015)
I have a table has data of all months. i want to have this table data in the form as first it lists data
from 1 month to current...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 23, 2015 at 8:59 am

#1807420
RE: Are the posted questions getting worse?

Alvin Ramard (6/22/2015)
GilaMonster (6/22/2015)
It's starting to look like the replication which keeled over last week did so because the passwords on the distributor were changed. If I've lost my entire...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 22, 2015 at 8:54 am

#1807061
RE: executing a cte

djj (6/22/2015)
Since I did not write the stored procedure, I wanted to check the behavior before possible re-write.
I have actually run across something similar some place but I did not...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 22, 2015 at 8:46 am

#1807053
RE: Eliminating a Distinct SORT operation

lmarkum (6/19/2015)
I have an UPDATE statement that joins two table by SendId. One table, I'll call it T1, has a clustered index on SendId ASC. The other table...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 22, 2015 at 7:50 am

#1807034
RE: Are the posted questions getting worse?

Sean Lange (6/19/2015)
Anybody have the mind reading apparatus? I have misplaced mine and could use it over here. http://www.sqlservercentral.com/Forums/Topic1696091-2799-1.aspx
I'm with Alvin on this one Sean - walk away. The OP's...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 19, 2015 at 10:03 am

#1806757
RE: Cannot perform an aggregate function on an expression containing an aggregate or a subquery

Alan.B (6/18/2015)
ChrisM@Work (6/18/2015)
You will find this much easier to work with if you can reduce the clutter, and one way of doing this is to encapsulate sections of the code...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 19, 2015 at 2:06 am

#1806600
RE: Cannot perform an aggregate function on an expression containing an aggregate or a subquery

paul.howard.raines (6/18/2015)
ChrisM@Work (6/18/2015)
Does this simplification work for you? We can add Clean and Unclean next.
SELECT
RES.method,
payment_id = SUM(CASE WHEN Filter = 1 THEN 1 ELSE 0 END),
[status] =...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 19, 2015 at 1:54 am

#1806598
RE: Are the posted questions getting worse?

Sean Lange (6/18/2015)
Ed Wagner (6/18/2015)
Eirikur Eiriksson (6/18/2015)
Sean Lange (6/18/2015)
Eirikur Eiriksson (6/18/2015)
Too busy to respond and I think it's time to introduce "crystal bullets" since the C-ball is a no show...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 19, 2015 at 1:45 am

#1806596
RE: help in making query

sqlinterset (6/18/2015)
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.
GilaMonster (6/18/2015)
It's...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2015 at 8:16 am

#1806390
RE: help in making query

sqlinterset (6/18/2015)
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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2015 at 8:05 am

#1806383
RE: help in making query

sqlinterset (6/18/2015)
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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2015 at 7:16 am

#1806358
RE: Update or something else

vceklic (6/18/2015)
Hi everyone,
Can someone help me solve this:
I have 2 tables that look something like this:
Table Price:
id - int
price - varchar
validFrom - datetime
validTo - datetime
itemId - int
....
Table sales:
id - int
price...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2015 at 5:48 am

#1806324

Viewing 15 posts - 2,401 through 2,415 (of 10,143 total)