I presume that the FROM and WHERE clauses are the same for both statements?

INSERT INTO FINANCEFLASH(recharge_no, recharge_value)

SELECT COUNT(*), SUM(GACCENTRYA.AMTLOC_0 * GACCENTRYD.SNS_0)

FROM ...

You do not...

The UPDATE statement is only valid for changing existing RECORDS.

To "update" a table, you use UPDATE (records that are already present), INSERT (records that are not yet present) and DELETE...

UPDATE A SET FlagId = 1;

Unless I am overlooking something, this is basic SQL.

The "A" attribute on a Windows file indicates that it is "ready for archiving". This is a (basic) feature of Windows to support incremental backup: when a file is changed...

If you want to reduce a one-to-many TABLE1/TABLE2 relationship to a one-by-one relationship, you will have to use aggregation to perform a reduction on TABLE2.

For example:

SELECT t1.PRINTKEY, t1.T1_COL_A, MAX(t2.T2_COL_B),...

It's very simple. The wildcards in SQL SERVER are '%' (percent) for "any number of arbitrary characters" and '_' (underscore) for a single arbitrary character, not the '*' (asterisk) and...

Forget about using stored procedures in SELECTs.

I tried to fool SQLServer once by creating a user-defined function, in which I called the stored procedure and put the results in variables,...

Exactly what sprang to my mind! Get people used to entering their identity and bank data into a website for safety, and they will soon give it to any site...