<div>
<pre><code id="code-20-37853026-1">select a.* from expensereport a inner join drives b
on a.driveid=b.driveid</code></pre>
</div>


select a.* from expensereport a inner join drives b
on a.driveid=b.driveid

<div>
Wouldn't that still give you the same error??
</div>


Wouldn't that still give you the same error??

<div>
&lt;&lt; Conversion failed when converting the varchar value 'No &nbsp;send me to confirmation page now' to data type int&gt;&gt;<br />
I don't see a column &nbsp;'No &nbsp;send me to confirmation page now' in your query. So I think there is a view involved that isn't correct.
</div>


<< Conversion failed when converting the varchar value 'No  send me to confirmation page now' to data type int>>
I don't see a column  'No  send me to confirmation page now' in your query. So I think there is a view involved that isn't correct.

<div>
This is because the data type of DriveID do not match between Drive table and ExpenseReport table.
</div>


This is because the data type of DriveID do not match between Drive table and ExpenseReport table.

<div>
<div class="content wysiwyg-content">
need to find all rows from drive where the driveid is in the expensereport table<br />
<br />
select drives.driveid as 'Apple.drives.driveID', ExpenseReport.driveID as 'Po.ExpenseReport.driveID'<wbr /><br />
from ExpenseReport with(nolock)<br />
inner join aserver.apple.dbo.drives drive with(nolock) on ExpenseReport.driveID = drive.driveid<br />
where drive.driveid = ExpenseReport.driveID<br />
<br />
my error: Error on the 1st line: Conversion failed when converting the varchar value 'No &nbsp;send me to confirmation page now' to data type int.
</div>
</div>


need to find all rows from drive where the driveid is in the expensereport table

select drives.driveid as 'Apple.drives.driveID', ExpenseReport.driveID as 'Po.ExpenseReport.driveID'
from ExpenseReport with(nolock)
inner join aserver.apple.dbo.drives drive with(nolock) on ExpenseReport.driveID = drive.driveid
where drive.driveid = ExpenseReport.driveID

my error: Error on the 1st line: Conversion failed when converting the varchar value 'No  send me to confirmation page now' to data type int.

find matches between two tables

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.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.