<div>
define &quot;insert data from the db normally&quot;<br />
<br />
if the date in the other db is picked-up from file...<br />
<br />
so, what type of file is it? e.g. xml, csv<br />
and what encoding is used? <br />
what operating system does the file reside in? <br />
are there any other operations on the file? e.g. secure FTP<br />
<br />
also; are the columns the same data type and is the collation the same?
</div>


define "insert data from the db normally"

if the date in the other db is picked-up from file...

so, what type of file is it? e.g. xml, csv
and what encoding is used?
what operating system does the file reside in?
are there any other operations on the file? e.g. secure FTP

also; are the columns the same data type and is the collation the same?

<div>
assaadrezk, do you still need help with this question?
</div>


assaadrezk, do you still need help with this question?

<div>
assaadrezk, <br />
<br />
Did you have an opportunity to investigate as suggested <a href="https://www.experts-exchange.com/questions/28701810/SQL-server-identitical-strings-not-matching-SQL-server-2014.html?anchorAnswerId=40910115#a40910115" rel="ugc">here</a>? <br />
<br />
-gg
</div>


assaadrezk,

Did you have an opportunity to investigate as suggested here [https://www.experts-exchange.com/questions/28701810/SQL-server-identitical-strings-not-matching-SQL-server-2014.html?anchorAnswerId=40910115#a40910115]?

-gg

<div>
<div class="content wysiwyg-content">
I have 2 tables : In table 1 we insert data from the db normally , the second we use a text file and bulk insert.<br />
I have one common string (used for join in the two tables) <br />
in case they both shows a string with special character like Maintenance, Repair &amp;&nbsp;Overhead with the same len (41)<br />
&nbsp;when I try to join them , they are not joined anf returns no results <br />
In case it is a word with no special characters such as &nbsp; Agile methodologies works fine ...<br />
\Please help me in this
</div>
</div>


I have 2 tables : In table 1 we insert data from the db normally , the second we use a text file and bulk insert.
I have one common string (used for join in the two tables) 
in case they both shows a string with special character like Maintenance, Repair & Overhead with the same len (41)
 when I try to join them , they are not joined anf returns no results 
In case it is a word with no special characters such as   Agile methodologies works fine ...
\Please help me in this

SQL server identitical strings not matching SQL server 2014

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.