Now A really complex query...

[Daskalos]

well.. thank to szlamany, i saw that my last post was quite simple...
and my problem a bit more complicated..
i'll try to tell exactly what i need
i have a table called Foto, one called Noticia, Area and one called Unidade.

i need to make a copy of everything associated with idUnidade = 17
but in another idUnidade (30)..

so if i have one Row in Noticia with idNoticia = 30 and the idUnidade from that idArea is 17, than i need it to be copied AND the data from table Foto that have the idNoticia = 30, will be copied and idNoticia will be updated to the idNoticia of the new data...



i don't know it can be done only with SQL Server.. so, if don't, could someone suggest a program to help me!?

thanks in advance...

[szlamany]

First I would suggest using a STORED PROCEDURE to create a table variable - load it with the data you want and then INSERT from it.

Keep in mind that you can say something like this in SQL.

Insert into Area
   Select idArea,Nome,30,layoutChamada,quantidade,layout From Area
       Where idUniDade=17

This will create new rows in Area - with the idUniDade of 30, but from a population of data that has the value 17 - basically copying 17 to 30.