can you give me as example !!

works well thanks guys

this is what i am doing

insert into #t1(col1, col2, col3, col4, col5)

select col1 col2 col3 col 4 col5 from R1

where

R1.col1 > 0

and R1.col5...

i am trying 5 columns of data from 5 different tables into one table

tableA ,TableB, tableC , tableD , tableE,

colA. colb ,colc , colD , colE,

s, p, ...

table1

col1 col2 col3 col4 col5 col6 col7 col8 col9 col10

tableA tableB tableC tableD tableE

colA ...

you can use common table expressions as well

some thing like

; with temptable

as

( select col, col2, row_number() over

( partition by col1,col2, order by col1,col2 )...

and also table3 is a view

ohh yeh i got it , never mind

thanks again

thanks for the quick response , and i forgot to mention i am using two comparisons as well

with the where clause

eg

where

col1 is null

and

col2...

where can i get that ?

well i have used the "for xml auto" with the select statement in the query editor of my oledb source and used a flate file destination and directed to a...

well got it all figured out ...thanks ny ways

sorry for being opaque ...actually they want the work done using the data conversion transformation , so basically i have to use the flate file source and then use the...

once converted , it will be stored in the records and they went it in the formate as mentioned above (in a table)