ok see this is the data of cdr file ok

--===== If the test table already exists, drop it

IF OBJECT_ID('Temp DB ,table1','U') IS NOT NULL

...

hi jeff thanks for your help i have tried your query to create a view and i have tried it like this :

SELECT dbo.table1.country, dbo.table1.code, dbo.table.rate_min,...

see the data for the first table is like this:

start_date_time ani ...

sorry for the post as i am new to this forum therefore i made this mistake. I am reading a CSV file which contains the whole data, on reading the...