Hi guys,
          I wanted to know how to append only a single record from one table to another.I jus want to append certain fields. Could someone help me. I have been stuck for sometime now.Thank you.

Don't know if I understood your question correctly

insert into TableA
select * from TableB where id =1

this will insert only 1 record (where the id =1) into tableA, of course the table structure has to be identical




“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/

Thanks for replyin soon.
                          I wanted to append based on the current key.The source and destination tables r linked and i wanted to append the record when
                DestinationTable.ForeignKey=Sourcetable.PrimaryKey

Hope this question is more detailed.Thanks though.Realy appreciate the effort.

insert into DestinationTable
select c.* from Sourcetable c left join DestinationTable d
on d.ForeignKey=c.PrimaryKey
where d.ForeignKey is null

This will insert all the records into DestinationTable that exist in the Sourcetable but not in DestinationTable
you can limit the records by using TOP

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/