Hi I am using SQL express 2005 and I need to be able to take old data (data inputed two weeks ago or older)from a table in data base A and move it to a table in database B.
I have very little experience with SQL so any suggestions will be greatly appreciated. Thank you.
just fire this quesry you will get the data from which date you want
Select * INTO databaseB.dbo.table1 from databaseA.dbo.table2 where Date='my condition'where
dbo is my schemaname
database B is my new Database
database A is my old Database
table1 is create new table in DatabaseB
table2 is a table from where i want to cory the data.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.