Monthly Archives: February 2013

The Road To A Legacy

Posted on by
2

This post is about my great, great, great, great, great, great, great, great, great, great, great, great, great, great, great, great-grandfather, Reuben Dye.  He settled in the Flint Township area of Michigan back in 1843 so he wasn’t that old but he was really great.

dye_roadThe reason he was so great is he was ahead of his time.  He was one of the first of about eight settlers in that Michigan area.  He had a farm and a road that eventually became Dye Road.  This was 50 years before gas buggies were invented.

Eventually Flint, the town to the east, became the automotive capital of the world.. So whether he was forward thinking or just plain lucky, I will never know. But what I do know is he is dead but his legacy lives on via that well-traveled road in Michigan.

Cheating Death By Procrastination

Posted on by
4

Here is my logic.  If most people retire at age 65 and the average life expectancy is 84 years, than that means most people live 19 years after retirement.

pushretirementThus if you postpone retirement, you should postpone death.

In other words, if I delay retirement until age 75, then I should live to age 94, right?

I gotta think positive.  I need time to rebuild my nest egg.

Sybase SQL Challenge – Sum Of Max Values

Posted on by
Reply 
--------DATA in Cat_Tbl---------------------------
Cat1           Cat2          Value
a              e1            113
b              e1            14
a              e2            15
c              e3            13
a              e1            13
a              e2            11
c              e4            1

Sybase

PROBLEM:

For each distinct value in Cat1, user wants to find maximum of Values grouped by Cat2 and then sum them up. 

 

 

Step 1: User wants to extract the following rows for example where Cat1 = ‘a’.

Cat1 Cat2 Value 
a    e1   113 
a    e2   15 
a    e1   13 
a    e2   11

Step 2: User wants to extract maximum corresponding to Cat1 and Cat2:

Cat1 Cat2 Value 
a    e1   113 
a    e2   15

Step 3: User wants to sum the Values for Cat1.

Cat1 SumOfValueColumn 
a    128 
b    14 
c    14

stackoverflow

 

 

 

 

SOLUTION 1 USING TEMPORARY TABLE #Max_Cat_Tbl

select Cat1, Cat2, max(Value) Maxvalue 
into #Max_Cat_Tbl from Cat_Tbl 
group by Cat1, Cat2 order by 1, 2 
select Cat1, sum(Maxvalue) 
from #Max_Cat_Tbl 
group by Cat1 
order by Cat1 
drop table #Max_Cat_Tbl 
go

SOLUTION 2 USING VIEW Max_Cat_Tbl_View

create view Max_Cat_Tbl_View 
( Cat1, Cat2, Maxvalue ) as 
select Cat1, Cat2, max(Value) 
from Cat_Tbl 
group by Cat1, Cat2 
select Cat1, sum(Maxvalue) 
from Max_Cat_Tbl_View 
group by Cat1 
order by Cat1 
go

Good SQL, good night.