Viewing 15 posts - 106 through 120 (of 173 total)
simon phoenix (8/30/2008)
Rog, Jeff
I have problem running this statement
SELECT A.ID,A.DateValue,A.Prd,A.Statusid,
Sum(CASE WHEN B.Statusid=2 THEN 1 ELSE 0 END)
OVER(ORDER BY A.ID
...
August 30, 2008 at 7:19 pm
The common problem of dividing data into groups boils down to creating a dense rank. Here we want a dense rank on Statusid but ordered by ID (or DateValue). This...
August 29, 2008 at 10:06 pm
GSquared (8/28/2008)
The second query then takes each set and gives it a...
August 28, 2008 at 10:59 pm
dphillips (8/26/2008)
All of this aside, however, was to show that one can pull a PIVOT without NULLS, and is only for specific situations.
I should be rich 😀
August 27, 2008 at 12:07 am
Jeff Moden (8/23/2008)
If you want to suppress NULL's caused by missing data in a Pivot, there's no other way to do it than in the final Select.
Kudos for...
August 24, 2008 at 5:45 am
dphillips writes:
>Without the TRANSFORM counterpart, I see absolutely no reason to
>use it in it's current form. I would gladly hear anyone having an
>alternate opinion.
Nicole Bowman writes:
>I too miss...
August 22, 2008 at 4:15 am
Jeff writes
>Ok... show us the code that you would do it in RAC with.
Here yago.
Minimal Rac execute using standard defaults.
Exec Rac
-- Similar to Access transform, the desired aggregates.
@transform='Sum(Amount) as Amt...
August 22, 2008 at 12:11 am
There's nothing like seeing the latest go around of PMS (pivot madness syndrome). And it seems time after time, year after year, release after release there's a contest to see...
August 20, 2008 at 4:43 am
Kudos for bringing attention to Dataphor. But I would point out that Relational 'purists' is the flip side of the idea of sql being relational-like. The latter being equivalent to...
June 25, 2008 at 3:38 am
You let something do it so you don't have to do it yourself. It's called working smart 🙂 Check out Rac, easy and powefull:
June 21, 2008 at 10:46 pm
Check out RAC. It's similar to Access crosstab query but much more powerful with many options. If you like Access you'll appreciate RAC. Especially if you don't want to code...
June 13, 2008 at 6:05 am
The Sql Server Pivot is a no-brainer in the pejorative sense. What were they thinking? 🙂 If you want something that doesn't insult your intelligence and isn't simply the sauce...
June 11, 2008 at 5:32 am
If you'd like to avoid the unpleasantries of dynamic sql for crosstab queries check out the RAC utility. Coding dynamic crosstabs of complexity is like watching sausage made. It can...
June 6, 2008 at 6:52 am
There seems to be a lot of tap dancing around LINQ in the sql server community. And the most salient points about it has little to do with performance questions....
April 26, 2008 at 11:12 pm
Sandy Millon. (10/28/2007)
I wants to clear my concept about Temp Table,Table Variable & Common Table Expression Concept.
Some one is interested in a concept and not code? How interesting:)
If you...
October 31, 2007 at 12:31 am
Viewing 15 posts - 106 through 120 (of 173 total)