Tuesday 18 November 2014

Daily Intake of PROTEINS, CALCIUM,CARBOHYDRATES & FIBRE

DAILY INTAKE NUTRIENTS SUMMARY
--------------------------------------------------------



Proteins :
----------
Babies need about 10 grams a day.
School-age kids need 19-34 grams a day.
Teenage boys need up to 52 grams a day.
Teenage girls need 46 grams a day.
Adult men need about 56 grams a day.
Adult women need about 46 grams a day (71 grams, if pregnant or breastfeeding)
You should get at least 10% of your daily calories, but not more than 35%, from protein, according to the Institute of Medicine.

Carbohydrates :
---------------
The average 1,800-calorie diet should contain between 210 and 290 grams of carbohydrates each day, which is equal to 45 to 65 per cent of your daily calories. 
--225 to 325 grams of carbohydrates each day if you normally consume around 2,000 calories

Fibre :
-------
Women need 25 grams of fiber per day, and men need 38 grams per day, according to the Institute of Medicine.

Calcium :
---------
1-3 years: 700 milligrams daily
4-8 years: 1,000 milligrams daily
9-18 years: 1,300 milligrams daily
19-50 years: 1,000 milligrams daily
51-70 years: 1,200 milligrams daily for women; 1,000 milligrams daily for men
71 and older: 1,200 milligrams daily








Sunday 31 August 2014

SQLSERVER TIPS & TRICKS

--For Single Quote Special Character, need to use Single quote 2 times.
CHARINDEX :
charindex('"',BRule)

LEAD & LAG :
select RId,a.t_Attribute, LEAD(a.t_Attribute) over(partition by RId,a.Ctribute order by RId,a.Ctribute) Leadvalue, LAG(a.t_Attribute) over(partition by RId,a.Ctribute order by RId,a.Ctribute) LagValue,a.Ctribute
from  PCOLS

SUBSTRING & REPLACE :
1)substring(ppin,1,len(RIdentifier)
2)replace(brule,'.','_')


 

TALEND TIPS & TRICKS

CONTAINS & EQUALS :

row1.contains("ram")
row2.equals("Name")

LASTINDEXOF :
("tFileList_1_CURRENT_FILE")).lastIndexOf("."))

SUBSTRING:
Input  :  "ABCD".substring(0,2)
Result :   ABC

GETTING CURRENT FILEPATH  IN tFILELIST :
((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

GETTING CURRENT FILENAME FROM  tFILELIST :
((String)globalMap.get("tFileList_1_CURRENT_FILE")).substring(0,((String)globalMap.get
("tFileList_1_CURRENT_FILE")).lastIndexOf("."))

replace() Example :
-------------------------

we can use this for replacing special characters in a string
String input_row="abcd:[],kdkkxyzkll:[],";


 
String abc="{\"NOTIFICATION_RESPONSE\":{"+input_row.replace(":[],",":\"\"")+"}}";
System.out.println(abc);
Output : 
-----------
{"NOTIFICATION_RESPONSE":{abcd:""kdkkxyzkll:""}}
Note :  Go for replace() if  replaceAll() is not working.
replaceAll() will not work for dollar ($),doublequotes("),comma(,) etc special characters, in such
cases you can go for replace().

 

Saturday 30 August 2014

MICROSOFT WINDOWS SYSTEM TOOLS

SYSTEM RESTORE :
  1. Navigate to the Start -> All Programs -> Accessories -> System Tools program group.
     
  2. Click on the System Restore program icon.
GUI CHECK DISK COMMAND

1)Right Click on C drive. --> Properties.
2)Go to Tools Tab
3)Click on Check now Button
4) --Automatically File Fix System Errors
5) --Scan for And attempt recovery of Bad sectors
6)Check the above 2 properties
7)Click on Schedule Disk check

Thursday 19 June 2014

USEFUL URLS

BLOOD

BLOOD :
* Your body has about 5.6 liters of blood. 
* This 5.6 liters of blood circulates through the body three times every minute.

HAEMOGLOBIN :

Haemoglobin (Hb) is an iron-containing protein in blood cells that carries oxygen throughout the body. 
The NORMAL LEVEL of haemoglobin in blood is 14-18 mg/dl for men and 12-16 mg/dl for women. 
Low haemoglobin levels are due to Deficieny of below

*IRON 
*Vitamin C 
*Folic acid 
*Vitamin B12

Ways to increase HAEMOGLOBIN LEVELS   : 

FOR IRON :
-----------------
Vegetables :

Leafy vegetables like spinach (palak) and fenugreek leaves (methi), beans and lentils like masoor daal, chole, moong daal, toor daal, urad daal, rajma. Asparagus (Shatwar) 
and sesame seeds (til) are other good sources of iron. 

Grains :           Grains like barley (jav), rice, semolina (sooji), bajra and maize (makai) can also be included. 
Dried Fruits :   Dried fruits such as almonds (badaam), dried peaches or raisins (manuka). 
Non-Veg :        Meat and fish  


FOR VITAMIN C :  Vitamin C rich foods helps the body to absorb iron from foods. 
-----------------------
Fruits :          guava (peru/amrud), kiwi, papaya, oranges, strawberries and grapefruit. 
Vegetables :  capsicum (Shimla mirch), broccoli (hara phool gobi), cabbage (Gobi), tomatoes and spinach (palak). 


FOR FOLIC ACID : 
----------------------------
Fruits, Veg :  lentils, dried beans, peas, Brussels sprouts (chota band gobi), banana, corn (makai), beets, pineapple and peanuts. 


DON'TS :
--------------
*If you are deficient in iron you should avoid having calcium rich foods like milk and cheese. They block the absorption of iron. 
*Don’t drink too much of coffee, tea and alcohol either.
*If you are having more of Vitamin C sources then you’ll have to increase the intake of folic acid as well 
 because Vitamin C causes excretion of folic acid from the body

KIDNEYS

Preventive Measures for Kidney related diseases.


1)Drink 2 Litres of water daily.
2)For  a healthy person need to urinate 1 litre daily. Do you?
3)BP & SUGAR checkup once for 3 months of above aged 45.

COURTS : CASES : LAWYERS : JUDGES : ::::::::: VICTIMS : ACCUSED

  *We have got so many SMART people in our COUNTRY. *we have got so many IIT completed SMART students in our COUNTRY. * we have got so many ...