This is really annoying me! I have 2 lines which state:
ALTER TABLE ROSS_LIVE ADD Net_Amount float (20) default (0) NOT NULL;
It creates the column but as a real, not a float. Could someone please tell me what I'm doing wrong? I've copied the code for another project/query I wrote and that one doesn't give me any problems.
I'm awarding 500 points for a quick and working solution.