Belated Birthday wishes to ancient City Chennai. Chennai city still have strong records after the attack from M10 Ship.
We chennai peoples take more care to save the ancient symbols and buildings in chennai.
Happy Birthday to Chennai.
Sunday, August 24, 2008
Monday, June 23, 2008
LINQ for right outer join and not equal
Hi to all,
Today i got struggle for query right outer join and not equal condition. finally i got result by this way. I have hope this will help to you.
var sorder= (from S in qryGen.T_order
select new { S.F_order_Id, S.F_order_Number }).Except
(from P in qryGen.T_Purchases
join G in qryGen.T_order on P.F_order_Id equals G.F_order_Id
select new { P.F_order_Id,G.F_order_Number });
Please post your comments!
Cheers!
Murali
Today i got struggle for query right outer join and not equal condition. finally i got result by this way. I have hope this will help to you.
var sorder= (from S in qryGen.T_order
select new { S.F_order_Id, S.F_order_Number }).Except
(from P in qryGen.T_Purchases
join G in qryGen.T_order on P.F_order_Id equals G.F_order_Id
select new { P.F_order_Id,G.F_order_Number });
Please post your comments!
Cheers!
Murali
Saturday, June 21, 2008
LINQ Query with group,join and sum
var gname = from S in qryGen.T_Grn_details
join G in qryGen.T_Grade_Masters on S.F_GradeMaster_Id equals G.F_GradeMaster_Id
where S.F_Grn_Id == int.Parse(cboGRNNumber.SelectedValue.ToString())
group S by new {G.F_GradeName_Id,G.F_GradeName} into d
select new {d.Key.F_GradeName_Id,
d.Key.F_GradeName,
TotalWeight = d.Sum(o => o.F_Weight)};
join G in qryGen.T_Grade_Masters on S.F_GradeMaster_Id equals G.F_GradeMaster_Id
where S.F_Grn_Id == int.Parse(cboGRNNumber.SelectedValue.ToString())
group S by new {G.F_GradeName_Id,G.F_GradeName} into d
select new {d.Key.F_GradeName_Id,
d.Key.F_GradeName,
TotalWeight = d.Sum(o => o.F_Weight)};
Saturday, May 31, 2008
Tuesday, May 6, 2008
Did You Know?
* Polio remains a serious threat in India, notwithstanding a massive campaign to eradicate it. Indian children continue to die of vaccine-preventable diseases such as measles.
* Malnutrition affects nearly half of all children under the age of five in India.
* Anaemia affects the vast majority of pregnant women and teenage girls in India, stunts children’s growth, and is a leading cause of maternal death and babies with low birth weight.
* Estimates of the number of people in India living with HIV/Aids range from 2.2-7.6 million.
* Diarrhoea, often caused by unsafe drinking water or poor sanitation, is the second leading cause of death among children in India. Access to clean drinking water has improved in recent years, but 122 million households still lack toilets.
* School enrolment is increasing in India, but retention and completion rates remain low in part because of the poor quality of the education system, which emphasizes memorization over problem solving.
* Indian women face many forms of gender discrimination. A national preference for male children has led to an increasing gap in gender ratios of children under the age of six; a trend that may be attributed to female foeticide.
* The December 2004 tsunami struck India’s southeast coast and the Andaman and Nicobar Islands, killing thousands and causing widespread destruction.
* School enrolment in India has increased over the past decade, and the gender gap in enrolment rates has been reduced dramatically. Literacy rates have also improved.
* The Indian government has made school sanitation and hygiene an integral part of its national sanitation and water supply programmes.
* In 1990, India had an under-five mortality rate of 123 (per 1 000 live births) and in the year 2004, the same rate was 85.
* In 1990, India had an infant mortality rate of 84 (per 1 000 live births) and in the year 2004, the same rate was 62.
* The total population of India reached 1 087 124 000 in 2004.
* In 2002, 82 percent of the rural population in India used improved drinking water sources.
* In 2002, 18 percent of the rural population in India used adequate sanitation facilities.
* The male adult literacy rate in India was 73 percent and the female was 48 percent during the period 2000-04.
* Only 7 percent of all Indians have telephones and a mere 2 percent are Internet users.
* The life expectancy has increased from 49 years in 1970 to 64 years in 2004.
* Thirty-five percent of all people in India live on less than one dollar (US) per day.
Source: UNICEF
* Malnutrition affects nearly half of all children under the age of five in India.
* Anaemia affects the vast majority of pregnant women and teenage girls in India, stunts children’s growth, and is a leading cause of maternal death and babies with low birth weight.
* Estimates of the number of people in India living with HIV/Aids range from 2.2-7.6 million.
* Diarrhoea, often caused by unsafe drinking water or poor sanitation, is the second leading cause of death among children in India. Access to clean drinking water has improved in recent years, but 122 million households still lack toilets.
* School enrolment is increasing in India, but retention and completion rates remain low in part because of the poor quality of the education system, which emphasizes memorization over problem solving.
* Indian women face many forms of gender discrimination. A national preference for male children has led to an increasing gap in gender ratios of children under the age of six; a trend that may be attributed to female foeticide.
* The December 2004 tsunami struck India’s southeast coast and the Andaman and Nicobar Islands, killing thousands and causing widespread destruction.
* School enrolment in India has increased over the past decade, and the gender gap in enrolment rates has been reduced dramatically. Literacy rates have also improved.
* The Indian government has made school sanitation and hygiene an integral part of its national sanitation and water supply programmes.
* In 1990, India had an under-five mortality rate of 123 (per 1 000 live births) and in the year 2004, the same rate was 85.
* In 1990, India had an infant mortality rate of 84 (per 1 000 live births) and in the year 2004, the same rate was 62.
* The total population of India reached 1 087 124 000 in 2004.
* In 2002, 82 percent of the rural population in India used improved drinking water sources.
* In 2002, 18 percent of the rural population in India used adequate sanitation facilities.
* The male adult literacy rate in India was 73 percent and the female was 48 percent during the period 2000-04.
* Only 7 percent of all Indians have telephones and a mere 2 percent are Internet users.
* The life expectancy has increased from 49 years in 1970 to 64 years in 2004.
* Thirty-five percent of all people in India live on less than one dollar (US) per day.
Source: UNICEF
Wear only Cotton,wool & Silk cloths
While thinking of my contribution in saving earth, I got one more fantastic possible idea.
Cloths made of natural fibres are easily bio-degradable. But in case of Synthetics like Polyester, Nylon etc. takes very long period.
It is simple IDEA, why can't we use only cloths made of Cotton or Wool or Silk (which are comfortable to human body). This will encourage our farmers for cotton crops. In the other way you are securing your co-Indian poor farmers.
So, there is double benefit for us, one side we are saving our earth and in other side we are securing life of our fellow Indian farmers.
Dear friends, you like this Idea or not?
Thanks to my EverGreenEarth Lovers for initiating to think for better Ideas.
Cloths made of natural fibres are easily bio-degradable. But in case of Synthetics like Polyester, Nylon etc. takes very long period.
It is simple IDEA, why can't we use only cloths made of Cotton or Wool or Silk (which are comfortable to human body). This will encourage our farmers for cotton crops. In the other way you are securing your co-Indian poor farmers.
So, there is double benefit for us, one side we are saving our earth and in other side we are securing life of our fellow Indian farmers.
Dear friends, you like this Idea or not?
Thanks to my EverGreenEarth Lovers for initiating to think for better Ideas.
Tuesday, April 22, 2008
Eath Day
Today Earth Day. most of the countries participated in this day. To save environment of the earth. Very bad thing is india is not given that much important to this day.
atleast we can start to change our life for earth. earth is not a seperate one that is us.
Official Web Site
US Government Portal
WWF Celebrates Earth Day in India
atleast we can start to change our life for earth. earth is not a seperate one that is us.
Official Web Site
US Government Portal
WWF Celebrates Earth Day in India
Thursday, April 3, 2008
Wednesday, April 2, 2008
Subscribe to:
Posts (Atom)