i kindly help me out
i have a table in sql server with transaction id and amount i want to add the amount values of those rows where id is same
i have 4 times 2 in transaction id table now i want to add all the entries in amount column corresponding to the trans id 2.
is there any way
i have c# on front end and sql server 2000 on back end