156 reputation
1
bio website dailytip.net
location
age
visits member for 2 years, 4 months
seen Jul 3 '13 at 13:05

Jun
5
comment best way to consolidate data
Yeah I was afraid it would come to that. I really wish ROLL UP was better implemented. I tried it but I have to do so much additional work to get the rows I dont need filtered out. Not to mention that so many fields rely on what is being grouped.
Jun
5
comment best way to consolidate data
Because if there is a change (lets say the spec changes in one of the "sum" columns) then I have to change it three times which is error prone. Espeically when you have about 100 calculated fields.
Jun
5
comment best way to consolidate data
The right side is one. THe left side is dynamic. Ie, include_all, include_school and include_baord
Jun
5
asked best way to consolidate data
May
7
comment removing group by clause with SUM
Hi, the problem is that some of the columns, for example school in the original post, change depending on how its grouped by.
May
7
comment removing group by clause with SUM
Yes. I beleive a1ex07 has the right idea (though I havn't tried your code and I am not sure what the PARTITION is doing, still learning). The problem with a1ex07's idea is that some of the columns change depending on how its grouping by. If I GROUP BY A, B, C then my id = NULL but if I GROUP BY A, B then id = 100000 for example
May
5
comment removing group by clause with SUM
do you have an example or documentation you might be able to share?
May
4
asked removing group by clause with SUM
May
4
comment How to consolidate script duplication?
Hello, thanks I was thinking that. But I forgot to add that there might be group by or other where clause conditions and obviously you cant say group by @var
May
4
asked How to consolidate script duplication?
Apr
30
awarded  Student
Apr
30
comment How do you ensure accuracy of your query
It was somewhat pseudocode. I prefer to do it in one query but can create a seperate script to do another set. Or maybe at the bottom. Is there any other way
Apr
30
asked How do you ensure accuracy of your query