network profile
| bio | website | dailytip.net |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year |
| seen | May 22 at 20:55 | |
| stats | profile views | 7 |
|
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 |
