u mean in header row delimiter i need to put *

but how can i write primary -?foreign key in first table(i1)

TH*4.2*876545*P~~IO*3456*color~ n

my data would be like this

table1

id t1 t1 ...

no in the file there is no row number

i need to know how to insert data into table which has primary -?foreign key relation.

as you said staging table

can...

well,

they gave me some tables(approx 9) tables and field that they want to fecth only those field.

they all r master table.so do i need to make table that connect this...

guys,

they gave me docs,which field they need and what lenght of data type.

my question is ,should i create logical /physical data model or start making table in sql server manually.

let...

guys,

they gave me docs,which field they need and what lenght of data type.

my question is ,should i create logical /physical data model or start making table in sql server manually.

let...

well.

its not in my hand,my company wants me to do it

thanks for your response,

for my other question,

it was something ,if i define global variable in sp,will it can be access in inside stored procedure

ok.

select count(*) taking 0 seconds,and select * from taking 0.08

but why?i dont know that

i dont hv millions of rows ,for simple rows like 100,its time i s 0

i am attaching 2008r2 version to my sql server 2008r2

can u give me example with what component do i need to use

but what should i do for referential integrity

its working.thanks a lot