Please help and guide me, I want to marge some data in same database.
Example: I have two databases server, also two databases are same, and actually (database, servers [SQL server r2], database name as [inteacc, inteacc], table, view, SP, function) everything is same,
DB-1: one is live (Production server) they have one year  data, and, transaction is occurring regularly, in the mean time I have taken a full backup, and restore in [DB-2], after that, I have deleted data from the DB-1 for the first three (3 as Jan1 to March31) month, now live server have 9 month plus current production data, is equal 9 month plus (+), but [DB-2] have only one year data, now I want to take back from [DB-1] and want to include with [DB-2], which is not in [DB-2]. I think SQLTeam experts are understanding my requirement, I hope they will help me recently, waiting to positive feedback.
Head of IT at HATIM Group