Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Computation Problem. Please help!

Author  Topic 

sikharma13
Starting Member

44 Posts

Posted - 2013-10-26 : 02:05:49
As i posted yesterday about my problem in MySQL, Sir visakh16
helped me.. although this is not a mysql site.. its an MS SQL,
still there are no difference when it comes to queries..

now, i have another question to ask.. i need to compute all the total
columns..

for example, i have table py_abcdeeh and the structure is..

DROP TABLE IF EXISTS "s_abcdeeh"."py_abcdeeh";
CREATE TABLE "s_abcdeeh"."py_abcdeeh" (
"PROVINCE" varchar(30) NOT NULL default '',
"MUNICIPALITY" varchar(30) NOT NULL default '',
"BARANGAY" varchar(30) NOT NULL default '',
"HOUSEHOLD_ID" varchar(30) NOT NULL default '',
"ENTRY_ID" varchar(12) NOT NULL default '',
"LASTNAME" varchar(35) NOT NULL default '',
"FIRSTNAME" varchar(35) NOT NULL default '',
"MIDDLENAME" varchar(35) NOT NULL default '',
"EXT_NAME" varchar(10) NOT NULL default '',
"NO_ELI_FOR_EDUC_GRANT" varchar(1) NOT NULL default '',
"NO_NCOM_EDUC_M1" varchar(5) NOT NULL default '',
"NO_NCOM_EDUC_M2" varchar(5) NOT NULL default '',
"EDUC_GRANT_M1" varchar(5) NOT NULL default '',
"EDUC_GRANT_M2" varchar(5) NOT NULL default '',
"T_EDUC_GRANT" varchar(5) NOT NULL default '',
"NO_NCOM_DEW" varchar(5) NOT NULL default '',
"NO_NCOM_HCV_M1" varchar(5) NOT NULL default '',
"NO_NCOM_HCV_M2" varchar(5) NOT NULL default '',
"NO_NCOM_BHCV" varchar(5) NOT NULL default '',
"FNCOM_M1" varchar(5) NOT NULL default '',
"FNCOM_M2" varchar(5) NOT NULL default '',
"HG_M1" varchar(5) NOT NULL default '',
"HG_M2" varchar(5) NOT NULL default '',
"H_GRANT" varchar(5) NOT NULL default '',
"TOTAL" varchar(5) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

from educ_grant upto total.. how can i compute the desired value.
for example :

wherein the household id's are in select statement..

select * from py_abcdeeh

hhid------egrant1---egrant2---hgrant1----hgrant2---total.....
1232--------300-------200------500---------430------1430....
upto the last record the select statement is holding...

any help would gladly be appreciated! thank you so much!



VFP9.0 via MySQL 5.0

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2013-10-26 : 03:12:17
quote:
although this is not a mysql site.. its an MS SQL,
still there are no difference when it comes to queries

Yes. there is. Refer to http://troels.arvin.dk/db/rdbms/


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-26 : 04:39:39
simply this

UPDATE s_abcdeeh.py_abcdeeh
SET Total= EDUC_GRANT_M1 *1 + EDUC_GRANT_M2 + HG_M1 + HG_M2


Also the fields should be of type int and not varchar as they've numerical data as per you posted sample data

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -