I am kind of new to sql server and I am stuck on this. It may sound stupid and simple but here is my situation:
CREATE TABLE For_Test(ID int not null,Name varchar(255),Amount decimal(18,2))
INSERT INTO For_Test VALUES (1,'A',220)
I just want to add amount of ID 1,2 and 3 excluding 4. There will be more than four rows in a table. So, how to do this?