harri.reddy (10/24/2012)
no in the file there is no row numberi need to know how to insert data into table which has primary -?foreign key relation.
as you said staging table
can you give me example.like i have given you two tables,can you explain me with that example
Can you give a bit more sample data and the desired output? It's not really clear what you want to do with the flat file rows.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP