<div>
Try this - <br />
<br />
SELECT *<br />
INTO dbo.database2.tblAttendanc<wbr />e<br />
FROM dbo.database1.tblAttendanc<wbr />e<br />
WHERE dbo.database1.tblAttendanc<wbr />e.Redeterm<wbr />ination = '1'
</div>


Try this -

SELECT *
INTO dbo.database2.tblAttendance
FROM dbo.database1.tblAttendance
WHERE dbo.database1.tblAttendance.Redetermination = '1'

<div>
My bad! sjwales is spot-on , sorry for the confusion.
</div>


My bad! sjwales is spot-on , sorry for the confusion.

<div>
EDIT: Oops, replied to wrong Question :)
</div>


<div>
INSERT INTO database2.dbo.tblAttendanc<wbr />e(field1, field2, field3,Redetermination)<br />
&nbsp; &nbsp; &nbsp;SELECT field1, field2, field3 , 1 as Redetermination<br />
&nbsp; &nbsp; &nbsp;FROM database1.dbo.tblAttendanc<wbr />e
</div>


INSERT INTO database2.dbo.tblAttendance(field1, field2, field3,Redetermination)
     SELECT field1, field2, field3 , 1 as Redetermination
     FROM database1.dbo.tblAttendance

<div>
<div class="content wysiwyg-content">
I have database1 with tblAttendance. &nbsp; I also have database2 with tblAttendance. &nbsp;There is a column in the table called Redetermination which determines which records will be migrated to the new database and table.<br />
<br />
I would like to transfer all records from dbo.database1.tblAttendanc<wbr />e where tblAttendance.Redeterminat<wbr />ion = 1 &nbsp; to dbo.database2.tblAttendanc<wbr />e<br />
<br />
How can I do that using SQL statments. &nbsp;Unless there is also a wizard that does this function...
</div>
</div>


I have database1 with tblAttendance.   I also have database2 with tblAttendance.  There is a column in the table called Redetermination which determines which records will be migrated to the new database and table.

I would like to transfer all records from dbo.database1.tblAttendance where tblAttendance.Redetermination = 1   to dbo.database2.tblAttendance

How can I do that using SQL statments.  Unless there is also a wizard that does this function...

copy records from one identical table to another identical table on two different datbases

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.