try to comment out the below code
CREATE SEQUENCE ROWNUMBER_SEQ;
muse be already created and can directly be used in insert query.
Above code of creating sequence is wrong. please refer below code for creating sequence...
CREATE SEQUENCE ROWNUMBER_SEQ
START WITH 1000
INCREMENT BY 1
Correct syntax for creating table is
CREATE TABLE ROWNUMBER (ROWNUMBER int, BUSINESS varchar(100) );
and if you want to create temprory table then
DECLARE @ROWNUMBER TABLE(ROWNUMBER int, BUSINESS varchar(100) );