Under the same configuration, if I query below I can load data into table without issue.
select *  FROM ...

Yes Sir.

The back end is Oracle.  Is there anyway i can make below statement to work? Thank you.
to_char(trunc(load_date, 'IW') - 1, 'YYYY/MM/DD') | | ' -...

I guess i am just consuming it. So is there anything else i can do in SSRS besides "Add Calculated Field" ? thank you.

Thank you Pietlinden. 

I tried right click on my dataset. All i see is only "General" option in Dataset Properties. There is no "Add Calculated Field" . thank you.

Sorry. I dont know anything about create table script. Because i was just using the dataset someone created for me. 
When i drag and drop into design area, it already...

Thank you so much Sue for the solution.

Thanks Sue.

I meant the script I did earlier was to copy the data from columns in table 1 to columns in table2.

Now both tables have the same data....

thank you very much everyone.

I was able to achieve that with all your generous helps.

thank you

Thank you very much Jason. None of the queries is working.

The assignment is to exclude single LEV5 data and only show all the duplicate LEV5.

thanks.

Bf_ORGN_CD ...

Thank you all very much.

Should I apply the whole thing or only below part in my query? thank you

SELECT LEV5

FROM MyCTE

GROUP BY LEV5

HAVING COUNT(*) > 1

)

SELECT MC.*

FROM MyCTE AS...

Thank you all.

I think the result I would like to see is as below

sorry for the confusion.

Bf_ORGN_CD LEV5 ...

Thanks Steve.

When I added below part into my query

group by B.BF_ORGN_CD, B.LEV5, A.BF_ACTY_CD

having count(B.LEV5) >1

none of the records was showed. Not sure if I did something wrong.

thanks.

Thanks Alvin and luiz.

Did you refer that I need to union with another table?

The single query worked fine when I executed. Each one has the data I want.

I...

here is an error msg :ORA-00933: SQL command not properly ended

thanks