I would like to insert data from a file in the division of the model is very simple:
table details (Id INT make no nULL pRIMARY KEY (ID)) table item identification (StatementFk INT nOT nULL, ItemNameFk INT nOT nULL, primary key (StatementFk)) table ItemNames (Id INT do not make clear the name NVARCHAR ( 255) Null unique, primary key (ID) table division (ItemFk INT is not blank, primary key (ItemFk)) in table The barrier FKBCDC2F95A77158D3 foreign changes add key (make StatementFk) Reference Statement Table Item barrier FKBCDC2F957105B2A7 changes add foreign key (ItemNameFk) reference ItemNames table TaxonomyDivision barrier FKCFB817265F647111 foreign key (ItemFk) changes add reference items Here the division of the item is a child object and the item is a child object of the statement. Basic data looks like this:
Division1 Division2 Division1 Division3 should be the result:
ItemNames 1, Division1 2, Division2 3, Division3 Statement 1 2 3 4 Item 1,1 2,2 3,1 4,3 Division 1 2 3 4 I think the way forward uses the output But I do not know how to use it in this complex case (I know how to put a bulk etc) Proceed for any feedback. Thank you.
Congratulations,
Christian
I currently loop Is using which is to get it, which is a kind of solution but very slow is not really a set-based approach? Thanks!
Christian
Comments
Post a Comment